Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL)
-
None
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)...
|
Attachments
Issue Links
- duplicates
-
MDEV-17106 Test failure on galera.galera_binlog_stmt_autoinc
-
- Closed
-
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)...