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

Vytvořeno 2y | 30. 12. 2021 16:03:58

Chcete-li přidat komentář, přihlaste se

Mmm7777
2y | 1. 1. 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