Debian Codegraph @

mysql-test/suite/ndb_ddl/util_tables_drop.test

raw
1 --source connect.inc
2
3 #
4 # Test behavior of ndbcluster and in particular the "ndb binlog thread"
5 # when its util tables are dropped from NDB.
6 # - the tables are important for the functionality of binlog and schema
7 # distribution
8 # - currently there are three util tables created by ndbcluster:
9 # 1) mysql.ndb_schema
10 # -- communication between the MySQL Servers during schema distribution
11 # -- hidden for both DDL and DML for a MySQL Server user
12 # -- schema distribution will be disabled if table is dropped from NDB
13 # -- the "ndb binlog thread" will continously attempt to recreate the table
14 # in order to enable schema distribution functionality
15 # 2) mysql.ndb_schema_result
16 # -- communication between the MySQL Servers during schema distribution
17 # -- hidden for both DDL and DML for a MySQL Server user
18 # -- schema distribution will be disabled if table is dropped from NDB
19 # -- the "ndb binlog thread" will continously attempt to recreate the table
20 # in order to enable schema distribution functionality
21 # 3) mysql.ndb_apply_status
22 # -- keeps a record of the operations that have been replicated
23 # -- currently not hidden for either DDL or DML for a MySQL Server user
24 # -- if this table is dropped from NDB, the "ndb binlog thread" will
25 # have an outage, which means it will:
26 # --- stop logging changes from NDB
27 # --- write error message(s) to log file
28 # --- tear everything down and restart itself
29 # --- create the table again while reconnecting to NDB
30 #
31
32 # Silence the expected errors which occur when util tables are dropped
33 --disable_query_log
34 let $i = $NUM_MYSQLDS;
35 while($i)
36 {
37 --connection mysqld$i
38 call mtr.add_suppression("An incident event has been written");
39 dec $i;
40 }
41 --enable_query_log
42
43 let $util_table_name = ndb_schema;
44 --source check_util_table_drop.inc
45
46 let $util_table_name = ndb_apply_status;
47 --source check_util_table_drop.inc
48
49 let $util_table_name = ndb_schema_result;
50 --source check_util_table_drop.inc
51