After upgrading to 4.2.11 we are experiencing a blocking lock in Oracle
after successfully logging into RT. When trying to reload from the browser
it seems the intial “select for update” is not allowing a subsequent update
to the session table.
SELECT a_session FROM sessions WHERE id = :p1 FOR UPDATE
UPDATE sessions SET a_session = :p1 WHERE id = :p2
Any ideas what could be causing this behavior?
The webserver is Apache on Linux and the database server is Oracle 184.108.40.206
on Linux as well.
Database / Peoplesoft Administrator
UMBC Division of Information Technology
Business Systems Group