[Dspace-tech] Idle In Transaction Problem

2015-06-15 Thread Joseph Greene
Hi, This may have been fixed in more recent versions of DSpace; we're on 1.8.2. I'd been getting this problem a lot, to the point where our tomcat was shutting down about once a week. https://wiki.duraspace.org/display/DSPACE/Idle+In+Transaction+Problem I wrote a script to try and find what

Re: [Dspace-tech] idle in transaction

2014-10-13 Thread Mark H. Wood
On Fri, Oct 10, 2014 at 02:53:47PM -0600, James Holobetz wrote: We are running: Dspace version 3.2 on Suse Linux Enterprise Server 11 SP3 java 1.6.0_33 postgres 8.3.23 tomcat 6.0.18 (these versions are within the SLES upgrade cycle) That is a very old,

[Dspace-tech] idle in transaction

2014-10-10 Thread James Holobetz
Hello, We are experiencing an issue with dspace and postgresql where we have a number of 'idle in transaction' processes. We have stopped and started tomcat the handle server and postgresql with no luck. We have even rebooted the server only to have the same issue. We have also tried Corey

Re: [Dspace-tech] idle in transaction

2014-10-10 Thread James Holobetz
We are running: Dspace version 3.2 on Suse Linux Enterprise Server 11 SP3 java 1.6.0_33 postgres 8.3.23 tomcat 6.0.18 (these versions are within the SLES upgrade cycle) James Bram Luyten bluy...@gmail.com 10/10/2014 2:43 PM Hi James, What version of dspace are you running? Bram Sent

[Dspace-tech] idle in transaction workaround for Solaris

2009-12-08 Thread Damian Marinaccio
I created a Solaris version of Cory Snavely's workaround from: http://wiki.dspace.org/index.php/Idle_In_Transaction_Problem To see detailed process information: 1. you must have update_process_title = on in postgresql.conf 2. be the owner of the process or root Solaris platform specifics from