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

galera_sr.galera_sr_kill_slave MTR failed: query 'LOCK TABLE t2 WRITE' failed: 1146: Table 'test.t2' doesn't exist

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4.15, 10.5.6
    • 10.4.16, 10.5.7, 10.6.0
    • Galera, Tests
    • None
    • kvm-deb-bionic-aarch64

    Description

      galera_sr.galera_sr_kill_slave failed on BB 10.4 and BB 10.5: "query 'LOCK TABLE t2 WRITE' failed: 1146: Table 'test.t2' doesn't exist".

      stdio.log:

      10.5.6 65ee216c35d843da7883d255219ab011e20340c2

      		 
      galera_sr.galera_sr_kill_slave 'innodb'  w1 [ fail ]
      		 
              Test ended at 2020-08-25 06:46:49
      		 
       
      		 
      CURRENT_TEST: galera_sr.galera_sr_kill_slave
      		 
      mysqltest: At line 22: query 'LOCK TABLE t2 WRITE' failed: 1146: Table 'test.t2' doesn't exist
      		 
       
      		 
      The result from queries just before the failure was:
      		 
      connection node_2;
      		 
      connection node_1;
      		 
      CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
      		 
      connection node_2;
      		 
      SELECT COUNT(*) = 0 FROM t1;
      		 
      COUNT(*) = 0
      		 
      1
      		 
      connection node_1;
      		 
      CREATE TABLE t2 (f1 INTEGER);
      		 
      connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
      		 
      LOCK TABLE t2 WRITE;

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          stepan.patryshev Stepan Patryshev (Inactive) created issue -
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Field Original Value New Value
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Assignee Stepan Patryshev [ stepan.patryshev ] Jan Lindström [ jplindst ]
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Affects Version/s 10.4.15 [ 24507 ]
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Fix Version/s 10.4 [ 22408 ]
          jplindst Jan Lindström (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s 10.4.15 [ 24507 ]
          Fix Version/s 10.5.6 [ 24508 ]
          Fix Version/s 10.6.0 [ 24431 ]
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          ralf.gebhardt Ralf Gebhardt made changes -
          Fix Version/s 10.5.7 [ 25019 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Fix Version/s 10.5.6 [ 24508 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Fix Version/s 10.4.16 [ 25020 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          Fix Version/s 10.4.15 [ 24507 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 113017 ] MariaDB v4 [ 158317 ]

          People

            jplindst Jan Lindström (Inactive)
            stepan.patryshev Stepan Patryshev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.