[MDEV-30536] no expected deadlock in galera_insert_bulk test Created: 2023-02-01  Updated: 2023-12-18

Status: Stalled
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.6
Fix Version/s: 10.6

Type: Bug Priority: Critical
Reporter: Julius Goryavsky Assignee: Denis Protivensky
Resolution: Unresolved Votes: 0
Labels: None

Attachments: File mysqld.1.err     File mysqld.2.err    
Issue Links:
Blocks
blocks MDEV-30172 Galera test case cleanup Stalled

 Description   

No expected deadlock in galera_insert_bulk test:

galera.galera_insert_bulk 'innodb'       w2 [ fail ]
        Test ended at 2023-02-01 14:06:22
 
CURRENT_TEST: galera.galera_insert_bulk
mysqltest: At line 42: query 'COMMIT' succeeded - should have failed with error ER_LOCK_DEADLOCK (1213)...
 
The result from queries just before the failure was:
< snip >
connection node_1;
connection node_1;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
SET foreign_key_checks = 0;
SET unique_checks = 0;
START TRANSACTION;
connection node_2;
SET foreign_key_checks = 1;
SET unique_checks = 1;
INSERT INTO t1 VALUES (1001);
connection node_1;
COMMIT;
 
More results from queries before failure can be found in /dev/shm/var/2/log/galera_insert_bulk.log


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