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

Thanks,

Jeremy

-- 

-- 
Jeremy Gude
Database / Peoplesoft Administrator
UMBC Division of Information Technology
Business Systems Group
EMAIL: jer...@umbc.edu
MOBILE: 443.904.5970
PHONE: 410.455.8660

Reply via email to