I'm trying to run llconfig -i to import the confguration file into XCAT so I can test the LLAPI related functions for DB access on a small standalone box. Unfortunately I'm receiving the following error message :
[root@shivling loadl]# llconfig -i LoadLeveler tables are being created in the xcatdb database. Initializing configuration data in the LoadLeveler tables from the following file or files: /home/loadl/LoadL_config Continue? (y/n): y 12/13 13:44:17 [MySQL][ODBC 3.51 Driver][mysqld-5.0.45]Cannot add or update a child row: a foreign key constraint fails (`xcatdb/TLL_CFGCluster`, CONSTRAINT `TLL_CFGCluster_ibfk_1` FOREIGN KEY (`clusterID`) REFERENCES `TLL_Cluster` (`clusterID`) ON DELETE CASCADE) (SQL State=HYT00, Native Error Code=1452) 12/13 13:44:17 llconfig: 2544-005 Inserting data into table TLL_CFGCluster was not successful. SQL STATUS=-1. llconfig: A database operation was not successful. llconfig: The database was not initialized.
Software levels --------------- RHEL5.3 (x86_64) LoadL-22.214.171.124 (x86_64) mysql-server-5.0.45-7.el5 mysql-5.0.45-7.el5 mysql-devel-5.0.45-7.el5 perl-DBD-MySQL-3.0007-2.el5 mysql-connector-odbc-3.51.12-2.2 xCAT-server-2.5.1-snap201012090302
Have tested basic access via isql -v xcatdb as root and loadl user and all is ok, guess I've done something wrong here but I don't see what I've missed at the moment.
Any suggestions gratefully received.