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

galera mtr galera_certification_double_failure fails with deadlock

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3.6
    • 10.2.18, 10.3.10
    • Galera, Tests
    • None
    • CentOS 7.4.

    Description

      galera mtr galera_certification_double_failure from galera_3nodes test suite fails with deadlock

      checked on mariadb-10.3.6-76-g461de7e MariaDB Version 10.3.7-MariaDB

      $ ./mysql-test-run.pl galera_3nodes.galera_certification_double_failure
      Logging: /home/qa-user1/rr/server/mysql-test/mysql-test-run.pl  galera_3nodes.galera_certification_double_failure
      vardir: /home/qa-user1/rr/build-mariadb/mysql-test/var
      Checking leftover processes...
       - found old pid 29375 in 'mysqld.1.pid', killing it...
         process did not exist!
       - found old pid 29379 in 'mysqld.3.pid', killing it...
         process did not exist!
       - found old pid 29377 in 'mysqld.2.pid', killing it...
         process did not exist!
      Removing old var directory...
      Creating var directory '/home/qa-user1/rr/build-mariadb/mysql-test/var'...
      Checking supported features...
      MariaDB Version 10.3.7-MariaDB
       - SSL connections supported
      Collecting tests...
      Installing system database...
       
      ==============================================================================
       
      TEST                                      RESULT   TIME (ms) or COMMENT
      --------------------------------------------------------------------------
       
      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      galera_3nodes.galera_certification_double_failure 'innodb' [ fail ]
              Test ended at 2018-04-27 19:54:34
       
      CURRENT_TEST: galera_3nodes.galera_certification_double_failure
      --- /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.result        2018-04-23 18:14:30.322304529 +0300
      +++ /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.reject        2018-04-27 19:54:34.321952693 +0300
      @@ -11,6 +11,6 @@
       INSERT INTO t2 VALUES (1);
       connection node_1;
       COMMIT;
      -ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
      +ERROR 40001: Deadlock: wsrep aborted transaction
       DROP TABLE t1;
       DROP TABLE t2;
       
      mysqltest: Result length mismatch
       
      
      

      galera_3nodes.galera_certification_double_failure 'innodb' [ fail ]
              Test ended at 2018-04-27 19:37:43
       
      CURRENT_TEST: galera_3nodes.galera_certification_double_failure
      --- /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.result        2018-04-23 18:14:30.322304529 +0300
      +++ /home/qa-user1/rr/server/mysql-test/suite/galera_3nodes/r/galera_certification_double_failure.reject        2018-04-27 19:37:43.343732874 +0300
      @@ -11,6 +11,6 @@
       INSERT INTO t2 VALUES (1);
       connection node_1;
       COMMIT;
      -ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
      +ERROR 40001: Deadlock: wsrep aborted transaction
       DROP TABLE t1;
       DROP TABLE t2;
       
      mysqltest: Result length mismatch
      
      

      Attachments

        Activity

          People

            winstone Zdravelina Sokolovska (Inactive)
            winstone Zdravelina Sokolovska (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.