Debian Codegraph @

mysql-test/suite/ndb_ddl/metadata_sync_pfs.result

raw
1 CREATE LOGFILE GROUP lg1
2 ADD UNDOFILE 'lg1_undofile.dat'
3 INITIAL_SIZE 1M
4 UNDO_BUFFER_SIZE = 1M
5 ENGINE NDB;
6 CREATE TABLESPACE ts1
7 ADD DATAFILE 'ts1_datafile.dat'
8 USE LOGFILE GROUP lg1
9 INITIAL_SIZE 2M
10 ENGINE NDB;
11 CREATE TABLE t1 (
12 a INT PRIMARY KEY,
13 b INT
14 ) ENGINE NDB
15 TABLESPACE ts1
16 STORAGE DISK;
17 CREATE TABLE t2 (
18 a INT PRIMARY KEY,
19 b VARCHAR(255)
20 ) ENGINE NDB;
21 CREATE TABLE t3 (
22 a INT PRIMARY KEY,
23 b VARCHAR(255)
24 ) ENGINE NDB;
25 CREATE DATABASE db1;
26 CREATE TABLE db1.t1 (
27 a INT PRIMARY KEY,
28 b VARCHAR(255)
29 ) ENGINE NDB;
30 Backup
31 DROP TABLE t1,t2,t3;
32 DROP DATABASE db1;
33 ALTER TABLESPACE ts1
34 DROP DATAFILE 'ts1_datafile.dat';
35 DROP TABLESPACE ts1;
36 DROP LOGFILE GROUP lg1
37 ENGINE NDB;
38 Restore backup into NDB Dictionary
39 Wait until the following 6 object changes are detected:
40 - Logfile group 'lg1'
41 - Tablespace 'ts1'
42 - Schema 'db1'
43 - Table 'test.t1'
44 - Table 'test.t2'
45 - Table 'test.t3'
46 SELECT * FROM performance_schema.ndb_sync_pending_objects;
47 SCHEMA_NAME NAME TYPE
48 NULL lg1 LOGFILE GROUP
49 NULL ts1 TABLESPACE
50 db1 NULL SCHEMA
51 test t1 TABLE
52 test t2 TABLE
53 test t3 TABLE
54 Wait until the changes detected have been synced
55 SELECT * FROM performance_schema.ndb_sync_excluded_objects;
56 SCHEMA_NAME NAME TYPE REASON
57 NULL lg1 LOGFILE GROUP Injected failure
58 NULL ts1 TABLESPACE Injected failure
59 db1 NULL SCHEMA Injected failure
60 test t1 TABLE Injected failure
61 test t2 TABLE Injected failure
62 test t3 TABLE Injected failure
63 Restart MySQL server to synchronize metadata
64 # restart
65 DROP TABLE t1,t2,t3;
66 DROP DATABASE db1;
67 ALTER TABLESPACE ts1
68 DROP DATAFILE 'ts1_datafile.dat';
69 DROP TABLESPACE ts1;
70 DROP LOGFILE GROUP lg1
71 ENGINE NDB;