EVOLUTION-MANAGER

Edit File: galera_unicode_pk.result

CREATE TABLE t1 ( f1 VARCHAR(255) PRIMARY KEY ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO t1 VALUES ('текст'); connection node_2; SELECT f1 = 'текст' FROM t1; f1 = 'текст' 1 connection node_1; SET AUTOCOMMIT=OFF; START TRANSACTION; UPDATE t1 SET f1 = 'текст2'; connection node_2; SET AUTOCOMMIT=OFF; START TRANSACTION; UPDATE t1 SET f1 = 'текст3'; connection node_1; COMMIT; connection node_2; COMMIT; ERROR 40001: Deadlock: wsrep aborted transaction SELECT f1 = 'текст2' FROM t1; f1 = 'текст2' 1 SELECT f1 = 'текст2' FROM t1 WHERE f1 = 'текст2'; f1 = 'текст2' 1 connection node_2; START TRANSACTION; INSERT INTO t1 VALUES ('текст4'); connection node_1; START TRANSACTION; INSERT INTO t1 VALUES ('текст4'); connection node_2; COMMIT; connection node_1; COMMIT; ERROR 40001: Deadlock: wsrep aborted transaction COMMIT; DROP TABLE t1;