diff options
Diffstat (limited to 'mysql-test/suite/galera/r/MDEV-20793.result')
| -rw-r--r-- | mysql-test/suite/galera/r/MDEV-20793.result | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/MDEV-20793.result b/mysql-test/suite/galera/r/MDEV-20793.result new file mode 100644 index 00000000000..b420c8720f5 --- /dev/null +++ b/mysql-test/suite/galera/r/MDEV-20793.result @@ -0,0 +1,39 @@ +connection node_2; +connection node_1; +CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 INT); +INSERT INTO t1 VALUES (1, 0), (5, 0); +connection node_1_ctrl; +SET SESSION wsrep_sync_wait = 0; +SET GLOBAL wsrep_slave_threads = 2; +connection node_1; +SET SESSION wsrep_retry_autocommit = 0; +START TRANSACTION; +UPDATE t1 SET f2 = 1; +SET SESSION debug_sync = "wsrep_before_replay SIGNAL reached WAIT_FOR continue"; +connection node_1_ctrl; +SET GLOBAL wsrep_provider_options = 'dbug=d,apply_monitor_slave_enter_sync'; +connection node_2; +INSERT INTO t1 VALUES (2, 2); +connection node_1_ctrl; +SET SESSION wsrep_on = 0; +SET SESSION wsrep_on = 1; +SET GLOBAL wsrep_provider_options = 'dbug='; +SET GLOBAL wsrep_provider_options = 'dbug=d,local_monitor_slave_enter_sync'; +connection node_2; +UPDATE t1 SET f2 = 2 WHERE f1 = 5; +connection node_1_ctrl; +SET SESSION wsrep_on = 0; +SET SESSION wsrep_on = 1; +connection node_1; +COMMIT; +connection node_1_ctrl; +SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync'; +SET SESSION debug_sync = "now WAIT_FOR reached"; +SET GLOBAL wsrep_provider_options = 'signal=local_monitor_slave_enter_sync'; +SET GLOBAL wsrep_provider_options = 'dbug='; +SET SESSION debug_sync = "now SIGNAL continue"; +connection node_1; +ERROR 40001: Deadlock found when trying to get lock; try restarting transaction +SET debug_sync = "RESET"; +DROP TABLE t1; +SET GLOBAL wsrep_slave_threads = 1; |