Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL)
-
None
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.
.
Attachments
Issue Links
- blocks
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Stalled
-
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 ] 384766Test as it is now, with --mem
rpl.rpl_innodb_bug30888 'innodb_plugin,mix' [ pass ] 15695Test with --innodb-flush-log-at-trx-commit=2, without --mem
rpl.rpl_innodb_bug30888 'innodb_plugin,mix' [ pass ] 19253Test with --innodb-flush-log-at-trx-commit=2 and with --mem
rpl.rpl_innodb_bug30888 'innodb_plugin,mix' [ pass ] 14680