[rt-users] RT 4.2.11 Browser Reload Blocking session in Oracle

[Jeremy Gude]

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: jeremy at umbc.edu
MOBILE: 443.904.5970
PHONE: 410.455.8660
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20150529/2a9b5381/attachment.htm>