[MDEV-14144] galera.galera_as_slave_autoinc, galera.galera_as_slave_gtid fail in buildbot with "didn't return a result set" Created: 2017-10-26  Updated: 2018-04-25  Resolved: 2018-04-25

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.1, 10.2
Fix Version/s: 10.1.33

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Daniele Sciascia
Resolution: Fixed Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-wheezy-amd64/builds/10711/steps/mtr/logs/stdio

galera.galera_as_slave_autoinc 'innodb'  w1 [ fail ]
        Test ended at 2017-10-11 18:14:27
 
CURRENT_TEST: galera.galera_as_slave_autoinc
mysqltest: In included file "./include/wait_condition.inc": 
included from /usr/share/mysql/mysql-test/suite/galera/t/galera_as_slave_autoinc.test at line 78:
At line 43: Query 'SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';' didn't return a result set
 
The result from queries just before the failure was:
< snip >
i	c
1	dummy_text
2	dummy_text
3	dummy_text
4	dummy_text
8	dummy_text
15	dummy_text
22	dummy_text
33	dummy_text
40	dummy_text
47	dummy_text
show variables like 'binlog_format';
Variable_name	Value
binlog_format	ROW
show variables like 'auto_increment_increment';
Variable_name	Value
auto_increment_increment	2
connection node_1;
DROP TABLE t1;
connection node_2;
 
More results from queries before failure can be found in /run/shm/var/1/log/galera_as_slave_autoinc.log
 
Warnings from just before the error:
Error 1317 Query execution was interrupted
 
 - saving '/run/shm/var/1/log/galera.galera_as_slave_autoinc-innodb/' to '/run/shm/var/log/galera.galera_as_slave_autoinc-innodb/'

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-amd64/builds/1414/steps/mtr/logs/stdio

galera.galera_as_slave_gtid 'xtradb'     w2 [ fail ]
        Test ended at 2017-10-05 06:41:28
 
CURRENT_TEST: galera.galera_as_slave_gtid
mysqltest: In included file "./include/wait_condition.inc": 
included from /usr/share/mysql/mysql-test/suite/galera/t/galera_as_slave_gtid.test at line 32:
At line 43: Query 'SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';' didn't return a result set
 
The result from queries just before the failure was:
START SLAVE;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES(1);
SELECT LENGTH(@@global.gtid_binlog_state) > 1;
LENGTH(@@global.gtid_binlog_state) > 1
1
 
Warnings from just before the error:
Error 1317 Query execution was interrupted



 Comments   
Comment by Daniele Sciascia [ 2018-03-12 ]

I submitted a pull request that fixes this issue here: https://github.com/MariaDB/server/pull/650

Comment by Daniele Sciascia [ 2018-04-24 ]

Can this issue be closed?

Comment by Elena Stepanova [ 2018-04-24 ]

If it's fixed, it can be closed. Is it fixed, and if so, in which versions?

Comment by Daniele Sciascia [ 2018-04-25 ]

I submitted a fix https://github.com/MariaDB/server/pull/650 against 10.1. I suppose it was merged into 10.2 and 10.3 as well.

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