[MDEV-26815] galera.galera_ftwrl_drain fails with wrong errno 1146 Created: 2021-07-07  Updated: 2022-08-19  Resolved: 2021-10-13

Status: Closed
Project: MariaDB Server
Component/s: Debug, Galera, Tests
Affects Version/s: 10.2, 10.3
Fix Version/s: 10.2.41, 10.3.32, 10.4.22, 10.5.13, 10.6.5

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: affects-tests

Issue Links:
Relates

 Description   

10.2-enterprise 0f6624fe (latest of Jul 08, 2021) + galera-enterprise-3-25.3.33

galera.galera_ftwrl_drain 'innodb'       [ fail ]
        Test ended at 2021-07-08 01:30:37
 
CURRENT_TEST: galera.galera_ftwrl_drain
mysqltest: At line 58: query 'INSERT INTO t2 VALUES (2)' failed with wrong errno 1146: 'Table 'test.t2' doesn't exist', instead of 1205...
 
The result from queries just before the failure was:
< snip >
INSERT INTO t1 VALUES (1);
connection node_2;
SET SESSION wsrep_sync_wait = 0;
SET SESSION wsrep_on = 0;
SET SESSION wsrep_on = 1;
SELECT COUNT(*) = 0 FROM t1;
COUNT(*) = 0
1
connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
connection node_2a;
FLUSH TABLES WITH READ LOCK;;
connection node_2;
SET GLOBAL wsrep_provider_options = 'dbug=';
SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
connection node_2a;
connection node_2;
SET SESSION lock_wait_timeout = 1;
SET SESSION innodb_lock_wait_timeout=1;
SET SESSION wait_timeout=1;
INSERT INTO t2 VALUES (2);

Reproducible on 10.2/10.3 ES.
I couldn't reproduce it on 10.2 CS and on 10.4 ES, but please double-check.



 Comments   
Comment by Elena Stepanova [ 2021-07-07 ]

It fails constantly in Jenkins.

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