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

galera mtr galera_certification_double_failure fails with deadlock

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.6
    • Fix Version/s: 10.2.18, 10.3.10
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      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

            Assignee:
            winstone Zdravelina Sokolovska
            Reporter:
            winstone Zdravelina Sokolovska
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: