BUG#34930969: Previous_gtids miss gtid when binlog_order_commits off

Problem

When binlog_order_commits is turned off, binlog rotate will wait for m_prep_xids to decrease to zero. However, m_prep_xids was decreased before updating the thread GTID to gtid_executed in MYSQL_BIN_LOG::finish_commit, causing GTIDs to be missed in the next binlog file Previous_gtids event.

Fix

The core fix moves dec_prep_xids to be called after gtid_state->update_on_commit in MYSQL_BIN_LOG::finish_commit. This ensures that when binlog rotate waits for m_prep_xids to reach zero, all GTIDs have already been registered in gtid_executed.

Additionally:

• Added DEBUG_SYNC point after_dec_prep_xids to enable deterministic testing
• Added MTR test case rpl_previous_gtids to verify the fix

Commit

https://github.com/xyw0537/TXSQL/commit/ae7de225c2a

Branch: bugfix/previous_gtids_miss_gtid_binlog_order_commits_off

Upstream Reference

https://github.com/mysql/mysql-server/commit/a3faa6f8799e6c7c610245d2899386131731fb41

Bắt đầu bằng cách xác định MYSQL_BIN_LOG::finish_commit và kiểm tra thứ tự của dec_prep_xids và gtid_state->update_on_commit. Xem lại điểm DEBUG_SYNC after_dec_prep_xids và test case MTR rpl_previous_gtids. Công việc được xem là hoàn tất khi test xác minh rằng Previous_gtids bao gồm tất cả các GTID đã commit khi binlog_order_commits tắt.