Sample Header Ad - 728x90

InnoDB crashes on trx rollback

4 votes
0 answers
1726 views
I have InnoDB assertion failure during the trx rollback 160316 10:47:31 InnoDB: Rolling back trx with id 5ADBE4173, 1 rows to undo 160316 10:47:31 InnoDB: Assertion failure in thread 140611160659712 in file fut0lst.ic line 83 InnoDB: Failing assertion: addr.page == FIL_NULL || addr.bof I've managed to start MySQL with innodb_force_recovery = 3 (SRV_FORCE_NO_TRX_UNDO). Now I can see this transaction in INFORMATION_SCHEMA: mysql> select * from information_schema.innodb_trx\G *************************** 1. row *************************** trx_id: 5ADBE4173 trx_state: RUNNING trx_started: 2016-03-16 11:16:08 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 1 trx_mysql_thread_id: 0 trx_query: NULL trx_operation_state: NULL trx_tables_in_use: 0 trx_tables_locked: 0 trx_lock_structs: 0 trx_lock_memory_bytes: 376 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: REPEATABLE READ trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_adaptive_hash_latched: 0 trx_adaptive_hash_timeout: 10000 1 row in set (0.00 sec) mysql> It also appears in SHOW ENGINE InnoDB STATUS: TRANSACTIONS ------------ Trx id counter 5ADBE4303 Purge done for trx's n:o < 0 undo n:o < 0 History list length 1897 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 56285, OS thread handle 0x7f31cdca4700, query id 174313 localhost root show engine innodb status ---TRANSACTION 5ADBE4173, ACTIVE 590 sec recovered trx , undo log entries 1 ---------------------------- END OF INNODB MONITOR OUTPUT ============================ MySQL documentation states that "You cannot cancel transactions that are in the process of being rolled back." So is there any way to know which tables it uses? And if it is, can I just drop the offensive tables and restart server back with innodb_force_shutdown = 0?
Asked by gevial (141 rep)
Mar 16, 2016, 08:43 AM
Last activity: Jul 20, 2023, 07:43 PM