RAC Deadlock Detection not working on 10.2.0.4 / Linux Itanium

By | May 12th, 2009 | Category: 10g, Bugs, Linux Itanium, Oracle Database | 4 comments

We recently experienced a big issue, when the production database was hung. It turned out that the database has deadlocked, but the GES did not detect the deadlock situation, so all the sessions were waiting on “enq: TX row lock contention”.

We could provide a reproducible testcase and it turned out to be bug 7014855. The bug is platform specific to Linux Itanium port and a patch is available.

4 comments
Leave a comment »

  1. Leandro June 11th, 2009 18:47 :

    Hi, we have the same issue, and we apply the patch. After that the deadlock was detected but the session can not dead because is waiting for “log file sequential read”
    Do you have an issue like this after apply the backport?

    Regards,
    Diego

  2. admin June 13th, 2009 18:33 :

    Diego,

    thank you for your contribution. We did not have any issues with deadlock detection after implementing this patch. Now, patches are correctly detected and resolved by GES.

    Regards,
    Martin

  3. steve davidson March 31st, 2010 21:51 :

    Wondering whether this patch might be available for other ports? ANy idea?

  4. admin April 2nd, 2010 09:59 :

    Hello Steve,

    i don´t think that this bug exists on other platforms. However, if you are experiencing this issue on other platforms, don´t hesitate to contact Oracle support and refer them to this bug and ask for clarification.

    Best Regards,
    Martin

Leave Comment