mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 18:05:32 +01:00
10 lines
342 B
Text
10 lines
342 B
Text
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(6)) ENGINE=InnoDB;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES (1,'node_2');
|
|
INSERT INTO t1 VALUES (1,'node_1');
|
|
INSERT INTO t1 VALUES (2, 'node_2');
|
|
ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
|
|
wsrep_local_aborts_increment
|
|
1
|
|
DROP TABLE t1;
|