MySQL Forums
Forum List  »  NDB clusters

Error 1297 (HY000) Unknown Error Loading data
Posted by: ken kaufman
Date: January 24, 2007 07:49PM

We're trying to implement a mysql cluster and populate it with approximately 70 million rows. I've various techniques in loading from putting data into an myisam table and using a insert into select statement, to load data infile. Niether seem to work. After my first attempt which loaded 12 million rows, it now consistently craps out after a million or so. Error messages go back between Error 1296 'Unknown Error Code' and Redo log files overloaded. I've changed to diskless, and many other configs, with no luck. Below is my current config. Its running Debian with 8GB or Ram. I've done a full dump 1000 and I'm currently at 15% in index and 25% in data. Note outside of the DataMemory and IndexMemory, changes were made after errors started occuring.

[NDBD]
hostname=192.168.126.162
DataDir=/opt/mysql-cluster
MaxNoOfConcurrentOperations=2000000
DataMemory=5000MB
IndexMemory=1200MB
Diskless=1
RedoBuffer=32MB
UndoIndexBuffer=8MB
LockPagesInMainMemory=Y
TimeBetweenLocalCheckpoints=6

Options: ReplyQuote


Subject
Views
Written By
Posted
Error 1297 (HY000) Unknown Error Loading data
2566
January 24, 2007 07:49PM


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.