MySQL Bugs: #11201: can not create some table

Bug #11201	can not create some table
Submitted:	9 Jun 2005 12:19	Modified:	9 Jun 2005 17:12
Reporter:	Hugo Etievant	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S1 (Critical)
Version:	4.1.12	OS:	Linux (Linux Red Hat 9)
Assigned to:		CPU Architecture:	Any

Description:
in a Cluster of 1 MGM node + 1 SQL node + 2 Storage node
when i try to import data in a database width the "source" command of the mysql shell, i have always this error :
"ERROR 1005 (HY000): Can't create table './base1/table7.frm' (errno: 881)
ERROR 1146 (42S02): Table 'base1.table7' doesn't exist
Query OK, 0 rows affected (0.00 sec)"
with some tables described into my base1.sql file (file size: 11.7 MB)

MGMD is configured width :
DataMemory=80M
IndexMemory=52M

this error dos not appear with an other base created in my cluster

is it the quantity of my .sql file that create this problem ?

How to repeat:
the same sql file repeat always this same error

Can you supply the sql file or an example file that causes the issue?

i have added the file that create the specified errors
because confidentiality, only structure of table appairs

errors begins with CONTENUFORMULAIRE, COURS and DEFAULTSTRUCTUREKSUP
(after, i kill mysql shell process)

during import of .sql file, speed of inserts decrease gradually

since i delete all insert command of my ksup.sql file for import, in order to have only structure creation tale information, i have this new error :

mysql> source /tmp/ksup.sql
ERROR 1005 (HY000): Can't create table './ksup2/ACTUALITE.frm' (errno: 708)
Query OK, 0 rows affected (8.54 sec)
 
ERROR 1005 (HY000): Can't create table './ksup2/ALBUMGW.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/ANNUAIRE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/ANNUAIRE_ANCIENS_ETUDIANTS.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/ANNUAIRE_ETUDIANTS.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/ARTICLE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/ASSOCIATION_ETUDIANT.frm' (errno: 708)
Query OK, 0 rows affected (1.44 sec)
 
ERROR 1005 (HY000): Can't create table './ksup2/COMMENTAIRE.frm' (errno: 708)
Query OK, 0 rows affected (3.24 sec)
 
ERROR 1005 (HY000): Can't create table './ksup2/COURS.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/DEFAULTSTRUCTUREKSUP.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/DOCUMENT.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/DOCUMENTGW.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/DOSSIERGW.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/ENCADRE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/ESPACECOLLABORATIF.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/FICHIERGW.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/FIL.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/FORMATION.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/FORMULAIRE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/FORUMGW.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/GROUPEDSI.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/GROUPEUTILISATEUR.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/LABORATOIRE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/LIBELLE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/MAILING.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/METATAG.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/MODELEMAIL.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/MOT.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/NEWSGW.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/OFFRES_STAGES_EMPLOIS.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/PAGE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/PAGELIBRE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/PARAMETRESGENERAUX.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/PARCOURS.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/PHOTO.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/PRESENCEMOT.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/PROFILDSI.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/ROLE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/RUBRIQUE.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/UEUP.frm' (errno: 708)
ERROR 1005 (HY000): Can't create table './ksup2/UTILISATEUR.frm' (errno: 708)

(i have created an other test database bescause the first is unworkable because i can not drop table and first database : 

mysql> use ksup;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Didn't find any fields in table 'ACTUALITE'
Didn't find any fields in table 'AGENDAGW'
Didn't find any fields in table 'ALBUMGW'
Didn't find any fields in table 'ANNUAIRE'
Didn't find any fields in table 'ANNUAIRE_ANCIENS_ETUDIANTS'
Didn't find any fields in table 'ANNUAIRE_ETUDIANTS'
Didn't find any fields in table 'ARTICLE'
Didn't find any fields in table 'ASSOCIATION_ETUDIANT'
Didn't find any fields in table 'CHANGEMENTMOTPASSE'
Didn't find any fields in table 'COMMENTAIRE'
Database changed

[root@dhcprov227-45 tmp]# mysql -A
mysql> use ksup;
Database changed
mysql> show tables;
+----------------------------+
| Tables_in_ksup             |
+----------------------------+
| ACTUALITE                  |
| AGENDAGW                   |
| ALBUMGW                    |
| ANNUAIRE                   |
| ANNUAIRE_ANCIENS_ETUDIANTS |
| ANNUAIRE_ETUDIANTS         |
| ARTICLE                    |
| ASSOCIATION_ETUDIANT       |
| CHANGEMENTMOTPASSE         |
| COMMENTAIRE                |
+----------------------------+
10 rows in set, 1 warning (0.00 sec)
 
mysql> drop table ACTUALITE;
ERROR 6 (HY000): Error on delete of './ksup/ACTUALITE.ndb' (Errcode: 2)
mysql> drop database ksup;
ERROR 6 (HY000): Error on delete of './ksup/ACTUALITE.ndb' (Errcode: 2)
)

in order to resolve my problem, i use an other way :

i try to import directly structure from a simple dump without data from the simple no clustered original database

mysqldump mydatabase -d -p > mydatabase.sql

i import this .sql file into my cluster :

mysqldump mydatabase < mydatabase.sql

it is Ok, my tables are created (with MyISAM type)

but when i try to alter tables to specifie ENGINE=NDBCLUSTER, i have this error :

mysql> alter table ACTUALITE ENGINE=NDBCLUSTER;
ERROR 1005 (HY000): Can't create table './ksup3/#sql-1384_4.frm' (errno: 708)

./perror --ndb 881
OS error code 881:  Unable to create table, out of data pages (increase DataMemory) : Permanent error: Schema error

./perror --ndb 708
OS error code 708:  No more attribute metadata records (increase MaxNoOfAttributes): Permanent error: Schema error

use perror from the /bin directory with --ndb to retrieve the error.

Thanks,

The command "perror --ndb 881" returns the following error:
perror: unknown option '--ndb'

Linux RPM binaries are installed on this system:
MySQL-server-4.1.12-1
MySQL-devel-4.1.12-1
MySQL-ndb-extra-4.1.12-1
MySQL-ndb-storage-4.1.12-1
MySQL-client-4.1.12-1
MySQL-Max-4.1.12-1
MySQL-ndb-tools-4.1.12-1
MySQL-ndb-management-4.1.12-1

How can I get an NDB-aware version of perror?

Thank You,
Troy