E-IB: Deadlocking in PSIBQUEUEINST
Last updated on SEPTEMBER 08, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.4 and later
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 201047197
***Checked for relevance on 08-SEP-2017***
When submitting messages on Tools 8.48 we are seeing Deadlocking in PSIBQUEUEINST.
During stress testing we found deadlocking in the PSIBQUEUEINST table like the following
17.24.48 11446.608369 SQL error. Stmt #: 337 Error Position: 0 Return: 60 - ORA-00060: deadlock detected while waiting for resource
17.24.48 0.000088 Sam SqlError: UPDATE PSIBQUEUEINST SET QUEUESEQID=QUEUESEQID+:1 WHERE QUEUENAME=:2
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms