Re: Can't create table - Tatiana Peña - com.mysql.lists.cluster

11 messages in com.mysql.lists.clusterRe: Can't create table

From	Sent On	Attachments
Tatiana Peña	21 Sep 2004 09:53
Mikael Ronström	21 Sep 2004 13:46
Tatiana Peña	22 Sep 2004 20:34
Tomas Ulin	23 Sep 2004 02:44
Tatiana Peña	23 Sep 2004 07:16
Tomas Ulin	23 Sep 2004 11:52
Tatiana Peña	25 Sep 2004 17:15
Magnus Svensson	26 Sep 2004 01:15
Tatiana Peña	27 Sep 2004 17:08
Tatiana Peña	27 Sep 2004 17:12
Magnus Svensson	28 Sep 2004 00:19

Subject:	Re: Can't create table
From:	Tatiana Peña (tayo...@hotpop.com)
Date:	09/25/2004 05:15:51 PM
List:	com.mysql.lists.cluster

Hi!

I changed my config.ini and when I set MaxNoOfConcurrentOperations= 10000 TimeBetweenWatchDogCheck= 30000

I got the same error creating the 21th table: $ create_sept.sh user passwd ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040921.frm'
(errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040922.frm'
(errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040923.frm'
(errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040924.frm'
(errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040925.frm'
(errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040926.frm'
(errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040927.frm'
(errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040928.frm'
(errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040929.frm'
(errno: 709) ERROR 1005 (HY000) at line 1: Can't create table './cdr/tbl_20040930.frm'
(errno: 709) $

But when I put the setting Diskless= 1

it works perfectly! and I could insert more than 150000 rows on one of the
tables created.

Can you please try the script without this parameter? I need my tables to be
permanent.

Also, following your instructions I tried to run ndb_show_tables on the MGM but I got another error:

#ndb_show_tables Configuration error: Could not alloc node id: No free node id found for
mysqld(API). waitUntilReady - 4269: No connection to ndb management server

NDBT_ProgramExit: 1 - Failed

What I'm doing wrong??

Thanks for your help!!

I tested this successfully:

mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | t1 | | t2 | | t3 | | tbl_20040901 | | tbl_20040902 | | tbl_20040903 | | tbl_20040904 | | tbl_20040905 | | tbl_20040906 | | tbl_20040907 | | tbl_20040908 | | tbl_20040909 | | tbl_20040910 | | tbl_20040911 | | tbl_20040912 | | tbl_20040913 | | tbl_20040914 | | tbl_20040915 | | tbl_20040916 | | tbl_20040917 | | tbl_20040918 | | tbl_20040919 | | tbl_20040920 | | tbl_20040921 | | tbl_20040922 | | tbl_20040923 | | tbl_20040924 | | tbl_20040925 | | tbl_20040926 | | tbl_20040927 | | tbl_20040928 | | tbl_20040929 | | tbl_20040930 | | transport | +----------------+ 34 rows in set (0.00 sec)

my config file:

[ndbd default] NoOfReplicas= 2 MaxNoOfConcurrentOperations= 10000 DataMemory= 40M IndexMemory= 12M Diskless= 1 TimeBetweenWatchDogCheck= 30000 DataDir= /home/tomas/mysql/mysql-test/ndbcluster-2200

[ndbd] HostName= localhost

[ndb_mgmd] DataDir= /home/tomas/mysql/mysql-test/ndbcluster-2200 PortNumber= 2200

[mysqld]

[tcp default] PortNumber= 2202

Please run:

ndb_show_tables to see what tables are present in the cluster... and verify that these are the same as you see through the mysql client

this is what it looks like for me:

bash-2.05b$ ndb_show_tables id type state logging database schema name 0 SystemTable Online Yes sys def SYSTAB_0 2 SystemTable Online Yes sys def NDB$EVENTS_0 4 UserTable Online Yes test def tbl_20040901 6 UserTable Online Yes test def tbl_20040902 8 UserTable Online Yes test def tbl_20040903 10 UserTable Online Yes test def tbl_20040904 12 UserTable Online Yes test def tbl_20040905 14 UserTable Online Yes test def tbl_20040906 16 UserTable Online Yes test def tbl_20040907 18 UserTable Online Yes test def tbl_20040908 20 UserTable Online Yes test def tbl_20040909 22 UserTable Online Yes test def tbl_20040910 24 UserTable Online Yes test def tbl_20040911 26 UserTable Online Yes test def tbl_20040912 28 UserTable Online Yes test def tbl_20040913 30 UserTable Online Yes test def tbl_20040914 32 UserTable Online Yes test def tbl_20040915 34 UserTable Online Yes test def tbl_20040916 36 UserTable Online Yes test def tbl_20040917 38 UserTable Online Yes test def tbl_20040918 40 UserTable Online Yes test def tbl_20040919 42 UserTable Online Yes test def tbl_20040920 44 UserTable Online Yes test def tbl_20040921 46 UserTable Online Yes test def tbl_20040922 48 UserTable Online Yes test def tbl_20040923 50 UserTable Online Yes test def tbl_20040924 52 UserTable Online Yes test def tbl_20040925 54 UserTable Online Yes test def tbl_20040926 56 UserTable Online Yes test def tbl_20040927 58 UserTable Online Yes test def tbl_20040928 60 UserTable Online Yes test def tbl_20040929 62 UserTable Online Yes test def tbl_20040930

NDBT_ProgramExit: 0 - OK

Tatiana Peña wrote:

Hi!! This is the bash script than I'm using to create 30 tables, one for each day from September. The parameters it needs are the user and the password to the database

------ create_sept.sh----- #!/bin/bash # $1 is the user from the database # $2 is the password from the user function create() { mysql cdr -u$2 -p$3 -Ne " create table $1 ( recordType varchar(2), callTransactionType varchar(3), servedmsisdn varchar(15), servedIMEITAC varchar(6), servedIMEIFAC varchar(2), servedIMEISNR varchar(6), servedIMEISP varchar(2), servedMSRN varchar(15), startOfChargingdate date, timeStamp time, callDuration integer, otherpartylongnumberb varchar(20), dialledOtherPartyB varchar(20), thirdpartyb varchar(20), exchangeId varchar(15), tgrpNameIc varchar(10), cicIc varchar(6), tgrpNameOg varchar(10), cicOg varchar(6), sequenceNumber integer, CIDMCC varchar(3), CIDMNC varchar(3), CIDLAC varchar(3), cId varchar(5), inflag varchar(2), inservicekey varchar(2), intermediateSequenceNumber integer, drcCallId varchar(16), drcCallRN varchar(16) ) TYPE=NDB ; " } for i in `seq 1 30`; do if [ $i -lt 10 ]; then create tbl_2004090$i $1 $2 else create tbl_200409$i $1 $2 fi done -----END create_sept.sh----- -- Tatiana Peña <_tayotas@hotpop.com_ <mailto:tayo...@hotpop.com El jue, 23-09-2004 a las 04:44, Tomas Ulin escribió: /Tatiana, please send your script so we can test. Thanks, T Tatiana Peña wrote: Hi! Mysql 4.1.5-gamma is installed with the same config.ini file I've sent. Error 4336 seems not to appear anymore :) I also was trying to create 30 tables using a script but it creates some of them and for the others the system returns: mysql CREATE TABLE ctest13 (i INT) ENGINE=NDBCLUSTER; ERROR 1005 (HY000): Can't create table './cdr/ctest3.frm' (errno: 709) If I delete one table it is possible to create another tables (more than one), but eventually the same error occurs :S What could be the cause of the error? /

Tatiana,

please send your script so we can test.

Thanks,

Tatiana Peña wrote:

Hi!

Mysql 4.1.5-gamma is installed with the same config.ini file I've sent. Error 4336 seems not to appear anymore :)

I also was trying to create 30 tables using a script but it creates some of them and for the others the system returns:

mysql> CREATE TABLE ctest13 (i INT) ENGINE=NDBCLUSTER; ERROR 1005 (HY000): Can't create table './cdr/ctest3.frm' (errno: 709)

If I delete one table it is possible to create another tables (more than one), but eventually the same error occurs :S

What could be the cause of the error?