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

main.innodb_mysql_lock fails sporadically in buildbot

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.1, 10.0, 5.5
        • Fix Version/s: 10.1, 10.0, 5.5
        • Component/s: Tests
        • Labels:

          Description

          See for example
          http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/1272/steps/test/logs/stdio

          CURRENT_TEST: main.innodb_mysql_lock
mysqltest: At line 51: query 'INSERT INTO t1 VALUES (2)' succeeded - should have failed with errno 1213...

The result from queries just before the failure was:
#
# Bug #22876 Four-way deadlock
#
DROP TABLE IF EXISTS t1;
# Connection 1
set @@autocommit=0;
CREATE TABLE t1(s1 INT UNIQUE) ENGINE=innodb;
INSERT INTO t1 VALUES (1);
# Connection 2
set @@autocommit=0;
INSERT INTO t1 VALUES (2);
INSERT INTO t1 VALUES (1);
# Connection 3
set @@autocommit=0;
DROP TABLE t1;
# Connection 1
# Connection 1 is now holding the lock.
# Issuing insert from connection 1 while connection 2&3 
# is waiting for the lock should give a deadlock error.
INSERT INTO t1 VALUES (2);

          Retry passed.

          According to cross-reference, the failure has been happening since 2011, very rarely, several times a year at most, on different builders (deb, bintar, fulltest, windows), debug and release builds, ps-protocol and normal, always on the same statement.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-7069 Fix buildbot failures in main server trees

                • Major - Major loss of function.
                • Stalled

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      elenst Elena Stepanova
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: