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
on Linux as well.




Jeremy Gude
Database / Peoplesoft Administrator
UMBC Division of Information Technology
Business Systems Group
MOBILE: 443.904.5970
PHONE: 410.455.8660

Reply via email to