Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL)
-
None
Description
10.6 2fa3ada07202bfd8764cff0bf2e5bbf8 |
rpl.rpl_xa 'innodb,mix' w2 [ fail ]
|
Test ended at 2022-06-28 18:58:40
|
|
CURRENT_TEST: rpl.rpl_xa
|
mysqltest: In included file "./include/sync_with_master_gtid.inc":
|
included from /usr/local/share/mysql-test/suite/rpl/t/rpl_xa.inc at line 350:
|
included from /usr/local/share/mysql-test/suite/rpl/t/rpl_xa.test at line 4:
|
At line 48: Failed to sync with master
|
|
The result from queries just before the failure was:
|
< snip >
|
connection master;
|
xa recover;
|
formatID gtrid_length bqual_length data
|
1 11 0 skip_binlog
|
set @@session.sql_log_bin = OFF;
|
xa rollback 'skip_binlog';
|
set @@session.sql_log_bin = ON;
|
include/save_master_gtid.inc
|
*** Zero must be in the list:
|
connection master;
|
xa recover;
|
formatID gtrid_length bqual_length data
|
*** At the end of skip_log_binb section gtid list has 0 more:
|
flush logs;
|
show binlog events in 'master-bin.000007' limit 1,1;
|
Log_name Pos Event_type Server_id End_log_pos Info
|
master-bin.000007 # Gtid_list 1 # [0-1-25]
|
connection slave;
|
include/sync_with_master_gtid.inc
|
Timeout in master_gtid_wait('0-1-25', 120), current slave GTID position is: 0-1-11.
|
The replica error log shows:
2022-06-28 18:56:39 7 [ERROR] Error reading packet from server: bogus data in log event; the first event 'master-bin.000001' at 4, the last event read from 'master-bin.000002' at 343, the last byte read from 'master-bin.000002' at 362. (server_errno=1236)
|
2022-06-28 18:56:39 7 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'bogus data in log event; the first event 'master-bin.000001' at 4, the last event read from 'master-bin.000002' at 343, the last byte read from 'master-bin.000002' at 362.', Internal MariaDB error code: 1236
|
2022-06-28 18:56:39 7 [Note] Slave I/O thread exiting, read up to log 'master-bin.000002', position 343, master 127.0.0.1:16020
|
Test always seems to be retry-pass.
Also seen on 10.7, 10.10 bb branches.
Var dir: https://drive.google.com/drive/folders/1FGUV55ChN3Wpc4qG7XeFw4nDnaWzzAJj
rpl.rpl_xa_gtid_pos_auto_engine failures seem similar (replica error log has same messages):
10.6 2fa3ada07202bfd8764cff0bf2e5bbf8 |
rpl.rpl_xa_gtid_pos_auto_engine 'innodb,mix' w2 [ fail ]
|
Test ended at 2022-06-28 19:00:47
|
|
CURRENT_TEST: rpl.rpl_xa_gtid_pos_auto_engine
|
mysqltest: In included file "./include/sync_with_master_gtid.inc":
|
included from /usr/local/share/mysql-test/suite/rpl/t/rpl_xa.inc at line 350:
|
included from /usr/local/share/mysql-test/suite/rpl/t/rpl_xa_gtid_pos_auto_engine.test at line 16:
|
At line 48: Failed to sync with master
|
|
The result from queries just before the failure was:
|
< snip >
|
connection master;
|
xa recover;
|
formatID gtrid_length bqual_length data
|
1 11 0 skip_binlog
|
set @@session.sql_log_bin = OFF;
|
xa rollback 'skip_binlog';
|
set @@session.sql_log_bin = ON;
|
include/save_master_gtid.inc
|
*** Zero must be in the list:
|
connection master;
|
xa recover;
|
formatID gtrid_length bqual_length data
|
*** At the end of skip_log_binb section gtid list has 0 more:
|
flush logs;
|
show binlog events in 'master-bin.000007' limit 1,1;
|
Log_name Pos Event_type Server_id End_log_pos Info
|
master-bin.000007 # Gtid_list 1 # [0-1-25]
|
connection slave;
|
include/sync_with_master_gtid.inc
|
Timeout in master_gtid_wait('0-1-25', 120), current slave GTID position is: 0-1-11.
|