[MDEV-8849] rpl.rpl_innodb_bug30888 sporadically fails in buildbot with testcase timeout Created: 2015-09-26  Updated: 2015-09-26  Resolved: 2015-09-26

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5
Fix Version/s: 5.5.46

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/p8-rhel71-bintar/builds/509/steps/test/logs/stdio

rpl.rpl_innodb_bug30888 'innodb_plugin,mix' w1 [ fail ]  timeout after 900 seconds
        Test ended at 2015-09-09 11:11:59
 
Test case timeout after 900 seconds
 
== /home/buildbot/maria-slave/power8-vlp06-bintar/build/mysql-test/var/1/log/rpl_innodb_bug30888.log == 
DECLARE ins_count INT DEFAULT 1000; 
DECLARE del_count INT;
DECLARE cur_user VARCHAR(255);
DECLARE local_uuid VARCHAR(255);
DECLARE local_time TIMESTAMP;
SET local_time= NOW();
SET cur_user= CURRENT_USER();
SET local_uuid= UUID();
WHILE ins_count > 0 DO
INSERT INTO test.regular_tbl VALUES (NULL, NOW(), USER() , UUID(),
ins_count,'Going to test MBR for MySQL');
SET ins_count = ins_count - 1;
END WHILE;
SELECT MAX(id) FROM test.regular_tbl INTO del_count;
WHILE del_count > 0 DO
DELETE FROM test.regular_tbl WHERE id = del_count;
SET del_count = del_count - 2;
END WHILE;
END|
CALL test.proc_norm();

The test is very fast when it's run with --mem, but very slow when it's run without, as some of buildbot builders do. On my machine it takes 13 seconds with --mem and ~5-6 min otherwise.
.



 Comments   
Comment by Elena Stepanova [ 2015-09-26 ]

An easy way to solve it is using innodb_flush_log_at_trx_commit 0 or 2. It does not seem to interfere with the test logic, while makes the test runs many times faster.
On my machine:

Test as it is now, without --mem

rpl.rpl_innodb_bug30888 'innodb_plugin,mix' [ pass ]  384766

Test as it is now, with --mem

rpl.rpl_innodb_bug30888 'innodb_plugin,mix' [ pass ]  15695

Test with --innodb-flush-log-at-trx-commit=2, without --mem

rpl.rpl_innodb_bug30888 'innodb_plugin,mix' [ pass ]  19253

Test with --innodb-flush-log-at-trx-commit=2 and with --mem

rpl.rpl_innodb_bug30888 'innodb_plugin,mix' [ pass ]  14680

Comment by Elena Stepanova [ 2015-09-26 ]

https://github.com/MariaDB/server/commit/86ed494aef0e7fb1f75af32d0665e9b42f36ee17

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