Ian Crakanthorp wrote: > > Hi, > > > > I have successfully installed 6.0.5 on Scientific Linux, pre 5.5, cant > > remember if it was 5.4 or 5.3. I was tweaking it, to get the image > > better for our envirnoment, so less fixing up needed to be done after > > imaging. > > > > The problem is I got the database rather messy with images that no > > longer existed etc etc. So decided to reinstall a clean system. How > > ever when running oscar_config --bootstrap it fails creating the > > database with the messages: > > > > Starting MySQL: [ OK ] > > > > Successfully initialized ODA > > > > Database Initialization... > > Restarting the database service... > > starting service mysqld... starting service mysqld... mysqld (pid 9766) > > is running... > > Stopping MySQL: [ OK ] > > Starting MySQL: [ OK ] > > Database_status: 1 > > Modifying the global oscar information record > > DB_DEBUG>/usr/bin/set_global_oscar_values: > > ====> in Database::update_table SQL: UPDATE Clusters SET > > server_distribution='rhel', headnode_interface='eth0', > > installation_date=NOW(), server_architecture='x86_64', > > oscar_version='6.0.5', server_distribution_version='5' > > DBD::mysql::db do failed: Cannot add or update a child row: a foreign > > key constraint fails (`oscar/Nodes`, CONSTRAINT `Nodes_ibfk_2` FOREIGN > > KEY (`group_name`) REFERENCES `Groups` (`name`) ON DELETE CASCADE ON > > UPDATE CASCADE) at /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/oda.pm line > > 713. > > DB_DEBUG>/usr/bin/create_and_populate_basic_node_info: > > ====> in Database::do_insert SQL : INSERT INTO Nodes (cluster_id, > > hostname, name, group_name) SELECT 1, 'oscar_server', 'oscar_server', > > 'oscar_server' > > Error message: Failed to insert values into Nodes table in database > > <oscar>: Cannot add or update a child row: a foreign key constraint > > fails (`oscar/Nodes`, CONSTRAINT `Nodes_ibfk_2` FOREIGN KEY > > (`group_name`) REFERENCES `Groups` (`name`) ON DELETE CASCADE ON UPDATE > > CASCADE) at /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/oda.pm line 719. > > /usr/bin/create_and_populate_basic_node_info: SQL command that failed > > was:<INSERT INTO Nodes (cluster_id, hostname, name, group_name) SELECT > > 1, 'oscar_server', 'oscar_server', 'oscar_server'> > > at /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/oda.pm line 719. > > DB_DEBUG>/usr/bin/create_and_populate_basic_node_info: > > ====>Failed to insert values via<< INSERT INTO Nodes (cluster_id, > > hostname, name, group_name) SELECT 1, 'oscar_server', 'oscar_server', > > 'oscar_server'>> at /usr/bin/create_and_populate_basic_node_info line > > 80 > > ERROR: Impossible to set headnode information in the database > > at /usr/bin/create_and_populate_basic_node_info line 84. > > Checking for database existence of node oscar_server ... > > ERROR: Impossible to > > execute /usr/bin/create_and_populate_basic_node_info > > at /usr/bin/oscar-config line 99 > > ERROR: Impossible to install the server side of OSCAR > > at /usr/bin/oscar-config line 99 > > ERROR: Impossible to complete stage 2 of the bootstrap. > > at /usr/bin/oscar-config line 99 > > ERROR: Impossible to bootstrap OSCAR at /usr/bin/oscar-config line 100 > > main::bootstrap() called at /usr/bin/oscar-config line 331 > > ERROR: Impossible to bootstrap OSCAR at /usr/bin/oscar-config line 332. > > > > > > Anyone seen this and know how to fix? > > > Patrick Nolan Wrote: > >This looks somewhat familiar. I think the layout of the oscar database >tables can change from version to version. It might be best to give the >mysql command "drop database oscar" so it can make a clean start.
I had tried that to no avail. Trying to go back to SL 5.3, also no luck. The fix was to just use the unstable version. The database created fine, I could have gone back to stable 6.0.5 at this point but decided not to. I have created an image successfully, but only with Scientific Linux (SL) 5.4 SL 5.5 seems to have some repo issues, and I think that is a SL 5.5 problem not oscar. Ian... -- Senior Systems Specialist Australian Nuclear Science& Technology Organisation Locked Bag 2001 Kirrawee DC NSW 2232 Phone: +61 2 97173365 Email: ian.crakanth...@ansto.gov.au Important: This transmission is intended only for the use of the addressee. It is confidential and may contain privileged information or copyright material. If you are not the intended recipient, any use or further disclosure of this communication is strictly forbidden. If you have received this transmission in error, please notify me immediately by telephone and delete all copies of this transmission as well as any attachments ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Oscar-users mailing list Oscar-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oscar-users
