[rt-users] fcgi read timeout error in 4.2.5

[Alex Vandiver]

On 07/29/2014 11:14 AM, Shawn Plummer wrote:
> Doing some more research I see that RT using Oracle used to use File
> Sesssions and switched in 4.2 to using Oracle. Then a change was made to
> make sessions default to the MaxAttachment size which, from reading
> DBD::Oracle documentation, could trigger FOR UPDATE being used causing
> the locking issue.
> 
> I guess the answer for me is to just use Apache Sesssion Files. 
> 
> I would be happy to test any solutions for using Oracle for sessions on
> my devel instance but don’t want to hold up my upgrade any longer. 
> 
> The two commits in question
> https://github.com/bestpractical/rt/commit/36be526fecd2efb82762bb64978e39381d4a7622
> https://github.com/bestpractical/rt/commit/fd66493495acde6a321fd3e560a01002284a198b
> 
> I did confirm this bug occurs against a 10g and 11g Oracle database
> using 4.2

What steps do you use to reproduce the error?  If we can trigger it
locally (we test against 10g), we can more easily fix the error.
 - Alex