Details
Major 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.
|
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
|
galera.galera_toi_lock_shared failed on BB 10.6 CS with another output: "[Warning] WSREP: ALTER TABLE isolation failure".
|
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
|