[MDEV-19959] Galera test failure on galera_binlog_stmt_autoinc Created: 2019-07-05  Updated: 2022-05-10  Resolved: 2022-05-09

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.3.35, 10.4.25

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-17106 Test failure on galera.galera_binlog_... Closed

 Description    

galera.galera_binlog_stmt_autoinc 'innodb' w2 [ fail ]
 
        Test ended at 2019-07-04 16:14:53
 
 
 
CURRENT_TEST: galera.galera_binlog_stmt_autoinc
 
--- /usr/share/mysql/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result	2019-07-04 12:47:59.000000000 -0400
 
+++ /dev/shm/var/2/log/galera_binlog_stmt_autoinc.reject	2019-07-04 16:14:52.855149693 -0400
 
@@ -12,21 +12,21 @@
 
 insert into t1(i) values(null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
+2	dummy_text
 
 insert into t1(i) values(null), (null), (null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 connection node_2;
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
 connection node_1;
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
@@ -70,7 +70,7 @@
 
 show variables like '%auto_increment%';
 
 Variable_name	Value
 
 auto_increment_increment	2
 
-auto_increment_offset	1
 
+auto_increment_offset	2
 
 wsrep_auto_increment_control	ON
 
 SET GLOBAL wsrep_auto_increment_control='OFF';
 
 show variables like '%auto_increment%';
 
@@ -92,21 +92,21 @@
 
 insert into t1(i) values(null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
+2	dummy_text
 
 insert into t1(i) values(null), (null), (null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 connection node_2;
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
 connection node_1;
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
@@ -149,7 +149,7 @@
 
 show variables like '%auto_increment%';
 
 Variable_name	Value
 
 auto_increment_increment	2
 
-auto_increment_offset	1
 
+auto_increment_offset	2
 
 wsrep_auto_increment_control	ON
 
 SET GLOBAL wsrep_auto_increment_control='OFF';
 
 show variables like '%auto_increment%';
 
 
 
mysqltest: Result content mismatch
 
 
 
 - skipping '/dev/shm/var/2/log/galera.galera_binlog_stmt_autoinc-innodb/'
 
 
 
Retrying test galera.galera_binlog_stmt_autoinc, attempt(2/3)...



 Comments   
Comment by Alice Sherepa [ 2021-06-04 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles150-amd64/builds/5742/steps/mtr-galera/logs/stdio
10.3 663bc849b5a26a5325adf0

galera.galera_binlog_stmt_autoinc 'innodb' w1 [ fail ]
 
        Test ended at 2021-06-03 23:11:23
 
 
 
CURRENT_TEST: galera.galera_binlog_stmt_autoinc
 
--- /usr/share/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result	2021-06-03 20:37:12.000000000 +0000
 
+++ /dev/shm/var/1/log/galera_binlog_stmt_autoinc.reject	2021-06-03 23:11:23.548287161 +0000
 
@@ -12,21 +12,21 @@
 
 insert into t1(i) values(null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
+2	dummy_text
 
 insert into t1(i) values(null), (null), (null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 connection node_2;
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
 connection node_1;
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
@@ -70,7 +70,7 @@
 
 show variables like '%auto_increment%';
 
 Variable_name	Value
 
 auto_increment_increment	2
 
-auto_increment_offset	1
 
+auto_increment_offset	2
 
 wsrep_auto_increment_control	ON
 
 SET GLOBAL wsrep_auto_increment_control='OFF';
 
 show variables like '%auto_increment%';
 
@@ -92,21 +92,21 @@
 
 insert into t1(i) values(null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
+2	dummy_text
 
 insert into t1(i) values(null), (null), (null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 connection node_2;
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
 connection node_1;
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
@@ -149,7 +149,7 @@
 
 show variables like '%auto_increment%';
 
 Variable_name	Value
 
 auto_increment_increment	2
 
-auto_increment_offset	1
 
+auto_increment_offset	2
 
 wsrep_auto_increment_control	ON
 
 SET GLOBAL wsrep_auto_increment_control='OFF';
 
 show variables like '%auto_increment%';
 
 
 
mysqltest: Result content mismatch
 
 
 
 - saving '/dev/shm/var/1/log/galera.galera_binlog_stmt_autoinc-innodb/' to '/dev/shm/var/log/galera.galera_binlog_stmt_autoinc-innodb/'
 
 
 
Retrying test galera.galera_binlog_stmt_autoinc, attempt(2/3)...

Comment by Elena Stepanova [ 2022-05-05 ]

I'm not sure what Test_disabled label here means, but the test still runs and fails in buildbot.
https://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-amd64/builds/27868/steps/mtr-galera/logs/stdio
jplindst,
Could it please be fixed or disabled for real?

10.3 06562b84f65fe5089288f3ca180d0636

 
 
 
galera.galera_binlog_stmt_autoinc 'innodb' w1 [ fail ]
 
        Test ended at 2022-05-04 23:55:13
 
 
 
CURRENT_TEST: galera.galera_binlog_stmt_autoinc
 
--- /usr/share/mysql/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result	2022-05-04 21:52:00.000000000 -0400
 
+++ /dev/shm/var/1/log/galera_binlog_stmt_autoinc.reject	2022-05-04 23:55:13.237459827 -0400
 
@@ -12,21 +12,21 @@
 
 insert into t1(i) values(null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
+2	dummy_text
 
 insert into t1(i) values(null), (null), (null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 connection node_2;
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
 connection node_1;
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
@@ -70,7 +70,7 @@
 
 show variables like '%auto_increment%';
 
 Variable_name	Value
 
 auto_increment_increment	2
 
-auto_increment_offset	1
 
+auto_increment_offset	2
 
 wsrep_auto_increment_control	ON
 
 SET GLOBAL wsrep_auto_increment_control='OFF';
 
 show variables like '%auto_increment%';
 
@@ -92,21 +92,21 @@
 
 insert into t1(i) values(null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
+2	dummy_text
 
 insert into t1(i) values(null), (null), (null);
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 connection node_2;
 
 select * from t1;
 
 i	c
 
-1	dummy_text
 
-3	dummy_text
 
-5	dummy_text
 
-7	dummy_text
 
+2	dummy_text
 
+4	dummy_text
 
+6	dummy_text
 
+8	dummy_text
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
 connection node_1;
 
 SET GLOBAL wsrep_forced_binlog_format='none';
 
@@ -149,7 +149,7 @@
 
 show variables like '%auto_increment%';
 
 Variable_name	Value
 
 auto_increment_increment	2
 
-auto_increment_offset	1
 
+auto_increment_offset	2
 
 wsrep_auto_increment_control	ON
 
 SET GLOBAL wsrep_auto_increment_control='OFF';
 
 show variables like '%auto_increment%';
 
 
 
mysqltest: Result content mismatch

Generated at Thu Feb 08 08:55:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.