[MDEV-29880] Galera test failure on GCF-336 Created: 2022-10-26  Updated: 2022-11-29  Resolved: 2022-11-29

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4
Fix Version/s: 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3

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


 Description   

galera_3nodes_sr.GCF-336 'innodb'        w4 [ fail ]
        Test ended at 2022-10-26 08:36:35
 
CURRENT_TEST: galera_3nodes_sr.GCF-336
mysqltest: At line 29: query 'COMMIT' succeeded - should have failed with errno 1047...
 
The result from queries just before the failure was:
< snip >
connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
connection node_2a;
SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
COUNT(*) > 0
1
connection node_1;
SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
COUNT(*) > 0
1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT COUNT(*) > 0 FROM t1;
COUNT(*) > 0
1
connection node_2a;
SET GLOBAL wsrep_provider_options = 'gmcast.isolate=1';
SET SESSION wsrep_sync_wait=0;
connection node_2;
INSERT INTO t1 VALUES (2);
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
COMMIT;
 
More results from queries before failure can be found in /home/jan/mysql/10.4/mysql-test/var/4/log/GCF-336.log
 
Warnings from just before the error:
Error 1030 Got error 1213 "Unknown error 1213" from storage engine InnoDB



 Comments   
Comment by Jan Lindström (Inactive) [ 2022-11-29 ]
Generated at Thu Feb 08 10:11:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.