The max_trx_id maintained by trx_sys during the startup phase of InnoDB may be incorrect.

Description

Reading max_trx_id from page [0,5] may before page application. In this way, the read max_trx_id may be smaller than the true value.

This may cause the trx_id in the data record to be greater than trx_sys->max_trx_id. In the debug version, it will crash in ReadView::check_trx_id_sanity.

PR:

Environment

None

Activity

Aaditya Dubey 
November 20, 2024 at 1:34 PM

Hi

Closing this report, thank you for the update.

ying xing 
November 20, 2024 at 12:56 PM

sorry , it is a mistake. There is no bug in mysql server

Aaditya Dubey 
November 20, 2024 at 12:48 PM

Hi

Thank you for the report and PR.
Sending the concern to our engineering team for further review and updates.

ying xing 
October 16, 2024 at 2:06 PM

ying xing 
October 16, 2024 at 2:00 PM

This may cause the trx_id in the data record to be greater than trx_sys->max_trx_id. In the debug version, it will crash in ReadView::check_trx_id_sanity.

Not a Bug

Details

Assignee

Reporter

Needs QA

Priority

Created October 16, 2024 at 1:44 PM
Updated December 2, 2024 at 12:29 PM
Resolved November 20, 2024 at 1:35 PM