Debian Codegraph @

mysql-test/suite/rpl/t/rpl_parallel_partition.test

raw
1 --source include/have_partition.inc
2 --source include/have_innodb.inc
3 --source include/have_debug.inc
4 --source include/master-slave.inc
5
6 --connection server_2
7 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
8 --source include/stop_slave.inc
9 SET @old_dbug= @@GLOBAL.debug_dbug;
10 SET GLOBAL debug_dbug="+d,inject_wakeup_subsequent_commits_sleep";
11 SET GLOBAL slave_parallel_threads=8;
12
13 --echo *** MDEV-8147: Assertion `m_lock_type == 2' failed in handler::ha_close() during parallel replication ***
14 --connection server_1
15 CREATE TABLE E (
16 pk INTEGER AUTO_INCREMENT,
17 col_int_nokey INTEGER /*! NULL */,
18 col_int_key INTEGER /*! NULL */,
19
20 col_date_key DATE /*! NULL */,
21 col_date_nokey DATE /*! NULL */,
22
23 col_time_key TIME /*! NULL */,
24 col_time_nokey TIME /*! NULL */,
25
26 col_datetime_key DATETIME /*! NULL */,
27 col_datetime_nokey DATETIME /*! NULL */,
28
29 col_varchar_key VARCHAR(1) /*! NULL */,
30 col_varchar_nokey VARCHAR(1) /*! NULL */,
31
32 PRIMARY KEY (pk),
33 KEY (col_int_key),
34 KEY (col_date_key),
35 KEY (col_time_key),
36 KEY (col_datetime_key),
37 KEY (col_varchar_key, col_int_key)
38 ) ENGINE=InnoDB;
39
40 ALTER TABLE `E` PARTITION BY KEY() PARTITIONS 5;
41 ALTER TABLE `E` REMOVE PARTITIONING;
42 --write_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
43 wait
44 EOF
45 --shutdown_server
46 --source include/wait_until_disconnected.inc
47 --connection default
48 --source include/wait_until_disconnected.inc
49 --append_file $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
50 restart:
51 EOF
52 --enable_reconnect
53 --source include/wait_until_connected_again.inc
54 --connection server_1
55 --enable_reconnect
56 --source include/wait_until_connected_again.inc
57 CREATE TABLE t1 (a INT PRIMARY KEY);
58 --save_master_pos
59
60 --connection server_2
61 --source include/start_slave.inc
62 --sync_with_master
63
64 # Re-spawn worker threads to clear dbug injection.
65 --source include/stop_slave.inc
66 SET GLOBAL debug_dbug=@old_dbug;
67 SET GLOBAL slave_parallel_threads=0;
68 SET GLOBAL slave_parallel_threads=8;
69 --source include/start_slave.inc
70
71
72 # Clean up.
73 --connection server_2
74 --source include/stop_slave.inc
75 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
76 --source include/start_slave.inc
77
78 --connection server_1
79 DROP TABLE `E`;
80 DROP TABLE t1;
81 --source include/rpl_end.inc