Debian Codegraph @

mysql-test/suite/ndb_ddl/metadata_sync_pfs.test

raw
1 --source connect.inc
2 --source include/have_debug.inc
3 --source suite/ndb/include/backup_restore_setup.inc
4
5 #
6 # This test focuses on the metadata sync related performance schema
7 # tables: ndb_sync_pending_objects and ndb_sync_excluded_objects
8 #
9
10 # Create metadata
11 CREATE LOGFILE GROUP lg1
12 ADD UNDOFILE 'lg1_undofile.dat'
13 INITIAL_SIZE 1M
14 UNDO_BUFFER_SIZE = 1M
15 ENGINE NDB;
16
17 CREATE TABLESPACE ts1
18 ADD DATAFILE 'ts1_datafile.dat'
19 USE LOGFILE GROUP lg1
20 INITIAL_SIZE 2M
21 ENGINE NDB;
22
23 CREATE TABLE t1 (
24 a INT PRIMARY KEY,
25 b INT
26 ) ENGINE NDB
27 TABLESPACE ts1
28 STORAGE DISK;
29
30 CREATE TABLE t2 (
31 a INT PRIMARY KEY,
32 b VARCHAR(255)
33 ) ENGINE NDB;
34
35 CREATE TABLE t3 (
36 a INT PRIMARY KEY,
37 b VARCHAR(255)
38 ) ENGINE NDB;
39
40 CREATE DATABASE db1;
41 CREATE TABLE db1.t1 (
42 a INT PRIMARY KEY,
43 b VARCHAR(255)
44 ) ENGINE NDB;
45
46 --echo Backup
47 --disable_query_log
48 --source include/ndb_backup.inc
49 --enable_query_log
50
51 # Drop metadata
52 DROP TABLE t1,t2,t3;
53 DROP DATABASE db1;
54 ALTER TABLESPACE ts1
55 DROP DATAFILE 'ts1_datafile.dat';
56 DROP TABLESPACE ts1;
57 DROP LOGFILE GROUP lg1
58 ENGINE NDB;
59
60 --echo Restore backup into NDB Dictionary
61 --exec $NDB_RESTORE -b $the_backup_id -n 1 -m $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
62
63 # Store initial counts of both detected and synchronized objects
64 --let $initial_detected_count = query_get_value(SHOW STATUS LIKE 'Ndb_metadata_detected_count', Value, 1)
65 --let $initial_synced_count = query_get_value(SHOW STATUS LIKE 'Ndb_metadata_synced_count', Value, 1)
66
67 --disable_query_log
68 # Skip synchronization of detected objects to obtain deterministic results
69 # in the ndb_sync_pending_objects table
70 SET GLOBAL debug = '+d,skip_ndb_metadata_sync';
71 # Enable metadata check with no interval so changes are detected quickly
72 SET @old_ndb_metadata_check = @@global.ndb_metadata_check;
73 SET @old_ndb_metadata_check_interval = @@global.ndb_metadata_check_interval;
74 SET GLOBAL ndb_metadata_check_interval = 0;
75 SET GLOBAL ndb_metadata_check = true;
76 --enable_query_log
77
78 --echo Wait until the following 6 object changes are detected:
79 --echo - Logfile group 'lg1'
80 --echo - Tablespace 'ts1'
81 --echo - Schema 'db1'
82 --echo - Table 'test.t1'
83 --echo - Table 'test.t2'
84 --echo - Table 'test.t3'
85 --let $expected_changes = 6
86 --let $max_wait = 60
87 --source wait_metadata_changes_detected.inc
88
89 --disable_query_log
90 # Reset values
91 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check;
92 SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval;
93 --enable_query_log
94
95 --sorted_result
96 SELECT * FROM performance_schema.ndb_sync_pending_objects;
97
98 # Enable sync again with the injected failures resulting in the
99 # ndb_sync_excluded_objects table being populated
100 --disable_query_log
101 SET GLOBAL debug = '+d,ndb_metadata_sync_fail';
102 SET GLOBAL debug = '-d,skip_ndb_metadata_sync';
103 --enable_query_log
104
105 --echo Wait until the changes detected have been synced
106 --let $max_wait = 60
107 --source wait_metadata_synced.inc
108
109 # Verify that the objects have been excluded
110 --sorted_result
111 SELECT * FROM performance_schema.ndb_sync_excluded_objects;
112
113 # Remove injected failure
114 --disable_query_log ONCE
115 SET GLOBAL debug = '-d,ndb_metadata_sync_fail';
116
117 --echo Restart MySQL server to synchronize metadata
118 let $mysqld_name=mysqld.1.1;
119 --source include/restart_mysqld.inc
120
121 # Clean-up
122 DROP TABLE t1,t2,t3;
123 DROP DATABASE db1;
124 ALTER TABLESPACE ts1
125 DROP DATAFILE 'ts1_datafile.dat';
126 DROP TABLESPACE ts1;
127 DROP LOGFILE GROUP lg1
128 ENGINE NDB;
129 --source suite/ndb/include/backup_restore_cleanup.inc
130 --remove_file $NDB_TOOLS_OUTPUT