Debian Codegraph @

mysql-test/suite/atomic/drop_view.test

raw
1 --source include/have_debug.inc
2 --source include/have_log_bin.inc
3 --source include/not_valgrind.inc
4
5 #
6 # Testing of atomic drop of view with crashes in a lot of different places
7 #
8
9 # Speed up wait_until_connected_again.inc
10 let NO_WSREP=1;
11 RESET MASTER;
12 let $MYSQLD_DATADIR= `SELECT @@datadir`;
13
14 let $engine_count=1;
15 let $engines='aria';
16
17 let $crash_count=4;
18 let $crash_points='ddl_log_drop_before_delete_view', 'ddl_log_drop_after_delete_view', 'ddl_log_drop_before_binlog', 'ddl_log_drop_after_binlog';
19
20 # Number of drops in the tested statement
21 let $drops=2;
22
23 let $old_debug=`select @@debug_dbug`;
24
25 let $e=0;
26 let $keep_include_silent=1;
27 let $grep_script=DROP ;
28 --disable_query_log
29
30 while ($e < $engine_count)
31 {
32 inc $e;
33 let $engine=`select ELT($e, $engines)`;
34 let $default_engine=$engine;
35 let $extra_option=;
36
37 if ($engine == "aria")
38 {
39 let $extra_option=transactional=1;
40 }
41 if ($engine == "aria_notrans")
42 {
43 let $default_engine="aria";
44 let $extra_option=transactional=0;
45 }
46
47 --eval set @@default_storage_engine=$default_engine
48 --eval create table t1 (a int not null) $extra_option;
49 --eval create table t2 (b int not null) $extra_option;
50 insert into t1 values(1);
51 insert into t2 values(2);
52 flush tables;
53
54 let $c=0;
55 while ($c < $crash_count)
56 {
57 inc $c;
58 let $crash=`select ELT($c, $crash_points)`;
59 let $r=0;
60 while ($r < $drops)
61 {
62 inc $r;
63 create view v1 as select * from t1;
64 create view v2 as select * from t1;
65
66 FLUSH BINARY LOGS;
67 --let $start_binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
68
69 echo "engine: $engine crash point: $crash position: $r";
70 --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
71 --disable_reconnect
72 --eval set @@debug_dbug="+d,$crash",@debug_crash_counter=$r
73 let $errno=0;
74 --error 0,2013
75 DROP VIEW v1,v2;
76 let $error=$errno;
77 --enable_reconnect
78 --source include/wait_until_connected_again.inc
79 --disable_query_log
80 --eval set @@debug_dbug="$old_debug"
81
82 if ($error == 0)
83 {
84 echo "No crash!";
85 }
86 # Check which tables still exists
87 --list_files $MYSQLD_DATADIR/test v*
88
89 --let $binlog_file=$start_binlog_file
90 --let $binlog_output_name=master-bin.000001
91 --source include/show_binlog_events.inc
92 if ($error)
93 {
94 --let $binlog_file= query_get_value(SHOW MASTER STATUS, File, 1)
95 --let $binlog_output_name=master-bin.000002
96 if ($binlog_file != $start_binlog_file)
97 {
98 --source include/show_binlog_events.inc
99 }
100 }
101 # Really drop the views
102 --disable_warnings
103 drop view if exists v1,v2;
104 --enable_warnings
105 }
106 }
107 drop table t1,t2;
108 }
109
110 --enable_query_log