MariaDB - sec index record

[Error] InnoDB: Clustered record for sec rec not found InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0

One of those errors which cause several hours of searching for reason and table repairing.

The solution could be: alter table table_name engine=innodb;

on every table with corrupted index

Creato 2y | 30 dic 2021, 16:03:58

Accedi per aggiungere un commento

Mmm7777
2y | 1 gen 2022, 19:30:34

And small script to check mismatch between calculated checksum and stored checksum. https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html

#!/bin/bash
for i in $(ls /var/lib/mysql/niftycent_db/*.ibd)
do
  echo "$i"
  innochecksum $i
  echo "----------------------------------------------------------------------------------------------"
done

Mmm7777