[MDEV-8670] main.mdev-504 fails on Windows (in buildbot and outside) Created: 2015-08-24  Updated: 2015-08-24  Resolved: 2015-08-24

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0, 10.1
Fix Version/s: 10.0.22, 10.1.7

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

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/win64-release2/builds/7555/steps/test/logs/stdio

main.mdev-504                            [ fail ]
        Test ended at 2015-08-05 14:06:04
 
CURRENT_TEST: main.mdev-504
mysqltest: At line 58: query 'reap' failed: 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
< snip >
fdate DATE
) ENGINE=MyISAM;
CREATE PROCEDURE p_analyze()
BEGIN
DECLARE attempts INTEGER DEFAULT 100;
wl_loop: WHILE attempts > 0 DO
ANALYZE TABLE A;
SET attempts = attempts - 1;
END WHILE wl_loop;
END |
CREATE FUNCTION rnd3() RETURNS INT
BEGIN
RETURN ROUND(3 * RAND() + 0.5);
END |
SET GLOBAL use_stat_tables = PREFERABLY;

The test opens a connection, makes it execute a procedure via --send, performs some operations in parallel in other connections, and then reaps the first one.

The reason why the test fails is that it takes too long, so the connection hits net_write_timeout.
The reason why it did not fail before, but started failing recently, is MDEV-8669.

I expect MDEV-8669 will be looked at separately, but to fix the test, I am going to increase net_write_timeout in it – it's reasonable anyway.



 Comments   
Comment by Elena Stepanova [ 2015-08-24 ]

https://github.com/MariaDB/server/commit/aef8bfdc826d7466dd482d38522de925ad6b4217

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