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

Created 3y | Dec 30, 2021, 4:03:58 PM

Mmm7777
3y | Jan 1, 2022, 7:30:34 PM

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