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

Galera test failure on galera.galera_rsu_drop_pk: query failed: 1205: Lock wait timeout exceeded

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.4.9
    • Fix Version/s: 10.4.12
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      OS: CentOS Linux release 7.6.1810 (Core).

      Description

      It sporadically failed only on a local suite run with --parallel=auto.

      MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 9afbb1069ab4178741b76adefacd3f6a0ed51369; debug built from sources.

      Galera lib 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.

      Run:

      ./mtr --suite galera --parallel=auto --testcase-timeout=90 --force --big-test --max-test-fail=0 --timer --timestamp --timediff
      

      stdout.log:
      query 'SELECT COUNT = 300000 FROM t1' failed: 1205: Lock wait timeout exceeded

      191029 14:16:10 +3.300 galera.galera_rsu_drop_pk 'innodb'       w4 [ fail ]
              Test ended at 2019-10-29 14:16:10
       
      CURRENT_TEST: galera.galera_rsu_drop_pk
      mysqltest: At line 34: query 'SELECT COUNT(*) = 300000 FROM t1' failed: 1205: Lock wait timeout exceeded; try restarting transaction
       
      The result from queries just before the failure was:
      < snip >
      connection node_1;
      connection node_1;
      CREATE TABLE ten (f1 INTEGER);
      INSERT INTO ten VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
      CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
      INSERT INTO t1 (f1) SELECT 000000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;
      INSERT INTO t1 (f1) SELECT 100000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;;
      connection node_2;
      SET SESSION wsrep_OSU_method = "RSU";
      ALTER TABLE t1 DROP PRIMARY KEY;
      SET SESSION wsrep_OSU_method = "TOI";
      INSERT INTO t1 (f1) SELECT 200000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;
      SELECT COUNT(*) = 300000 FROM t1;
      COUNT(*) = 300000
      1
      SELECT MAX(f1) =  299999 FROM t1;
      MAX(f1) =  299999
      1
      connection node_1;
      SELECT COUNT(*) = 300000 FROM t1;
      

      Other logs.

        Attachments

        1. 191029_HDD_galera_suite_stdout.log
          83 kB
          Stepan Patryshev

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              stepan.patryshev Stepan Patryshev
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: