mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
5bf4dee369
The hang may be caused by a 1pc branch that was fixed by MDEV-26031 in 10.6 and up. That commit did not look relevant in 10.5 and below so was not pushed to the low branches. To possibly tackle the reported issue the MDEV-26031 is backported now with a test that unlike 10.6 does not expose the former bug in 10.5. It is only needed for checking a refined logics inside MYSQL_BIN_LOG::write_transaction_to_binlog. The latter is made to do away with xid-unlogging (which is suspected to have been at fault) for xid-less transaction.
34 lines
1.3 KiB
Text
34 lines
1.3 KiB
Text
RESET MASTER;
|
|
CREATE TABLE t (f INT) ENGINE=INNODB;
|
|
CREATE TABLE ta (f INT) ENGINE=Aria;
|
|
BEGIN;
|
|
INSERT INTO t SET f = 1;
|
|
INSERT INTO ta SET f = 1;
|
|
COMMIT;
|
|
include/show_binlog_events.inc
|
|
Log_name Pos Event_type Server_id End_log_pos Info
|
|
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
|
|
master-bin.000001 # Query # # use `test`; INSERT INTO ta SET f = 1
|
|
master-bin.000001 # Query # # COMMIT
|
|
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
|
|
master-bin.000001 # Query # # use `test`; INSERT INTO t SET f = 1
|
|
master-bin.000001 # Query # # COMMIT
|
|
# Prove that binlog is resettable. Under the bug condition it was not.
|
|
RESET MASTER;
|
|
SET @@binlog_format = ROW;
|
|
CREATE TABLE ta2 ENGINE = Aria SELECT * from t;
|
|
include/show_binlog_events.inc
|
|
Log_name Pos Event_type Server_id End_log_pos Info
|
|
master-bin.000001 # Gtid # # BEGIN GTID #-#-#
|
|
master-bin.000001 # Query # # use `test`; CREATE TABLE `ta2` (
|
|
`f` int(11) DEFAULT NULL
|
|
) ENGINE=Aria PAGE_CHECKSUM=1
|
|
master-bin.000001 # Annotate_rows # # CREATE TABLE ta2 ENGINE = Aria SELECT * from t
|
|
master-bin.000001 # Table_map # # table_id: # (test.ta2)
|
|
master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
|
|
master-bin.000001 # Query # # COMMIT
|
|
# Prove that binlog is resettable. Under the bug condition it was not.
|
|
RESET MASTER;
|
|
# Cleanup
|
|
DROP TABLE ta2, ta, t;
|
|
# End of the tests
|