Hiya,
Yes, indeed. I encountered this problem some time back when trying the
crispy branch on RHEL 5. I am certain, it's not a distro-specific issue --
and it probably seems to have crept in due to the changes in the database.
Just dropping the current OSCAR database would do the trick for you or just
recreating the database using "start_over" would be the best.
I have not been able to reproduce the problem, but I think it happens when
a previous OSCAR installation fails unfinished which is what makes the
database lose it's integrity.
-- Abhishek
On Dec 3, 2007 12:24 PM, DongInn Kim <[EMAIL PROTECTED]> wrote:
> Hi Bernard,
>
> Can you please double check to see if the "Packages" table is fully
> populated?
> At some reasons, the "Packages" table was not fully populated and the
> "Group_Packages" tried to use the primary key of the "Packages" table whose
> records do not exist, I believe.
>
> If this is the case, I think you have to do "start_over" and you can start
> from the new database installation. I hope that this may resolve your
> problem but I am not completely sure until I reproduce this problem by
> myself. If you still get the same problem after start_over, can you please
> post the full oscarinstall.log?
>
> Regards,
>
> - DongInn
>
>
> Bernard Li wrote:
> > Got the following error message when trying to install crispy 5.1
> > branch on Fedora 8 x86:
> >
> > 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 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 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 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 279.
> >
> > Any ideas?
> >
> > Cheers,
> >
> > Bernard
> >
> >
> -------------------------------------------------------------------------
> > SF.Net email is sponsored by: The Future of Linux Business White Paper
> > from Novell. From the desktop to the data center, Linux is going
> > mainstream. Let it simplify your IT future.
> > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> > _______________________________________________
> > Oscar-devel mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/oscar-devel
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell. From the desktop to the data center, Linux is going
> mainstream. Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> Oscar-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/oscar-devel
>
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Oscar-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oscar-devel
