Description:
I was trying to create the following table:
CREATE TABLE mysqltest.t1 (c1 INT, c2 DOUBLE, c3 FLOAT, c4 TIMESTAMP, c5 TEXT, c6
LONGBLOB, c7 CHAR, c8 MEDIUMINT AUTO_INCREMENT, c9 BIT(8), c10 DECIMAL(10,2), c11
char(10), c12 VARCHAR(150), PRIMARY KEY (c8)) TABLESPACE ts1 STORAGE DISK ENGINE=NDB;
But I kept getting ERROR 1005 (HY000): Can't create table 'mysqltest.t1' (errno: 155)
Yet, if I try just a regular cluster
mysql> CREATE TABLE mysqltest.t1 (c1 INT, c2 DOUBLE, c3 FLOAT, c4 TIMESTAMP, c5 TEXT, c6
LONGBLOB, c7 CHAR, c8 MEDIUMINT AUTO_INCREMENT, c9 BIT(8), c10 DECIMAL(10,2), c11
char(10), c12 VARCHAR(150), PRIMARY KEY (c8)) ENGINE=NDB;
Query OK, 0 rows affected (1.31 sec)
How to repeat:
SMALLER TESTCASES:
mysql> DROP DATABASE IF EXISTS mysqltest;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> CREATE DATABASE mysqltest;
Query OK, 1 row affected (0.00 sec)
mysql> CREATE LOGFILE GROUP lg1
-> ADD UNDOFILE 'undofile.dat'
-> INITIAL_SIZE 3M
-> UNDO_BUFFER_SIZE = 1M
-> ENGINE=NDB;
Query OK, 0 rows affected (0.83 sec)
mysql> CREATE TABLESPACE ts1
-> ADD DATAFILE 'datafile.dat'
-> USE LOGFILE GROUP lg1
-> INITIAL_SIZE 3M
-> ENGINE NDB;
Query OK, 0 rows affected (0.72 sec)
mysql> CREATE TABLE mysqltest.t1 (c1 INT, c5 TEXT, PRIMARY KEY (c1)) TABLESPACE ts1
STORAGE DISK ENGINE=NDB;
ERROR 1005 (HY000): Can't create table 'mysqltest.t1' (errno: 155)
mysql> CREATE TABLE mysqltest.t1 (c1 INT, c6 LONGBLOB, PRIMARY KEY (c1)) TABLESPACE ts1
STORAGE DISK ENGINE=NDB; ERROR 1005 (HY000): Can't create table 'mysqltest.t1' (errno:
155)
Description: I was trying to create the following table: CREATE TABLE mysqltest.t1 (c1 INT, c2 DOUBLE, c3 FLOAT, c4 TIMESTAMP, c5 TEXT, c6 LONGBLOB, c7 CHAR, c8 MEDIUMINT AUTO_INCREMENT, c9 BIT(8), c10 DECIMAL(10,2), c11 char(10), c12 VARCHAR(150), PRIMARY KEY (c8)) TABLESPACE ts1 STORAGE DISK ENGINE=NDB; But I kept getting ERROR 1005 (HY000): Can't create table 'mysqltest.t1' (errno: 155) Yet, if I try just a regular cluster mysql> CREATE TABLE mysqltest.t1 (c1 INT, c2 DOUBLE, c3 FLOAT, c4 TIMESTAMP, c5 TEXT, c6 LONGBLOB, c7 CHAR, c8 MEDIUMINT AUTO_INCREMENT, c9 BIT(8), c10 DECIMAL(10,2), c11 char(10), c12 VARCHAR(150), PRIMARY KEY (c8)) ENGINE=NDB; Query OK, 0 rows affected (1.31 sec) How to repeat: SMALLER TESTCASES: mysql> DROP DATABASE IF EXISTS mysqltest; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> CREATE DATABASE mysqltest; Query OK, 1 row affected (0.00 sec) mysql> CREATE LOGFILE GROUP lg1 -> ADD UNDOFILE 'undofile.dat' -> INITIAL_SIZE 3M -> UNDO_BUFFER_SIZE = 1M -> ENGINE=NDB; Query OK, 0 rows affected (0.83 sec) mysql> CREATE TABLESPACE ts1 -> ADD DATAFILE 'datafile.dat' -> USE LOGFILE GROUP lg1 -> INITIAL_SIZE 3M -> ENGINE NDB; Query OK, 0 rows affected (0.72 sec) mysql> CREATE TABLE mysqltest.t1 (c1 INT, c5 TEXT, PRIMARY KEY (c1)) TABLESPACE ts1 STORAGE DISK ENGINE=NDB; ERROR 1005 (HY000): Can't create table 'mysqltest.t1' (errno: 155) mysql> CREATE TABLE mysqltest.t1 (c1 INT, c6 LONGBLOB, PRIMARY KEY (c1)) TABLESPACE ts1 STORAGE DISK ENGINE=NDB; ERROR 1005 (HY000): Can't create table 'mysqltest.t1' (errno: 155)