[MDEV-15794] Test failure on galera.galera_var_retry_autocommit Created: 2018-04-06  Updated: 2022-05-24  Resolved: 2018-04-27

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.1, 10.2, 10.3
Fix Version/s: 10.1.33, 10.2.15, 10.3.7

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

Issue Links:
Blocks
blocks MDEV-13549 Galera 3 test failures Closed

 Description   

How to repeat:

  • cmake . -DBUILD_CONFIG=mysql_release
  • mtr --suite=galera --vardir=/dev/shm --force --parallel=4

galera.galera_var_retry_autocommit 'innodb_plugin' w1 [ fail ]
        Test ended at 2018-04-06 16:14:49
 
CURRENT_TEST: galera.galera_var_retry_autocommit
mysqltest: At line 73: query 'INSERT INTO t1 (f1) VALUES (5),(6)' succeeded - should have failed with errno 1213...
 
The result from queries just before the failure was:
< snip >
SET SESSION wsrep_retry_autocommit = 1;
INSERT INTO t1 (f1) VALUES (3),(4);;
TRUNCATE TABLE t1;
SELECT * FROM test.t1;
f1	f2
3	0
4	0
CREATE PROCEDURE repeated_truncate ()
BEGIN
DECLARE i INT;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
SET i = 0;
WHILE i <= 1000 DO
TRUNCATE TABLE t1;
SET i = i + 1;
END WHILE;
END|
CALL repeated_truncate();
SET SESSION wsrep_retry_autocommit = 1;
INSERT INTO t1 (f1) VALUES (5),(6);
 
More results from queries before failure can be found in /dev/shm/1/log/galera_var_retry_autocommit.log


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