ERROR: Error 1114: The table 'ozdmdl_block_xp_config' is full
I am using MySQL Workbench and took 343 tables with reverse engineer.
And then I am trying to forward tables to the mysql cluster server.
After copying all script to the word, changing innoDB engine to ndbcluster, and pasting it back to the workbench.
Everything is OK until this step.
Workbench starting to create tables, after a while it is giving me an error like bottom.
Executing SQL script in server
ERROR: Error 1114: The table 'ozdmdl_block_xp_config' is full
SQL Code:
-- -----------------------------------------------------
-- Table `ozd`.`ozdmdl_block_xp_config`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `ozd`.`ozdmdl_block_xp_config` (
`id` BIGINT(10) NOT NULL AUTO_INCREMENT,
`courseid` BIGINT(10) NOT NULL,
`enabled` TINYINT(1) NOT NULL DEFAULT '0',
`enablelog` TINYINT(1) NOT NULL,
`keeplogs` BIGINT(10) NOT NULL,
`levels` BIGINT(10) NOT NULL,
`lastlogpurge` BIGINT(10) NOT NULL DEFAULT '0',
`enableladder` TINYINT(1) NOT NULL DEFAULT '1',
`enableinfos` TINYINT(1) NOT NULL DEFAULT '1',
`levelsdata` LONGTEXT NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `ozdmdl_blocxpconf_cou_uix` (`courseid` ASC))
ENGINE = Ndbcluster
DEFAULT CHARACTER SET = utf8
COMMENT = 'Settings'
SQL script execution finished: statements: 54 succeeded, 1 failed
I have no idea about this error, the memory is all free. Workbench is converting about 48-49 tables to ndbcluster after this count it can't. If i delete one table I can create this "ozdmdl_block_xp_config" table too.
At the same database I can create tables with engine ndbcluster but with this codes I can not.
I got stucked. It is looks like there is a limit or someting like that, but there is no limits, because I can add basic ndbcluster tables to the same database.
Coluld you please help me.
The database is moodle database.