Debian Codegraph @

mysql-test/suite/galera/t/galera_ddl_fk_conflict_with_tmp.inc

raw
1 --echo ######################################################################
2 --echo # Test for $table_admin_command $table_admin_command_end
3 --echo ######################################################################
4
5
6 --connection node_1
7 SET SESSION wsrep_sync_wait=0;
8
9 CREATE TABLE p1 (pk INTEGER PRIMARY KEY, f2 CHAR(30));
10 INSERT INTO p1 VALUES (1, 'INITIAL VALUE');
11
12
13 CREATE TABLE c1 (pk INTEGER PRIMARY KEY, fk INTEGER, FOREIGN KEY (fk) REFERENCES p1(pk));
14 INSERT INTO c1 VALUES (1,1);
15
16 --echo ######################################################################
17 --echo #
18 --echo # Scenario #4: DML working on FK parent table tries to replicate, but
19 --echo # fails in certification for earlier DDL on child table
20 --echo # and another temporary table. TMP table should be skipped
21 --echo # but FK child table should be replicated with proper keys
22 --echo #
23 --echo ######################################################################
24
25 --connection node_1
26 BEGIN;
27
28 # Block the applier on node #1 and issue DDL on node 2
29 --let $galera_sync_point = apply_monitor_slave_enter_sync
30 --source include/galera_set_sync_point.inc
31
32 --connection node_2
33 # wait for tables to be created in node 2 and all rows inserted as well
34 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/c1'
35 --source include/wait_condition.inc
36 --let $wait_condition = SELECT COUNT(*) = 1 FROM c1
37 --source include/wait_condition.inc
38 CREATE TEMPORARY TABLE tmp1 (i int);
39 CREATE TEMPORARY TABLE tmp2 (i int);
40 --eval $table_admin_command tmp1, c1, tmp2 $table_admin_command_end
41
42 --connection node_1a
43 --source include/galera_wait_sync_point.inc
44 --source include/galera_clear_sync_point.inc
45 --let $expected_cert_failures = `SELECT VARIABLE_VALUE+1 FROM information_schema.global_status WHERE VARIABLE_NAME = 'wsrep_local_cert_failures'`
46
47 --connection node_1
48 INSERT INTO p1 VALUES (10, 'TO DEADLOCK');
49 --send COMMIT
50
51 --connection node_1a
52 --let $wait_condition = SELECT VARIABLE_VALUE = $expected_cert_failures FROM information_schema.global_status WHERE VARIABLE_NAME = 'wsrep_local_cert_failures'
53 --source include/wait_condition.inc
54
55 --let $galera_sync_point = apply_monitor_slave_enter_sync
56 --source include/galera_signal_sync_point.inc
57
58 --connection node_1
59 --error ER_LOCK_DEADLOCK
60 --reap
61
62 SELECT 'I deadlocked';
63 SELECT COUNT(*) AS EXPECT_1 FROM p1 WHERE f2 = 'INITIAL VALUE';
64
65 --connection node_2
66 SELECT COUNT(*) AS EXPECT_1 FROM p1 WHERE f2 = 'INITIAL VALUE';
67
68 DROP TABLE IF EXISTS c1;
69 DROP TABLE p1;
70 DROP TABLE IF EXISTS tmp1, tmp2;