[Spacewalk-list] Oracle bites again (ORA-02291)

[Jan Hutař]

On Thu, 02 Aug 2012 11:53:19 +0200 Mario Mikocevic
<mario.mikocevic at t-com.hr> wrote:

> Oh well,
> 
> I had more than a whole year of flawless spacewalk execution
> 'til this morning, and oracle bites again ->
> 
> 2012-08-02 09:23:00,514 [RHN Message Dispatcher] ERROR
> com.redhat.rhn.common.db.datasource.CachedStatement - Error
> while processing cached statement sql: INSERT INTO
> rhnSsmOperationServer (operation_id, server_id) ( SELECT
> DISTINCT ?, s.element FROM rhnSet s WHERE label = ?
>                 AND user_id = ?
>                 AND s.element NOT IN
>                     (
>                     SELECT sos.server_id
>                       FROM rhnSsmOperationServer sos
>                      WHERE sos.operation_id = ?
>                        AND sos.server_id = s.element
>                     )
>              )
> com.redhat.rhn.common.db.WrappedSQLException: ORA-02291:
> integrity constraint (SPACEWALK.RHN_SSMOPS_SER_FK) violated -
> parent key not found
> 
> This e-mail is basicaly FYI type, I'll contact my DB admin
> where're we at with oracle support wrt this problem.
> 
> 
> Spacewalk 1.6 on CentOS 5.8
> Oracle 11.2.0.2

IIRC Spacewalk do not officially support 11g, so it might be
interesting if you can get some additional info and possibly
reproducer.

Regards,
Jan



-- 
Jan Hutar     Systems Management QA
jhutar at redhat.com     Red Hat, Inc.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120802/697a50f2/attachment.sig>