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

[Eugene]

In the message https://www.redhat.com/archives/spacewalk-list/2012-March/msg00014.html I clearly said that 11.2.0.2 and newer are not working. Downgrade to 11.2.0.1 and you won't see any errors.

Jan keeps saying that "We were never able to reproduce those internally" for several months. I have an impression that all attempts to reproduce were done on 11.2.0.1. It took me no time to reproduce on anything newer then 11.2.0.1. Fresh install failed every single time on several different systems. Please see archives mentioned.

Eugene.

02.08.2012, 04:53, "Mario Mikocevic" <mario.mikocevic at t-com.hr>:
> 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
>