[MDEV-13545] sql_sequence.gtid fails in buildbot Created: 2017-08-16  Updated: 2017-08-25  Resolved: 2017-08-25

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.3
Fix Version/s: 10.3.1

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/9817/steps/test_3/logs/stdio

sql_sequence.gtid 'innodb,row'           w2 [ fail ]
        Test ended at 2017-08-15 16:07:48
 
CURRENT_TEST: sql_sequence.gtid
mysqltest: At line 231: query 'select next value for s_db.s1' failed with wrong errno 1146: 'Table 's_db.s1' doesn't exist', instead of 1290...
 
The result from queries just before the failure was:
< snip >
connection m_normal_1;
use s_db;
drop sequence s_t;
drop table t;
###########################################
read_only prevent query sequence
###########################################
connection m_normal_1;
create sequence s_db.s1;
show global variables like 'read_only';
Variable_name	Value
read_only	OFF
select next value for s_db.s1;
next value for s_db.s1
1
connection s_normal_3;
show global variables like 'read_only';
Variable_name	Value
read_only	ON
select next value for s_db.s1;
 
More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.3.1/mysql-test/var/2/log/gtid.log
 
sql_sequence.gtid 'innodb,row'           w2 [ retry-fail ]
        Test ended at 2017-08-15 16:07:51
 
CURRENT_TEST: sql_sequence.gtid
--- /mnt/buildbot/build/mariadb-10.3.1/mysql-test/suite/sql_sequence/gtid.result	2017-08-15 10:05:47.000000000 -0400
+++ /mnt/buildbot/build/mariadb-10.3.1/mysql-test/suite/sql_sequence/gtid.reject	2017-08-15 16:07:50.775096895 -0400
@@ -154,7 +154,7 @@
 Qcache_hits	0
 show status like 'Qcache_inserts';
 Variable_name	Value
-Qcache_inserts	0
+Qcache_inserts	12
 ###########################################
 priv test
 ###########################################
 
mysqltest: Result length mismatch


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