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

galera.galera_toi_lock_shared MTR failed: WSREP: ALTER TABLE isolation failure

    XMLWordPrintable

    Details

      Description

      galera.galera_toi_lock_shared failed on BB 10.4 CS and on BB 10.5 CS: "'ALTER TABLE t1 ADD COLUMN f2 INTEGER, LOCK=SHARED' failed: 1146: Table 'test.t1' doesn't exist".
      It seems to be a sporadic issue.

      stdio.log:

      10.4.18, a50cb4867a7f63bfc03b33bfb5be8d47d15ba64d, kvm-rpm-centos74-aarch64

      galera.galera_toi_lock_shared 'innodb'   w1 [ fail ]
              Test ended at 2020-12-04 01:27:49
       
      CURRENT_TEST: galera.galera_toi_lock_shared
      mysqltest: At line 13: query 'ALTER TABLE t1 ADD COLUMN f2 INTEGER, LOCK=SHARED' 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 (id INT PRIMARY KEY) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1);
      connection node_2;
      ALTER TABLE t1 ADD COLUMN f2 INTEGER, LOCK=SHARED;
       
       - saving '/dev/shm/var/1/log/galera.galera_toi_lock_shared-innodb/' to '/dev/shm/var/log/galera.galera_toi_lock_shared-innodb/'
       
      Retrying test galera.galera_toi_lock_shared, attempt(2/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      galera.galera_mdev_15611 'innodb'        w2 [ pass ]   2388
      worker[2] > Restart [mysqld.1 - pid: 16448, winpid: 16448] - using different config file
      worker[2] > Restart [mysqld.2 - pid: 16492, winpid: 16492] - using different config file
      galera.galera_toi_lock_shared 'innodb'   w1 [ retry-pass ]   2085
       
      Retrying test galera.galera_toi_lock_shared, attempt(3/3)...
       
      galera.galera_toi_lock_shared 'innodb'   w1 [ retry-pass ]   2069
      

      10.4 CS Server logs.

      galera.galera_toi_lock_shared failed on BB 10.6 CS with another output: "[Warning] WSREP: ALTER TABLE isolation failure".

      stdio.log:

      10.6.0, a13fac9eeef0f304b6b6f52ad2b6659f22190523, kvm-deb-bionic-amd64

      galera.galera_toi_lock_shared 'innodb'   w2 [ fail ]  Found warnings/errors in server log file!
              Test ended at 2020-12-03 05:04:19
      line
      2020-12-03  5:04:19 119 [Warning] WSREP: ALTER TABLE isolation failure
      ^ Found warnings in /dev/shm/var/2/log/mysqld.2.err
      ok
       
       - saving '/dev/shm/var/2/log/galera.galera_toi_lock_shared-innodb/' to '/dev/shm/var/log/galera.galera_toi_lock_shared-innodb/'
       
      Retrying test galera.galera_toi_lock_shared, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      galera.galera_toi_lock_shared 'innodb'   w2 [ retry-pass ]   2074
       
      Retrying test galera.galera_toi_lock_shared, attempt(3/3)...
       
      galera.galera_toi_lock_shared 'innodb'   w2 [ retry-pass ]   2064
      

      10.6 CS Server logs.

        Attachments

          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:
              Resolved: