153 lines
5.4 KiB
Plaintext
153 lines
5.4 KiB
Plaintext
"Create nodegroup with out-of-range node ID"
|
|
* 325: Error
|
|
* 325-Invalid node(s) specified for new nodegroup, node ID invalid or undefined: Permanent error: Application error
|
|
* 325: Error
|
|
* 325-Invalid node(s) specified for new nodegroup, node ID invalid or undefined: Permanent error: Application error
|
|
"Create nodegroup with in-range but inactive node ID"
|
|
* 322: Error
|
|
* 322-Invalid node(s) specified for new nodegroup, node already in nodegroup: Permanent error: Application error
|
|
* 322: Error
|
|
* 322-Invalid node(s) specified for new nodegroup, node already in nodegroup: Permanent error: Application error
|
|
ndbd(s)
|
|
id=1 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 0, *)
|
|
id=2 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 0)
|
|
id=3 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, no nodegroup)
|
|
id=4 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, no nodegroup)
|
|
ndb_mgmd(s)
|
|
id=5 @127.0.0.1 (MYSQL_VERSION NDB_VERSION)
|
|
mysqld(s)
|
|
id=16 @127.0.0.1 (MYSQL_VERSION NDB_VERSION)
|
|
CREATE LOGFILE GROUP lg_1
|
|
ADD UNDOFILE 'undo_1.dat'
|
|
INITIAL_SIZE 4M
|
|
UNDO_BUFFER_SIZE 2M
|
|
ENGINE NDB;
|
|
CREATE TABLESPACE ts_1
|
|
ADD DATAFILE 'data_1.dat'
|
|
USE LOGFILE GROUP lg_1
|
|
INITIAL_SIZE 16M
|
|
ENGINE NDB;
|
|
create table t1(id int, data char(8), id2 binary(80), primary key (id, id2)) engine=ndb;
|
|
create table t2(id int NOT NULL PRIMARY KEY, data char(8))
|
|
TABLESPACE ts_1 STORAGE DISK engine=ndb;
|
|
create table t5(id int NOT NULL PRIMARY KEY, data char(8)) max_rows=50000000 engine=ndb;
|
|
create table t6(id int not null primary key, dat blob, txt text) engine=ndb;
|
|
load data local infile 'suite/ndb/data/table_data10000.dat' into table t1 fields terminated by ' ' lines terminated by '\n' (id, @data) set data = @data, id2 = repeat(@data,10);
|
|
load data local infile 'suite/ndb/data/table_data10000.dat' into table t2 fields terminated by ' ' lines terminated by '\n';
|
|
load data local infile 'suite/ndb/data/table_data10000.dat' into table t5 fields terminated by ' ' lines terminated by '\n';
|
|
load data local infile 'suite/ndb/data/table_data10000.dat' into table t6 fields terminated by ' ' lines terminated by '\n' (id, @data) set dat = repeat(@data, 100), txt = repeat(@data,100);
|
|
"Table t1 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 8
|
|
"Table t2 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 8
|
|
"Table t5 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 8
|
|
"Table t6 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 8
|
|
"Table t6 blob dat Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 8
|
|
"Table t6 blob txt Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 8
|
|
Nodegroup 1 created
|
|
ndbd(s)
|
|
id=1 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 0, *)
|
|
id=2 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 0)
|
|
id=3 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 1)
|
|
id=4 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 1)
|
|
ndb_mgmd(s)
|
|
id=5 @127.0.0.1 (MYSQL_VERSION NDB_VERSION)
|
|
mysqld(s)
|
|
id=16 @127.0.0.1 (MYSQL_VERSION NDB_VERSION)
|
|
Drop Node Group 1 done
|
|
Nodegroup 1 created
|
|
set @@new = 1;
|
|
create table t7(id int primary key, uk int) engine=ndb
|
|
partition by list(id) (
|
|
partition p0 values in (0),
|
|
partition p1 values in (1),
|
|
partition p2 values in (2),
|
|
partition p3 values in (3),
|
|
partition p4 values in (4)
|
|
);
|
|
drop table t7;
|
|
create table t3(id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb;
|
|
create table t4(id int NOT NULL PRIMARY KEY, data char(8))
|
|
TABLESPACE ts_1 STORAGE DISK engine=ndb;
|
|
insert into t3(id, data) VALUES
|
|
(1,'new'), (2,'new'),(3,'new'),(4,'new'),(5,'new'),
|
|
(6,'new'),(7,'new'),(8,'new'),(9,'new'),(10,'new');
|
|
insert into t4(id, data) VALUES
|
|
(1,'new'), (2,'new'),(3,'new'),(4,'new'),(5,'new'),
|
|
(6,'new'),(7,'new'),(8,'new'),(9,'new'),(10,'new');
|
|
alter table t1 algorithm=inplace, add column c int unsigned default null;
|
|
Warnings:
|
|
Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable online ADD COLUMN
|
|
alter table t1 reorganize partition;
|
|
alter table t2 reorganize partition;
|
|
alter table t5 algorithm=inplace, max_rows=300000000;
|
|
alter table t6 reorganize partition;
|
|
"Table t1 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 16
|
|
"Table t2 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 16
|
|
"Table t3 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 16
|
|
"Table t4 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 16
|
|
"Table t5 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 16
|
|
select count(0) as row_count from t6;
|
|
row_count
|
|
10000
|
|
"Table t6 Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 16
|
|
"Table t6 blob dat Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 16
|
|
"Table t6 blob txt Partition info"
|
|
TABLE_INFO
|
|
PartitionCount: 16
|
|
Table: test.t6
|
|
HashMap: DEFAULT-HASHMAP-3840-16
|
|
|
|
HashMap: DEFAULT-HASHMAP-3840-16
|
|
|
|
HashMap: DEFAULT-HASHMAP-3840-16
|
|
* 1006: Illegal reply from server
|
|
* error: -2
|
|
ndbd(s)
|
|
id=1 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 0, *)
|
|
id=2 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 0)
|
|
id=3 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 1)
|
|
id=4 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 1)
|
|
ndb_mgmd(s)
|
|
id=5 @127.0.0.1 (MYSQL_VERSION NDB_VERSION)
|
|
mysqld(s)
|
|
id=16 @127.0.0.1 (MYSQL_VERSION NDB_VERSION)
|
|
drop table t1,t2,t3,t4,t5,t6;
|
|
Drop Node Group 1 done
|
|
ndbd(s)
|
|
id=1 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 0, *)
|
|
id=2 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, Nodegroup: 0)
|
|
id=3 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, no nodegroup)
|
|
id=4 @127.0.0.1 (MYSQL_VERSION NDB_VERSION, no nodegroup)
|
|
ndb_mgmd(s)
|
|
id=5 @127.0.0.1 (MYSQL_VERSION NDB_VERSION)
|
|
mysqld(s)
|
|
id=16 @127.0.0.1 (MYSQL_VERSION NDB_VERSION)
|
|
ALTER TABLESPACE ts_1 DROP DATAFILE 'data_1.dat';
|
|
DROP TABLESPACE ts_1;
|
|
DROP LOGFILE GROUP lg_1 ENGINE NDB;
|