Debian Codegraph @

mysql-test/suite/ndb/r/ndb_single_user.result

raw
1 Node 1: SINGLE USER MODE
2 Node 2: SINGLE USER MODE
3 create table t1 (a int key, b int unique, c int) engine ndb;
4 ERROR HY000: Can't create table 't1' (use SHOW WARNINGS for more info).
5 show warnings;
6 Level Code Message
7 Warning 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
8 Error 1005 Can't create table 't1' (use SHOW WARNINGS for more info).
9 CREATE LOGFILE GROUP lg1
10 ADD UNDOFILE 'undofile.dat'
11 INITIAL_SIZE 16M
12 UNDO_BUFFER_SIZE = 1M
13 ENGINE=NDB;
14 ERROR HY000: Failed to create LOGFILE GROUP
15 show warnings;
16 Level Code Message
17 Warning 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
18 Warning 1296 Failed to create logfile group 'lg1' in NDB
19 Error 1528 Failed to create LOGFILE GROUP
20 create table t1 (a int key, b int unique, c int) engine ndb;
21 CREATE LOGFILE GROUP lg1
22 ADD UNDOFILE 'undofile.dat'
23 INITIAL_SIZE 16M
24 UNDO_BUFFER_SIZE = 1M
25 ENGINE=NDB;
26 CREATE TABLESPACE ts1
27 ADD DATAFILE 'datafile.dat'
28 USE LOGFILE GROUP lg1
29 INITIAL_SIZE 12M
30 ENGINE NDB;
31 ERROR HY000: Failed to create TABLESPACE
32 show warnings;
33 Level Code Message
34 Warning 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
35 Warning 1296 Failed to create tablespace 'ts1' in NDB
36 Error 1528 Failed to create TABLESPACE
37 DROP LOGFILE GROUP lg1
38 ENGINE =NDB;
39 ERROR HY000: Failed to drop LOGFILE GROUP
40 show warnings;
41 Level Code Message
42 Warning 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
43 Warning 1296 Failed to drop logfile group 'lg1' from NDB
44 Error 1529 Failed to drop LOGFILE GROUP
45 CREATE TABLESPACE ts1
46 ADD DATAFILE 'datafile.dat'
47 USE LOGFILE GROUP lg1
48 INITIAL_SIZE 12M
49 ENGINE NDB;
50 ALTER TABLESPACE ts1
51 DROP DATAFILE 'datafile.dat';
52 ERROR HY000: Failed to alter: DROP DATAFILE FAILED
53 show warnings;
54 Level Code Message
55 Warning 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
56 Warning 1296 Failed to drop datafile 'datafile.dat' from NDB
57 Error 1533 Failed to alter: DROP DATAFILE FAILED
58 ALTER TABLESPACE ts1
59 DROP DATAFILE 'datafile.dat';
60 DROP TABLESPACE ts1;
61 ERROR HY000: Failed to drop TABLESPACE
62 show warnings;
63 Level Code Message
64 Warning 1296 Got error 299 'Operation not allowed or aborted due to single user mode' from NDB
65 Warning 1296 Failed to drop tablespace 'ts1' from NDB
66 Error 1529 Failed to drop TABLESPACE
67 DROP TABLESPACE ts1;
68 DROP LOGFILE GROUP lg1
69 ENGINE =NDB;
70 insert into t1 values (1,1,0),(2,2,0),(3,3,0),(4,4,0),(5,5,0),(6,6,0),(7,7,0),(8,8,0),(9,9,0),(10,10,0);
71 create table t2 as select * from t1;
72 select * from t1 where a = 1;
73 a b c
74 1 1 0
75 select * from t1 where b = 4;
76 a b c
77 4 4 0
78 select * from t1 where a > 4 order by a;
79 a b c
80 5 5 0
81 6 6 0
82 7 7 0
83 8 8 0
84 9 9 0
85 10 10 0
86 update t1 set b=102 where a = 2;
87 update t1 set b=103 where b = 3;
88 update t1 set b=b+100;
89 update t1 set b=b+100 where a > 7;
90 delete from t1;
91 insert into t1 select * from t2;
92 create unique index new_index on t1 (b,c);
93 Cluster Configuration
94 ---------------------
95 [ndbd(NDB)] 2 node(s)
96 id=1 LOCALHOST (MYSQL_VERSION NDB_VERSION, single user mode, Nodegroup: 0, *)
97 id=2 LOCALHOST (MYSQL_VERSION NDB_VERSION, single user mode, Nodegroup: 0)
98
99 [ndb_mgmd(MGM)] 1 node(s)
100 id=3 LOCALHOST (MYSQL_VERSION NDB_VERSION)
101
102 [MYSQL_VERSION NDB_VERSION)] 14 node(s)
103 id=16 LOCALHOST (MYSQL_VERSION NDB_VERSION)
104 id=32 (not connected, accepting connect from localhost)
105 id=48 (not connected, accepting connect from localhost)
106 id=49 LOCALHOST (MYSQL_VERSION NDB_VERSION, allowed single user)
107 id=63 (not connected, accepting connect from localhost)
108 id=127 (not connected, accepting connect from localhost)
109 id=192 (not connected, accepting connect from localhost)
110 id=228 (not connected, accepting connect from localhost)
111 id=229 (not connected, accepting connect from localhost)
112 id=230 (not connected, accepting connect from localhost)
113 id=231 (not connected, accepting connect from localhost)
114 id=232 (not connected, accepting connect from localhost)
115 id=233 (not connected, accepting connect from localhost)
116 id=255 (not connected, accepting connect from localhost)
117
118 drop table t2;
119 drop table t1;
120 ERROR HY000: Storage engine can't drop table 'test.t1'
121 create index new_index_fail on t1 (c);
122 ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
123 insert into t1 values (21,21,0),(22,22,0),(23,23,0),(24,24,0),(25,25,0),(26,26,0),(27,27,0),(28,28,0),(29,29,0),(210,210,0);
124 ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
125 select * from t1 where a = 1;
126 ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
127 select * from t1 where b = 4;
128 ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
129 update t1 set b=102 where a = 2;
130 ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
131 update t1 set b=103 where b = 3;
132 ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
133 update t1 set b=b+100;
134 ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
135 update t1 set b=b+100 where a > 7;
136 ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
137 Node 1: STARTED
138 Node 2: STARTED
139 BEGIN;
140 update t1 set b=b+100 where a=1;
141 BEGIN;
142 update t1 set b=b+100 where a=2;
143 Node 1: SINGLE USER MODE
144 Node 2: SINGLE USER MODE
145 update t1 set b=b+100 where a=3;
146 COMMIT;
147 update t1 set b=b+100 where a=4;
148 ERROR HY000: Got error 299 'Operation not allowed or aborted due to single user mode' from NDBCLUSTER
149 ROLLBACK;
150 create table t2 (a int) engine myisam;
151 alter table t2 add column (b int);
152 Node 1: STARTED
153 Node 2: STARTED
154 drop table t2;
155 drop table t1;