[MDEV-24447] galera.galera_toi_lock_shared MTR failed: WSREP: ALTER TABLE isolation failure Created: 2020-12-18  Updated: 2021-01-15  Resolved: 2021-01-12

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.18, 10.5.9, 10.6.0
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6.0

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

kvm-rpm-centos74-aarch64, kvm-deb-bionic-amd64


Attachments: Zip Archive MDEV-24447_10_4_logs_201204.zip     Zip Archive MDEV-24447_10_6_logs_201203.zip    

 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.



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2021-01-04 ]

Fixed "'ALTER TABLE t1 ADD COLUMN f2 INTEGER, LOCK=SHARED' failed: 1146: Table 'test.t1' doesn't exist" part.

Generated at Thu Feb 08 09:30:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.