MySQL Forums
Forum List  »  NDB clusters

ERROR: Error 1114: The table 'ozdmdl_block_xp_config' is full
Posted by: Şükrü ÖZDEMİR
Date: April 20, 2016 07:32AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR: Error 1114: The table 'ozdmdl_block_xp_config' is full
1825
April 20, 2016 07:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.