mirror of
https://github.com/MariaDB/server.git
synced 2025-07-21 02:38:14 +02:00
56fbc0cdd7
Test changes only. INSERT may fail for lock wait because in other node we have LOCK TABLE or it may succeed if next statement i.e. UNLOCK TABLES is fast enough. Signed-off-by: Julius Goryavsky <julius.goryavsky@mariadb.com>
41 lines
1.2 KiB
Text
41 lines
1.2 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
|
|
CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
|
|
connection node_2;
|
|
SELECT 1 FROM DUAL;
|
|
1
|
|
1
|
|
LOCK TABLE t2 WRITE;
|
|
connect node_2_ctrl, 127.0.0.1, root, , test, $NODE_MYPORT_2;
|
|
connection node_2_ctrl;
|
|
SET SESSION wsrep_sync_wait=0;
|
|
connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
|
|
connection node_2a;
|
|
OPTIMIZE TABLE t1,t2;;
|
|
connection node_2_ctrl;
|
|
SET SESSION wsrep_sync_wait = 0;
|
|
connect node_2b, 127.0.0.1, root, , test, $NODE_MYPORT_2;
|
|
connection node_2b;
|
|
REPAIR TABLE t1,t2;;
|
|
connection node_2_ctrl;
|
|
connection node_1;
|
|
INSERT INTO t2 VALUES (1);
|
|
connection node_2;
|
|
UNLOCK TABLES;
|
|
connection node_2a;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
|
|
test.t1 optimize status OK
|
|
test.t2 optimize note Table does not support optimize, doing recreate + analyze instead
|
|
test.t2 optimize status OK
|
|
connection node_2b;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 repair note The storage engine for the table doesn't support repair
|
|
test.t2 repair note The storage engine for the table doesn't support repair
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
connection node_1;
|
|
disconnect node_2a;
|
|
disconnect node_2b;
|
|
disconnect node_2_ctrl;
|