Hi Ben, The error happened because the "Group_Packages" table tried to get populated with even not existing packages on the Packages table.
I think this should not happen but this can happen if very unlikely your database was not cleaned up after start_over or the Packages table could not be fully populated at some reason. We can not really see why it happened until we see your full verbose oscarinstall.log so if you have the right one, please post the log after compressing it. Regards, - DongInn Ben Lieblich wrote: > Is there an email at which I can contact him (DongInn)? Thanks for your > help. > > -Ben > > > On Wed, Jul 9, 2008 at 1:35 PM, Michael Edwards <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > I would probably start with a clean install of Suse at this point, > but if you want to try again, try doing it with > > env OSCAR_VERBOSE=3 ./install_cluster eth0 > > and see if you get any more helpful errors. DongInn might have more > to say about the actual SQL error, hes the database guru. > > On Tue, Jul 8, 2008 at 4:06 PM, Ben Lieblich <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> wrote: > > I am trying to install oscar on what is to be my head node for a > small cluster but I can not seem to get around the following error: > > Creating the OSCAR database ... > ... OSCAR database successfully created. > Checking for database existence of node oscar_server ... > Updating the hostname field in the oscar_server node to > <dls-seqlinux> ... > Updating the dns_domain field in the oscar_server node to > <rutgers.edu <http://rutgers.edu/>> > Checking for existence of node group oscar_clients ... > Checking for existence of node group all ... > Creating node group all ... > Checking for existence of node group Default_node ... > Creating node group Default_node ... > Checking for existence of package set <Default> > Initializing package set <Default> > DBD::mysql::db do failed: Cannot add or update a child row: a > foreign key constraint fails (`oscar/Group_Packages`, CONSTRAINT > `Group_Packages_ibfk_1` FOREIGN KEY (`package`) REFERENCES > `Packages` (`package`) ON DELETE CASCADE) at > /opt/oscar/lib/OSCAR/oda.pm <http://oda.pm/> line 733. > DB_DEBUG>./wizard_prep: > ====> in Database::do_update SQL : INSERT INTO Group_Packages > (group_name, package, selected)VALUES ('Default', 'apitest', '1') > Error message: Failed to update Group_Packages table in database > <oscar>: Cannot add or update a child row: a foreign key > constraint fails (`oscar/Group_Packages`, CONSTRAINT > `Group_Packages_ibfk_1` FOREIGN KEY (`package`) REFERENCES > `Packages` (`package`) ON DELETE CASCADE) at > /opt/oscar/lib/OSCAR/oda.pm <http://oda.pm/> line 739. > ./wizard_prep: SQL command that failed was: <INSERT INTO > Group_Packages (group_name, package, selected)VALUES ('Default', > 'apitest', '1')> at /opt/oscar/lib/OSCAR/oda.pm <http://oda.pm/> > line 739. > DB_DEBUG>./wizard_prep: > ====>Failed to insert values via << INSERT INTO Group_Packages > (group_name, package, selected)VALUES ('Default', 'apitest', > '1') >> at /opt/oscar/lib/OSCAR/Database > .pm line 1681. > Oscar Wizard preparation script failed to complete at > ./install_cluster line 275. > > > Everything up to here seems fine. I have used start_over and > have restarted the machine every which way and have been > troubleshooting the mysql error but I can not seem to get rid of > this error message. Can anyone help me please? Would be greatly > appreciated. Thanks. > > P.S. I am running openSUSE 10.3 with Oscar 5.0 and mysql: Ver > 14.12 Distrib 5.0.45, for suse-linux-gnu (i686). > > -Ben > > > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source > project, > along with a healthy diet, reduces your potential for chronic > lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > Oscar-users mailing list > [email protected] > <mailto:[email protected]> > https://lists.sourceforge.net/lists/listinfo/oscar-users > > > > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > Oscar-users mailing list > [email protected] > <mailto:[email protected]> > https://lists.sourceforge.net/lists/listinfo/oscar-users > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > > > ------------------------------------------------------------------------ > > _______________________________________________ > Oscar-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/oscar-users ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Oscar-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/oscar-users
