Hello,Running a simple query against corrupted innodb table is crashing mysql instance .
 table test.xyz got corrupt during crash and truncate table command was in progressing when mysql crash , now

running a simple select * query is also crashing db .

mysql> use test;
Database changed
mysql> select * from xyz;
ERROR 2013 (HY000): Lost connection to MySQL server during query

mysql>

mysql>

mysql> select * from xzy;

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

ERROR

Can't connect to the server

Error Log :

 [ERROR] Build InnoDB index translation table for Table ./test/xyz failed

[ERROR] Table ./test/xyz has no primary key in InnoDB data dictionary, but has one in MySQL! If you created the table with a MySQL version < 3.23.54 and did not define a primary key, but defined a unique key with all non-NULL columns, then MySQL internally treats that key as the primary key. You can fix this error by dump + DROP + CREATE + reimport of the table.


[Warning] Table ../test/xyz key_used_on_scan is 0 even though there is no primary key inside InnoDB.


[ERROR] Innodb could not find key n 0 with name PRIMARY from dict cache for table test.xyz

• Any suggestion on how to recreate table will be highly appreciated .

Last edited by Albert12 (3/24/2022 9:42 am)