Details
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
|
|
Attachments
Issue Links
- blocks
-
MDEV-13549 Galera 3 test failures
- Closed