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

galera.galera_mdl_race MTR failed: query 'reap' succeeded - should have failed with errno 1213

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.12
    • Fix Version/s: 10.4
    • Component/s: Galera, Tests
    • Labels:
    • Environment:
      kvm-rpm-centos74-amd64-debug

      Description

      galera.galera_mdl_race failed on bb.

      stdio.log:

      10.4.12 983163209d026bfd979b4298053fcbdb373efa9d

      galera.galera_mdl_race 'innodb'          w1 [ fail ]
              Test ended at 2020-01-08 18:05:01
       
      CURRENT_TEST: galera.galera_mdl_race
      mysqltest: At line 58: query 'reap' succeeded - should have failed with errno 1213...
       
      The result from queries just before the failure was:
      < snip >
      connection node_1;
      SET AUTOCOMMIT=ON;
      START TRANSACTION;
      UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
      connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
      connection node_1a;
      LOCK TABLE t2 WRITE;
      connection node_1;
      SET @@debug_dbug = "d,sync.wsrep_before_mdl_wait";
      SELECT * FROM t2;;
      connection node_1a;
      SET @@debug_dbug = "d,sync.wsrep_after_BF_victim_lock";
      connection node_2;
      UPDATE t1 SET f2 = 'c' WHERE f1 = 1;
      connection node_1a;
      SET @@debug_dbug = "";
      SET DEBUG_SYNC = "now SIGNAL signal.wsrep_before_mdl_wait";
      SET DEBUG_SYNC = "now SIGNAL signal.wsrep_after_BF_victim_lock";
      UNLOCK TABLES;
      connection node_1;
       
      More results from queries before failure can be found in /dev/shm/var/1/log/galera_mdl_race.log
       
       - skipping '/dev/shm/var/1/log/galera.galera_mdl_race-innodb/'
       
      Retrying test galera.galera_mdl_race, attempt(2/3)...
       
      galera.MDEV-6860 'innodb'                w2 [ skipped ]  Test requires wsrep_on=ON
      worker[2] > Restart [mysqld.1 - pid: 9307, winpid: 9307] - using different config file
      worker[2] > Restart [mysqld.2 - pid: 9309, winpid: 9309] - using different config file
      worker[2] > Restart [mysqld.3 - pid: 9373, winpid: 9373] - using different config file
      galera.galera_multi_database 'innodb'    w1 [ pass ]   2055
      galera.galera_myisam_autocommit 'innodb' w1 [ pass ]   2050
      galera.galera_mdl_race 'innodb'          w1 [ retry-pass ]   2095
       
      Retrying test galera.galera_mdl_race, attempt(3/3)...
       
      galera.galera_myisam_transactions 'innodb' w1 [ pass ]   2082
      galera.galera_nopk_bit 'innodb'          w1 [ pass ]   2095
      galera.galera_mdl_race 'innodb'          w1 [ retry-pass ]   2073
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated: