Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.34, 10.1.30, 10.2.12, 10.3.3, 10.4.0, 10.5.0
Description
The fix of MDEV-21217 is incomplete. As observed in MDEV-22889, a condition in trx_rollback_resurrected() is wrongly referring to !srv_is_being_started instead of the proper condition srv_shutdown_state != SRV_SHUTDOWN_NONE. As a result, the recovered transaction would remain in its incomplete state, holding record and table locks and conflicting with any new transactions that may be started.
The purge of transaction history is not affected by this bug, because it will be disabled by innodb_force_recovery=2.
Attachments
Issue Links
- is blocked by
-
MDEV-21217 innodb_force_recovery=2 may wrongly abort the rollback of recovered transactions
- Closed
- relates to
-
MDEV-22889 InnoDB occasionally breaks the isolation of a recovered transaction
- Open