Debian Codegraph @

mysql-test/suite/ndb_ddl/metadata_sync_debug.result

raw
1 SET GLOBAL debug = '+d,ndb_dd_client_lfg_force_commit,ndb_schema_trans_commit_fail,ndb_skip_create_tablespace_in_NDB';
2 SET @old_ndb_metadata_check = @@global.ndb_metadata_check;
3 SET @old_ndb_metadata_check_interval = @@global.ndb_metadata_check_interval;
4 CREATE LOGFILE GROUP lg1
5 ADD UNDOFILE 'lg1_undofile.dat'
6 INITIAL_SIZE 1M
7 UNDO_BUFFER_SIZE = 1M
8 ENGINE NDB;
9 Warnings:
10 Warning 1296 Got error 0 'No error' from NDB
11 Warning 1296 Failed to commit NDB schema transaction
12 CREATE TABLESPACE ts1
13 ADD DATAFILE 'ts1_datafile.dat'
14 USE LOGFILE GROUP lg1
15 INITIAL_SIZE 2M
16 ENGINE NDB;
17 SET GLOBAL debug = '-d,ndb_dd_client_lfg_force_commit,ndb_schema_trans_commit_fail,ndb_skip_create_tablespace_in_NDB';
18 SET GLOBAL ndb_metadata_check_interval = 0;
19 SET GLOBAL ndb_metadata_check = true;
20 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check;
21 SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval;
22 CREATE LOGFILE GROUP lg1
23 ADD UNDOFILE 'lg1_undofile.dat'
24 INITIAL_SIZE 1M
25 UNDO_BUFFER_SIZE = 1M
26 ENGINE NDB;
27 CREATE TABLESPACE ts1
28 ADD DATAFILE 'ts1_datafile.dat'
29 USE LOGFILE GROUP lg1
30 INITIAL_SIZE 2M
31 ENGINE NDB;
32 ALTER TABLESPACE ts1
33 ADD DATAFILE 'ts1_datafile2.dat';
34 CREATE TABLE t1 (
35 a INT PRIMARY KEY,
36 b INT
37 ) ENGINE NDB
38 TABLESPACE ts1
39 STORAGE DISK;
40 INSERT INTO t1 VALUES(1,1);
41 SELECT * FROM t1;
42 a b
43 1 1
44 CREATE TABLESPACE ts2
45 ADD DATAFILE 'ts2_datafile.dat'
46 USE LOGFILE GROUP lg1
47 INITIAL_SIZE 2M
48 ENGINE NDB;
49 DROP TABLE t1;
50 ALTER TABLESPACE ts1
51 DROP DATAFILE 'ts1_datafile.dat';
52 ALTER TABLESPACE ts1
53 DROP DATAFILE 'ts1_datafile2.dat';
54 DROP TABLESPACE ts1;
55 ALTER TABLESPACE ts2
56 DROP DATAFILE 'ts2_datafile.dat';
57 DROP TABLESPACE ts2;
58 DROP LOGFILE GROUP lg1
59 ENGINE NDB;
60 CREATE TABLE t1 (
61 a INT PRIMARY KEY,
62 b VARCHAR(255)
63 ) ENGINE NDB;
64 INSERT INTO t1 VALUES
65 (1, 'Rino'),
66 (2, 'Rino'),
67 (3, 'Rino Anto');
68 CREATE TABLE t2 (
69 a INT PRIMARY KEY,
70 b VARCHAR(255)
71 ) ENGINE NDB;
72 INSERT INTO t2 VALUES
73 (4, 'Rino'),
74 (5, 'Rino'),
75 (6, 'Rino Anto');
76 CREATE TABLE t3 (
77 a INT PRIMARY KEY,
78 b VARCHAR(255)
79 ) ENGINE NDB;
80 INSERT INTO t3 VALUES
81 (7, 'Rino'),
82 (8, 'Rino'),
83 (9, 'Rino Anto');
84 CREATE TABLE t4 (
85 a INT PRIMARY KEY,
86 b VARCHAR(255)
87 ) ENGINE NDB;
88 INSERT INTO t4 VALUES(1, 'Hey Rino Anto');
89 CREATE DATABASE db1;
90 CREATE TABLE db1.t1 (
91 a INT PRIMARY KEY,
92 b VARCHAR(255)
93 ) ENGINE NDB;
94 INSERT INTO db1.t1 VALUES
95 (1, 'Weasley'),
96 (2, 'Is Our'),
97 (3, 'King');
98 DROP TABLE t1,t2,t3,t4;
99 DROP DATABASE db1;
100 CREATE TABLE t5 (
101 a INT PRIMARY KEY,
102 b VARCHAR(255)
103 ) ENGINE NDB;
104 SET GLOBAL debug = '+d,ndb_metadata_sync_fail';
105 SET GLOBAL ndb_metadata_check_interval = 0;
106 SET GLOBAL ndb_metadata_check = true;
107 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check;
108 SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval;
109 SHOW STATUS LIKE 'Ndb_metadata_excluded_count';
110 Variable_name Value
111 Ndb_metadata_excluded_count 6
112 SELECT * FROM performance_schema.ndb_sync_excluded_objects;
113 SCHEMA_NAME NAME TYPE REASON
114 db1 NULL SCHEMA Injected failure
115 test t1 TABLE Injected failure
116 test t2 TABLE Injected failure
117 test t3 TABLE Injected failure
118 test t4 TABLE Injected failure
119 test t5 TABLE Injected failure
120 SET GLOBAL ndb_metadata_check_interval = 0;
121 SET GLOBAL ndb_metadata_check = true;
122 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check;
123 SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval;
124 SELECT * FROM t1;
125 a b
126 1 Rino
127 2 Rino
128 3 Rino Anto
129 SELECT * FROM t2;
130 a b
131 4 Rino
132 5 Rino
133 6 Rino Anto
134 SELECT * FROM t3;
135 a b
136 7 Rino
137 8 Rino
138 9 Rino Anto
139 SELECT * FROM t4;
140 a b
141 1 Hey Rino Anto
142 DROP TABLE IF EXISTS t5;
143 CREATE DATABASE db1;
144 SELECT * FROM db1.t1;
145 a b
146 1 Weasley
147 2 Is Our
148 3 King
149 SET GLOBAL ndb_metadata_check_interval = 0;
150 SET GLOBAL ndb_metadata_check = true;
151 SELECT COUNT(*) FROM performance_schema.ndb_sync_excluded_objects;
152 COUNT(*)
153 0
154 SET GLOBAL ndb_metadata_check = @old_ndb_metadata_check;
155 SET GLOBAL ndb_metadata_check_interval = @old_ndb_metadata_check_interval;
156 SET GLOBAL debug = '-d,ndb_metadata_sync_fail';
157 DROP TABLE t1,t2,t3,t4;
158 DROP DATABASE db1;