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

galera_sst_mysqldump.test fails with: 'show status' failed with wrong errno 1205: 'Lock wait timeout exceeded; try restarting transaction', instead of 0...

    Details

      Description

      This test fails always:

       bld/mysql-test/mtr galera_sst_mysqldump --mem
      Logging: /home/a/e1/m1-10.1/src/mysql-test/mysql-test-run.pl  galera_sst_mysqldump --mem
      vardir: /home/a/e1/_depot/m-branch/m1-10.1-bld/mysql-test/var
      Checking leftover processes...
      Removing old var directory...
      Creating var directory '/home/a/e1/_depot/m-branch/m1-10.1-bld/mysql-test/var'...
       - symlinking 'var' to '/dev/shm/var_auto_tjWY'
      Checking supported features...
      MariaDB Version 10.1.29-MariaDB-debug
       - SSL connections supported
       - binaries are debug compiled
      Sphinx 'indexer' binary not found, sphinx suite will be skipped
      Collecting tests...
      Installing system database...
       
      ==============================================================================
       
      TEST                                      RESULT   TIME (ms) or COMMENT
      --------------------------------------------------------------------------
       
      worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
      galera.galera_sst_mysqldump 'innodb_plugin' [ fail ]
              Test ended at 2017-10-14 14:11:25
       
      CURRENT_TEST: galera.galera_sst_mysqldump
      mysqltest: In included file "./include/wait_until_connected_again.inc": 
      included from ./suite/galera/include/galera_load_provider.inc at line 10:
      included from ./suite/galera/include/galera_st_disconnect_slave.inc at line 57:
      included from /home/a/e1/_depot/m-branch/m1-10.1-src/mysql-test/suite/galera/t/galera_sst_mysqldump.test at line 9:
      At line 26: query 'show status' failed with wrong errno 1205: 'Lock wait timeout exceeded; try restarting transaction', instead of 0...
       
      The result from queries just before the failure was:
      < snip >
      INSERT INTO t1 VALUES ('node1_committed_during');
      INSERT INTO t1 VALUES ('node1_committed_during');
      INSERT INTO t1 VALUES ('node1_committed_during');
      INSERT INTO t1 VALUES ('node1_committed_during');
      INSERT INTO t1 VALUES ('node1_committed_during');
      COMMIT;
      START TRANSACTION;
      INSERT INTO t1 VALUES ('node1_to_be_committed_after');
      INSERT INTO t1 VALUES ('node1_to_be_committed_after');
      INSERT INTO t1 VALUES ('node1_to_be_committed_after');
      INSERT INTO t1 VALUES ('node1_to_be_committed_after');
      INSERT INTO t1 VALUES ('node1_to_be_committed_after');
      SET AUTOCOMMIT=OFF;
      START TRANSACTION;
      INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
      INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
      INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
      INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
      INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
      Loading wsrep provider ...
       
      More results from queries before failure can be found in /home/a/e1/_depot/m-branch/m1-10.1-bld/mysql-test/var/log/galera_sst_mysqldump.log
       
       - saving '/home/a/e1/_depot/m-branch/m1-10.1-bld/mysql-test/var/log/galera.galera_sst_mysqldump-innodb_plugin/' to '/home/a/e1/_depot/m-branch/m1-10.1-bld/mysql-test/var/log/galera.galera_sst_mysqldump-innodb_plugin/'
       
      Only  1  of 2 completed.
      --------------------------------------------------------------------------
      The servers were restarted 0 times
      Spent 0.000 of 59 seconds executing testcases
       
      Failure: Failed 1/1 tests, 0.00% were successful.
       
      Failing test(s): galera.galera_sst_mysqldump
       
      The log files in var/log may give you some hint of what went wrong.
       
      If you want to report this error, please read first the documentation
      at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
       
      mysql-test-run: *** ERROR: there were failing test cases
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jplindst Jan Lindström
                Reporter:
                anikitin Andrii Nikitin (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: