Martin --
Thanks. I think that is a good suggestion. Unfortunately, in this case it did
not change the outcome:
mysql> LOAD DATA INFILE 'nbn_lead_records.csv' INTO TABLE nbn_leads;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
I've also tried loading the mysqldump file as TYPE=MyISAM (which works) and
then changing the table type with ALTER TABLE nbn_leads ENGINE=NDB, same
result.
-- Jim
--- Martin Skold <Martin.Skold@stripped> wrote:
> Try bulk loading instead it is better
> optimized for cluster
> LOAD DATA INFILE <file name>;
>
> BR
> -- Martin
>
>
> Jim Hoadley wrote:
>
> >FYI I often get this same error when trying to load data. I'll restart the
> >transaction, I'll drop the table and reload. Same result. And nothing in any
> >error log. Seems like adjusting parameters in config.ini should fix, but so
> far
> >I've found no magic bullet.
> >
> >-- Jim
> >
> >
> >
> >
> >>We're giving Cluster a go on a lab database cluster with some sample
> >>datasets before allocating any real hardware to it. We have a dump from
> >>another mysql server that is about 250 MB in size, and trying to
> >>import it
> >>into our mysqld node in the cluster results in the following error
> >>after
> >>more than an hour of importing (using mysql < import.file):
> >>
> >>ERROR 1205 (HY000) at line 559: Lock wait timeout exceeded; try
> >>restarting
> >>transaction
> >>
> >>
> >>
> >
> >In some cases this error code could occur due to a node failure. Check
> >cluster log
> >if any strange things occurred.
> >
> >Rgrds Mikael
> >
> >
> >
> >>Our cluster config is 3 hosts: 2x servers with 1024MB RAM and
> >>2-PIII/850MHz and SCSI disks, one box 128MB RAM and 1-PIII/700MHz and
> >>IDE
> >>disk. The two servers with 1GB RAM are the NDB nodes, the other is the
> >>API
> >>and MGM node. Below is our config.ini for the cluster. Could this
> >>error be
> >>the result of low system resources on the SQL node, or are there
> >>settings
> >>that we should adjust in the config? And what would cause the import to
> >>take over an hour for a 250 MB database?
> >>
> >>[NDBD DEFAULT]
> >>NoOfReplicas=2
> >>DataMemory=640M
> >>IndexMemory=128M
> >>LogLevelStartup=1
> >>LogLevelShutdown=1
> >>LogLevelStatistic=1
> >>LogLevelCheckpoint=1
> >>LogLevelNodeRestart=1
> >>LogLevelConnection=1
> >>LogLevelError=1
> >>LogLevelInfo=1
> >>MaxNoOfConcurrentOperations=250000
> >>
> >>[TCP DEFAULT]
> >>
> >>[NDB_MGMD]
> >>hostname=abajo-dev-db-temp.sento.com
> >>datadir=/var/lib/mysql-cluster
> >>ArbitrationRank=1
> >>
> >>[NDBD]
> >>hostname=abajo-dev-db-1.sento.com
> >>datadir=/var/lib/mysql-cluster
> >>
> >>[NDBD]
> >>hostname=abajo-dev-db-2.sento.com
> >>datadir=/var/lib/mysql-cluster
> >>
> >>[MYSQLD]
> >>hostname=abajo-dev-db-temp.sento.com
> >>ArbitrationRank=0
> >>
> >>TIA
> >>
> >>DS
> >>
> >>--
> >>
> >>
> >
> >
> >
> >
> >__________________________________
> >Do you Yahoo!?
> >Yahoo! Small Business - Try our new resources site!
> >http://smallbusiness.yahoo.com/resources/
> >
> >
> >
>
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe: http://lists.mysql.com/cluster?unsub=1
>
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
