[MDEV-20451] Lock wait timeout exceeded in galera_var_ignore_apply_errors Created: 2019-08-30  Updated: 2023-11-25  Resolved: 2021-09-28

Status: Closed
Project: MariaDB Server
Component/s: Galera, Server, Tests
Affects Version/s: 10.5.2, 10.6.0, 10.4
Fix Version/s: 10.4.22, 10.5.13, 10.6.5

Type: Bug Priority: Critical
Reporter: Julius Goryavsky Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Attachments: Zip Archive MDEV-20451_10_4_Logs_201204.zip    
Issue Links:
Relates

 Description   

galera_var_ignore_apply_errors test failed:

galera.galera_var_ignore_apply_errors 'innodb' w2 [ fail ]
 
       Test ended at 2019-08-29 16:37:40
 
 
 
CURRENT_TEST: galera.galera_var_ignore_apply_errors
 
 
 
mysqltest: At line 72: query 'SELECT COUNT(*) = 0 FROM t1' failed: 1205: Lock wait timeout exceeded; try restarting transactionThe result from queries just before the failure was:
 
 
 
< snip >
 
CREATE TABLE t1 (f1 INTEGER);
 
SET GLOBAL wsrep_on = OFF;
 
ALTER TABLE t1 ADD COLUMN f2 INTEGER;
 
SET GLOBAL wsrep_on = ON;
 
ALTER TABLE t1 DROP COLUMN f2;
 
DROP TABLE t1;
 
connection node_2;
 
SET GLOBAL wsrep_ignore_apply_errors = 2;
 
connection node_1;
 
CREATE TABLE t1 (f1 INTEGER);
 
SET GLOBAL wsrep_on = OFF;
 
INSERT INTO t1 VALUES (1);
 
SET GLOBAL wsrep_on = ON;
 
DELETE FROM t1 WHERE f1 = 1;
 
connection node_1;
 
SELECT COUNT(*) = 0 FROM t1;
 
COUNT(*) = 0
 
1
 
connection node_2;
 
SELECT COUNT(*) = 0 FROM t1;More results from queries before failure can be found in /dev/shm/var/2/log/galera_var_ignore_apply_errors.log - saving '/dev/shm/var/2/log/galera.galera_var_ignore_apply_errors-innodb/' to '/dev/shm/var/log/galera.galera_var_ignore_apply_errors-innodb/'Retrying test galera.galera_var_ignore_apply_errors, attempt(2/3)...worker[2] > Restart  - not started
 
worker[2] > Restart  - not started
 
 
 
galera.galera_ddl_multiline 'innodb'     w1 [ pass ]   2182
 
galera.galera_defaults 'innodb'          w1 [ pass ]   2020
 
galera.galera_delete_limit 'innodb'      w1 [ pass ]   2040
 
galera.galera_var_ignore_apply_errors 'innodb' w2 [ retry-pass ]   2161



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-01-16 ]

It fails on BB also:

10.4 19e2a5b12a201197faf6baf9f1af89ab

 
galera.galera_var_ignore_apply_errors 'innodb' w1 [ fail ]
 
        Test ended at 2020-01-16 07:26:03
 
 
 
CURRENT_TEST: galera.galera_var_ignore_apply_errors
 
mysqltest: At line 78: query 'SELECT COUNT(*) as expect_0 FROM t1' failed: 1047: WSREP has not yet prepared node for application use
 
 
 
The result from queries just before the failure was:
 
< snip >
 
CREATE TABLE t1 (f1 INTEGER);
 
SET GLOBAL wsrep_on = OFF;
 
ALTER TABLE t1 ADD COLUMN f2 INTEGER;
 
SET GLOBAL wsrep_on = ON;
 
ALTER TABLE t1 DROP COLUMN f2;
 
DROP TABLE t1;
 
connection node_2;
 
SET GLOBAL wsrep_ignore_apply_errors = 2;
 
connection node_1;
 
CREATE TABLE t1 (f1 INTEGER);
 
SET GLOBAL wsrep_on = OFF;
 
INSERT INTO t1 VALUES (1);
 
SET GLOBAL wsrep_on = ON;
 
DELETE FROM t1 WHERE f1 = 1;
 
connection node_1;
 
SELECT COUNT(*) as expect_0 FROM t1;
 
expect_0
 
0
 
connection node_2;
 
SELECT COUNT(*) as expect_0 FROM t1;
 
 
 
More results from queries before failure can be found in /dev/shm/var/1/log/galera_var_ignore_apply_errors.log
 
 
 
 - saving '/dev/shm/var/1/log/galera.galera_var_ignore_apply_errors-innodb/' to '/dev/shm/var/log/galera.galera_var_ignore_apply_errors-innodb/'
 
 
 
Retrying test galera.galera_var_ignore_apply_errors, attempt(2/3)...
 
 
 
worker[1] > Restart  - not started
 
worker[1] > Restart  - not started

Comment by Stepan Patryshev (Inactive) [ 2020-03-23 ]

It failed also on bb, 10.5.

Comment by Stepan Patryshev (Inactive) [ 2020-05-15 ]

It failed also on CI 10.5 ES, 43b7e5d29a5480214cee8317a4625b749ccffbaf, Build Debug, sles-15.

Comment by Stepan Patryshev (Inactive) [ 2020-12-18 ]

galera.galera_var_ignore_apply_errors failed on BB 10.4 CS: "Server did not transition to READY state".
stdio.log:

10.4.18, a50cb4867a7f63bfc03b33bfb5be8d47d15ba64d, kvm-deb-buster-aarch64

 
galera.galera_var_ignore_apply_errors 'innodb' w2 [ fail ]
 
        Test ended at 2020-12-04 07:39:32
 
 
 
CURRENT_TEST: galera.galera_var_ignore_apply_errors
 
mysqltest: In included file "./include/galera_wait_ready.inc": 
included from /usr/share/mysql/mysql-test/suite/galera/t/galera_var_ignore_apply_errors.test at line 79:
 
At line 28: "Server did not transition to READY state"
 
 
 
The result from queries just before the failure was:
 
< snip >
 
DROP TABLE t1;
 
CREATE TABLE t1 (f1 INTEGER);
 
SET GLOBAL wsrep_on = OFF;
 
ALTER TABLE t1 ADD COLUMN f2 INTEGER;
 
SET GLOBAL wsrep_on = ON;
 
ALTER TABLE t1 DROP COLUMN f2;
 
DROP TABLE t1;
 
connection node_2;
 
SET GLOBAL wsrep_ignore_apply_errors = 2;
 
connection node_1;
 
CREATE TABLE t1 (f1 INTEGER);
 
SET GLOBAL wsrep_on = OFF;
 
INSERT INTO t1 VALUES (1);
 
SET GLOBAL wsrep_on = ON;
 
DELETE FROM t1 WHERE f1 = 1;
 
connection node_1;
 
SELECT COUNT(*) as expect_0 FROM t1;
 
expect_0
 
0
 
connection node_2;
 
 
 
More results from queries before failure can be found in /dev/shm/var/2/log/galera_var_ignore_apply_errors.log
 
 
 
 - saving '/dev/shm/var/2/log/galera.galera_var_ignore_apply_errors-innodb/' to '/dev/shm/var/log/galera.galera_var_ignore_apply_errors-innodb/'
 
 
 
Retrying test galera.galera_var_ignore_apply_errors, attempt(2/3)...
 
 
 
worker[2] > Restart  - not started
 
worker[2] > Restart  - not started
 
galera.galera_var_ignore_apply_errors 'innodb' w2 [ retry-pass ]   2207
 
 
 
Retrying test galera.galera_var_ignore_apply_errors, attempt(3/3)...
 
 
 
galera.galera_var_ignore_apply_errors 'innodb' w2 [ retry-pass ]   2175

Server logs.

Comment by Stepan Patryshev (Inactive) [ 2020-12-23 ]

It still fails on BB, 10.6.

Generated at Thu Feb 08 08:59:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.