[MDEV-2382] LP:687320 - Sporadic failure of tests innodb_mysql and partition_innodb_semi_consistent Created: 2010-12-08  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Kristian Nielsen Assignee: Kristian Nielsen
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug687320.xml    

 Description   

innodb.innodb_mysql w2 [ fail ] timeout after 2700 seconds
Test ended at 2010-10-23 13:29:10

Test case timeout after 2700 seconds

== /var/lib/buildbot/maria-slave/debian5-i386-fulltest/build/mysql-test/var/2/log/innodb_mysql.log ==
INSERT INTO t1 VALUES (1,'init');
CREATE PROCEDURE p1()
BEGIN
UPDATE t1 SET b = CONCAT(b, '+con2') WHERE a = 1;
INSERT INTO t2 VALUES ();
END|
BEGIN;
UPDATE t1 SET b = CONCAT(b, '+con1') WHERE a = 1;
affected rows: 1
info: Rows matched: 1 Changed: 1 Warnings: 0
SELECT * FROM t1;
a b
1 init+con1

  1. Switch to connection con2
    CALL p1;;
  2. Switch to connection con1
    SELECT * FROM t1;
    a b
    1 init+con1
    COMMIT;

The failure is quite rare. Here are links to the failure history in Buildbot:

http://buildbot.askmonty.org/buildbot/reports/cross_reference#branch=&revision=&platform=&dt=&bbnum=&typ=&info=&fail_name=partition_innodb_semi_consistent&fail_variant=&fail_info_short=&fail_info_full=test+case+timeout&limit=100

http://buildbot.askmonty.org/buildbot/reports/cross_reference#branch=&revision=&platform=&dt=&bbnum=&typ=&info=&fail_name=innodb_mysql&fail_variant=&fail_info_short=&fail_info_full=test+case+timeout&limit=100

The problem is a race condition in the test case, will commit a patch.



 Comments   
Comment by Kristian Nielsen [ 2010-12-08 ]

Re: Sporadic failure of tests innodb_mysql and partition_innodb_semi_consistent
Fix will be in MariaDB 5.1.54 and 5.2.5

Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 687320

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