[MDEV-12639] spider/bg.spider3_fixes failed in buildbot Created: 2017-04-29  Updated: 2023-01-24  Resolved: 2023-01-24

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider, Tests
Affects Version/s: 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-precise-x86/builds/4973/steps/mtr/logs/stdio

spider/bg.spider3_fixes                  w4 [ fail ]
        Test ended at 2017-03-28 14:28:42
 
CURRENT_TEST: spider/bg.spider3_fixes
mysqltest: At line 219: query 'SELECT MAX(id) FROM t1' failed: 1156: Got packets out of order
 
The result from queries just before the failure was:
< snip >
INSERT INTO t1 () VALUES ();
SELECT LAST_INSERT_ID();
LAST_INSERT_ID()
5000
SELECT MAX(id) FROM t1;
MAX(id)
6216
MASTER_1_AUTO_INCREMENT_OFFSET4
INSERT INTO t2 () VALUES ();
SELECT LAST_INSERT_ID();
LAST_INSERT_ID()
6993
SELECT MAX(id) FROM t2;
MAX(id)
6993
INSERT INTO t1 (id) VALUES (10000);
SELECT LAST_INSERT_ID();
LAST_INSERT_ID()
6993
SELECT MAX(id) FROM t1;
 
More results from queries before failure can be found in /run/shm/var/4/log/spider3_fixes.log
 
Warnings from just before the error:
Error 1156 Got packets out of order 
Error 12701 Remote MySQL server has gone away



 Comments   
Comment by Elena Stepanova [ 2017-09-22 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/10204

spider/bg.spider3_fixes                  w1 [ fail ]
        Test ended at 2017-09-15 06:23:17
 
CURRENT_TEST: spider/bg.spider3_fixes
mysqltest: At line 165: query 'SELECT MAX(id) FROM t2' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'selectH' at line 1
 
The result from queries just before the failure was:
< snip >
CREATE TABLE t1 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_1
CREATE TABLE t2 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_1
INSERT INTO t1 () VALUES ();
SELECT LAST_INSERT_ID();
LAST_INSERT_ID()
777
SELECT MAX(id) FROM t1;
MAX(id)
777
INSERT INTO t2 () VALUES ();
SELECT LAST_INSERT_ID();
LAST_INSERT_ID()
1554
SELECT MAX(id) FROM t2;
 
More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.2.9/mysql-test/var/1/log/spider3_fixes.log

Comment by Yuchen Pei [ 2023-01-24 ]

The test passes locally on 10.3-11.0, old buildbot link dead

Comment by Yuchen Pei [ 2023-01-24 ]

Last buildbot failure of spider/bg.spider3_fixes with similar error messages was 2020-03-04.

Generated at Thu Feb 08 07:59:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.