Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.11, 11.0(EOL), 11.1(EOL), 11.2, 11.4
-
None
-
None
Description
The test fails like
rpl.rpl_heartbeat w8 [ fail ]
|
Test ended at 2024-04-29 19:24:42
|
|
CURRENT_TEST: rpl.rpl_heartbeat
|
analyze: sync_with_master
|
Slave position: file: position: 4
|
Master position: file: master-bin.000001 position: 640
|
mysqltest: At line 119: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 640, 300, '')' returned -1 indicating timeout after 300 seconds
|
|
The result from queries just before the failure was:
|
< snip >
|
Value 5.001
|
reset slave;
|
set @@global.slave_net_timeout= 5;
|
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 4;
|
show status like 'Slave_heartbeat_period';;
|
Variable_name Slave_heartbeat_period
|
Value 4.000
|
set @@global.slave_net_timeout= 3 /* must be a warning */;
|
reset slave;
|
connection master;
|
drop table if exists t1;
|
connection slave;
|
set @@global.slave_net_timeout= 10;
|
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_ssl_verify_server_cert=0, master_heartbeat_period= 0.5;
|
show status like 'Slave_heartbeat_period';;
|
Variable_name Slave_heartbeat_period
|
Value 0.500
|
start slave;
|
connection master;
|
create table t1 (f1 int);
|
|
and with the slave error
Last_IO_Error Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 0-1-3, which is not in the master's binlog'
|
|
when a prior test, e.g rpl.rpl_gtid_misc, does not require the slave server restart and
the early test leave a non-empty GTID state.
rpl.rpl_heartbeat turns out to miss a standard include/master-slave header.
That needs fixing.