Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Suggested Answer
  • Replies replies
    3
  • Answers answer
    1
  • Subscribers subscribers
    203
  • Views views
    153
  • Users 0 members are here
Related
Options

[OBM classic] Deadlock during event archival

Shrikant Talawar

Hi,

Has one came across below error during event archival in OBM?

please suggest. Thanks

ERROR: The database system reported an error: could not execute query -- An error occurred during the current command (Done status 0). Transaction (Process ID 165) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Parents

  • Suggested Answer

    0  

    Hello Shrikant,

    With concurrency, there is always the potential of lock conflicts and deadlocks.
    Event archival tries to delete event(s), while other parts of OBM may try to update the same event(s).

    There is not much you can do other than what the error already suggests: Rerun the transaction.

    I'm not sure if event archival does a retry or not. If it continues without erroring out, it probably does a retry, or it simply skips events that caused an error.

    If it terminates due to the deadlock, then just run the archival again.

    Best regards,
    Tobias

Reply

  • Suggested Answer

    0  

    Hello Shrikant,

    With concurrency, there is always the potential of lock conflicts and deadlocks.
    Event archival tries to delete event(s), while other parts of OBM may try to update the same event(s).

    There is not much you can do other than what the error already suggests: Rerun the transaction.

    I'm not sure if event archival does a retry or not. If it continues without erroring out, it probably does a retry, or it simply skips events that caused an error.

    If it terminates due to the deadlock, then just run the archival again.

    Best regards,
    Tobias

Children

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.