Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.11, 11.1(EOL), 11.2, 11.0(EOL), 11.3(EOL)
-
None
Description
rpl.rpl_semi_sync_slave_enabled_consistent fails occasionally with
rpl.rpl_semi_sync_slave_enabled_consistent 'row' w21 [ fail ]
|
Test ended at 2024-03-18 15:28:48
|
CURRENT_TEST: rpl.rpl_semi_sync_slave_enabled_consistent
|
mysqltest: In included file "./include/wait_for_slave_param.inc":
|
included from ./include/wait_for_slave_sql_to_stop.inc at line 47:
|
included from ./include/wait_for_slave_to_stop.inc at line 34:
|
included from ./include/stop_slave.inc at line 84:
|
included from /home/buildbot/amd64-ubuntu-2004-debug/build/mysql-test/suite/rpl/t/rpl_semi_sync_slave_enabled_consistent.test at line 68:
|
In the error log, in can be seen this is due to the SQL thread trying to stop while having non-transactional changes:
2024-03-18 15:28:45 71 [Warning] Slave SQL: Request to stop slave SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group ... , Gtid 0-1-4, Internal MariaDB error code: 0
|
2024-03-18 15:28:47 71 [ERROR] Slave SQL: Fatal error: ... Slave SQL Thread stopped with incomplete event group having non-transactional changes. If the group consists solely of row-based events, you can try to restart the slave with --slave-exec-mode=IDEMPOTENT, which ignores duplicate key, key not found, and similar errors (see documentation for details). Gtid 0-1-4, Internal MariaDB error code: 1593
|
The test itself doesn't have any transactions directly, but it can be seen that this is from trying to replicate test suppressions:
The result from queries just before the failure was:
|
< snip >
|
master-bin.000001 805 Annotate_rows 1 970 INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'could not queue event from master' COLLATE 'latin1_swedish_ci'))
|
master-bin.000001 970 Table_map 1 1031 table_id: 91 (mtr.test_suppressions)
|
master-bin.000001 1031 Write_rows_v1 1 1099 table_id: 91 flags: STMT_END_F
|
master-bin.000001 1099 Query 1 1171 COMMIT
|
master-bin.000001 1171 Gtid 1 1213 BEGIN GTID 0-1-3
|
master-bin.000001 1213 Annotate_rows 1 1403 INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Semisync ack receiver.*error reading communication packets' COLLATE 'latin1_swedish_ci'))
|
master-bin.000001 1403 Table_map 1 1464 table_id: 92 (mtr.test_suppressions)
|
master-bin.000001 1464 Write_rows_v1 1 1557 table_id: 92 flags: STMT_END_F
|
master-bin.000001 1557 Query 1 1629 COMMIT
|
master-bin.000001 1629 Gtid 1 1671 BEGIN GTID 0-1-4
|
master-bin.000001 1671 Annotate_rows 1 1835 INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'Semisync ack receiver got hangup' COLLATE 'latin1_swedish_ci'))
|
master-bin.000001 1835 Table_map 1 1896 table_id: 93 (mtr.test_suppressions)
|
master-bin.000001 1896 Write_rows_v1 1 1963 table_id: 93 flags: STMT_END_F
|
master-bin.000001 1963 Query 1 2035 COMMIT
|
|