Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Primo

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Primo
    3. Knowledge Articles
    4. Pipe Failed with Error: deadlock detected while waiting for resource

    Pipe Failed with Error: deadlock detected while waiting for resource

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Primo
    • Product Version: 4

    Problem Symptoms:
    Our pipe has just failed with error:
    The pipe <PIPE NAME>, that started at <DATESTAMP> failed at <DATESTAMP> in stage 'nep' with status 'stopped error', while processing job 2012.06.27-17.30.00-175023390 The error message is:
    java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource

    Cause:


    Resolution:
    You can simply re-execute the Pipe and it should complete.

    This can occur because another process is running (deadlock in the DB).
    There is an open development issue regarding a problem in the Pipe queue mechanism: in M_P_WORK (pipe statuses) and R_T_PIPE_CONFIGURATION tables.

    If this problem continues, open an SI or MeToo this SKB article.
    Note that there should be more information in the $ORACLE_ALERT_LOG file, for example:
    ?’?‚¬?¿½ORA-00060: Deadlock detected. More info in file /exlibris/app/oracle/diag/rdbms/prm4/prm4/trace/prm4_ora_19334.trc.?’?‚¬?¿½

    Category: Publishing platform

    Subject: Harvesting


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Pipe fail with errors: Invalid content was found starting with element 'XXX'. One of '{YYY}' is expected
      • Pipe fails with java.sql.SQLException
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Content Type
      Knowledge Article
      Language
      English
      Product
      Primo
    2. Tags
      1. 4
      2. contype:kba
      3. Harvesting
      4. Prod:Primo
      5. Publishing Platform
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved