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

Létrehozva 3y | 2021. dec. 30. 16:03:58

Jelentkezéshez jelentkezzen be

Mmm7777
3y | 2022. jan. 1. 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