Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5, 10.6, 10.11, 11.2(EOL), 11.4, 11.6(EOL)
-
None
Description
The test rpl.rpl_mysqldump_gtid_slave_pos, added in MDEV-15393, fails somewhat frequently on buildbot with various failures. A few examples:
rpl.rpl_mysqldump_gtid_slave_pos 'mix' w4 [ fail ]
|
Test ended at 2024-07-25 08:21:02
|
 |
CURRENT_TEST: rpl.rpl_mysqldump_gtid_slave_pos
|
--- /usr/share/mysql-test/suite/rpl/r/rpl_mysqldump_gtid_slave_pos.result 2024-07-25 07:06:08.000000000 +0000
|
+++ /dev/shm/var/4/log/rpl_mysqldump_gtid_slave_pos.reject 2024-07-25 08:21:01.514074976 +0000
|
@@ -36,14 +36,9 @@
|
select * from mysql.gtid_slave_pos;
|
domain_id sub_id server_id seq_no
|
0 2 1 1
|
-0 3 1 2
|
-0 4 1 3
|
-0 5 1 4
|
-0 6 1 5
|
-0 7 1 6
|
select @@global.gtid_slave_pos as "after initial slave got in sync";
|
after initial slave got in sync
|
-0-1-6
|
+0-1-1
|
# 2.
|
include/stop_slave.inc
|
# 3. A
|
@@ -63,15 +58,15 @@
|
# 6.
|
select * from mysql.gtid_slave_pos;
|
domain_id sub_id server_id seq_no
|
-0 2 1 6
|
+0 2 1 1
|
select @@global.gtid_slave_pos as "after dump restore";
|
after dump restore
|
-0-1-6
|
+0-1-1
|
# 7.
|
reset slave;
|
select @@global.gtid_slave_pos;
|
@@global.gtid_slave_pos
|
-0-1-6
|
+0-1-1
|
change master to master_use_gtid=no;
|
connection master;
|
insert into t1 select 1+max(a),2 from t1;
|
@@ -81,7 +76,7 @@
|
include/sync_with_master_gtid.inc
|
select * from mysql.gtid_slave_pos;
|
domain_id sub_id server_id seq_no
|
-0 2 1 6
|
+0 2 1 1
|
0 3 1 1
|
0 4 1 2
|
0 5 1 3
|
@@ -107,15 +102,15 @@
|
# 6.
|
select * from mysql.gtid_slave_pos;
|
domain_id sub_id server_id seq_no
|
-0 2 1 6
|
+0 2 2 2
|
select @@global.gtid_slave_pos as "after dump restore";
|
after dump restore
|
-0-1-6
|
+0-2-2
|
# 7.
|
reset slave;
|
select @@global.gtid_slave_pos;
|
@@global.gtid_slave_pos
|
-0-1-6
|
+0-2-2
|
change master to master_use_gtid=no;
|
connection master;
|
insert into t1 select 1+max(a),1 from t1;
|
@@ -125,7 +120,7 @@
|
include/sync_with_master_gtid.inc
|
select * from mysql.gtid_slave_pos;
|
domain_id sub_id server_id seq_no
|
-0 2 1 6
|
+0 2 2 2
|
0 3 1 1
|
0 4 1 2
|
0 5 1 3
|
 |
Result length mismatch
|
rpl.rpl_mysqldump_gtid_slave_pos 'stmt' w2 [ fail ] Found warnings/errors in server log file!
|
Test ended at 2024-09-20 12:49:04
|
line
|
2024-09-20 12:49:00 268 [Warning] Master is configured to log replication events with checksum, but will not send such events to slaves that cannot process them
|
^ Found warnings in /run/shm/var/2/log/mysqld.1.err
|
ok
|
 |
- saving '/run/shm/var/2/log/rpl.rpl_mysqldump_gtid_slave_pos-stmt/' to '/run/shm/var/log/rpl.rpl_mysqldump_gtid_slave_pos-stmt/'
|
 |
Retrying test rpl.rpl_mysqldump_gtid_slave_pos, attempt(2/3)...
|
Attachments
Issue Links
- blocks
-
MDEV-35153 backport the MDEV-34716 fix of socket length in mysql.servers
- Closed
- is caused by
-
MDEV-15393 gtid_slave_pos duplicate key errors after mysqldump restore
- Closed