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

Erstellt 3y | 30.12.2021, 16:03:58

Melden Sie sich an, um einen Kommentar hinzuzufügen

Mmm7777
3y | 01.01.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