diff options
Diffstat (limited to 'mysql-test/suite/galera/r/galera_var_retry_autocommit.result')
| -rw-r--r-- | mysql-test/suite/galera/r/galera_var_retry_autocommit.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_var_retry_autocommit.result b/mysql-test/suite/galera/r/galera_var_retry_autocommit.result index f4d17ad9a41..392728baf7d 100644 --- a/mysql-test/suite/galera/r/galera_var_retry_autocommit.result +++ b/mysql-test/suite/galera/r/galera_var_retry_autocommit.result @@ -1,16 +1,24 @@ +connection node_1; CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB; CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.f2 = SLEEP(5); +connection node_1; SET SESSION wsrep_retry_autocommit = 0; INSERT INTO t1 (f1) VALUES (1),(2);; +connection node_2; TRUNCATE TABLE t1; +connection node_1; ERROR 40001: Deadlock found when trying to get lock; try restarting transaction +connection node_1; SET SESSION wsrep_retry_autocommit = 1; INSERT INTO t1 (f1) VALUES (3),(4);; +connection node_2; TRUNCATE TABLE t1; +connection node_1; SELECT * FROM test.t1; f1 f2 3 0 4 0 +connection node_2; CREATE PROCEDURE repeated_truncate () BEGIN DECLARE i INT; @@ -22,11 +30,15 @@ SET i = i + 1; END WHILE; END| CALL repeated_truncate(); +connection node_1; SET SESSION wsrep_retry_autocommit = 1; INSERT INTO t1 (f1) VALUES (5),(6); ERROR 40001: Deadlock found when trying to get lock; try restarting transaction +connection node_1; SET SESSION wsrep_retry_autocommit = 1024; INSERT INTO t1 (f1) VALUES (7),(8);; +connection node_2; +connection node_1; include/diff_servers.inc [servers=1 2] DROP TABLE t1; DROP PROCEDURE repeated_truncate; |