Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-2382

LP:687320 - Sporadic failure of tests innodb_mysql and partition_innodb_semi_consistent

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          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.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                knielsen Kristian Nielsen added a comment -

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

                Show
                knielsen Kristian Nielsen added a comment - Re: Sporadic failure of tests innodb_mysql and partition_innodb_semi_consistent Fix will be in MariaDB 5.1.54 and 5.2.5
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 687320

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 687320

                  People

                  • Assignee:
                    knielsen Kristian Nielsen
                    Reporter:
                    knielsen Kristian Nielsen
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: