Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.4 Reference Manual  / ...  / The InnoDB Storage Engine  / InnoDB Troubleshooting  /  Troubleshooting Recovery Failures

17.20.2 Troubleshooting Recovery Failures

Checkpoints and advancing the checkpoint LSN are not permitted until redo log recovery is complete and data dictionary dynamic metadata (srv_dict_metadata) is transferred to data dictionary table (dict_table_t) objects. Should the redo log run out of space during recovery or after recovery (but before data dictionary dynamic metadata is transferred to data dictionary table objects) as a result of this change, aninnodb_force_recovery restart may be required, starting with at least theSRV_FORCE_NO_IBUF_MERGE setting or, in case that fails, theSRV_FORCE_NO_LOG_REDO setting. If aninnodb_force_recovery restart fails in this scenario, recovery from backup may be necessary.