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

galera_3nodes.GCF-363 MTR failed: query failed: 1146: Table 'test.t1' doesn't exist

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.9, 10.6.0
    • Fix Version/s: 10.5.9, 10.6.0
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      kvm-rpm-centos73-ppc64

      Description

      galera_3nodes.GCF-363 failed on BB 10.5 CS and BB 10.6 CS: "query 'INSERT INTO t1 VALUES (1, 'a')' failed: 1146: Table 'test.t1' doesn't exist".
      It seems to be a sporadic issue.

      stdio.log:

      10.5.9, 3ee24b2306f6e6d18a3ab97dc0b7961cb9b12a75, kvm-rpm-centos73-ppc64

      galera_3nodes.GCF-363 'innodb'           w2 [ fail ]
              Test ended at 2020-12-07 14:00:11
       
      CURRENT_TEST: galera_3nodes.GCF-363
      mysqltest: At line 17: query 'INSERT INTO t1 VALUES (1, 'a')' failed: 1146: Table 'test.t1' 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, f2 CHAR(1)) ENGINE=InnoDB;
      connection node_1;
      SET GLOBAL wsrep_on=OFF;
      INSERT INTO t1 VALUES (1, 'a');
      SET GLOBAL wsrep_on=ON;
      connection node_2;
      SET GLOBAL wsrep_on=OFF;
      INSERT INTO t1 VALUES (1, 'a');
       
       - skipping '/dev/shm/var/2/log/galera_3nodes.GCF-363-innodb/'
       
      Retrying test galera_3nodes.GCF-363, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stepan.patryshev Stepan Patryshev
              Reporter:
              stepan.patryshev Stepan Patryshev
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: