Hi Rafael. We used to have that kind of errors and in pur case were cause for an error in the code of the University of Minho Stats add-on that we had installed previously. The problem dissapeared when we completely removed that add-on... Maybe this post can help you...
http://wiki.dspace.org/confluence/display/DSPACE/Idle+In+Transaction+Problem Regards. On Thu, Apr 22, 2010 at 3:47 PM, Rafael Henkin <rafa...@cpd.ufrgs.br> wrote: > Hi, > > > > We’re having some problems trying to find the cause of a weird error in a > Dspace 1.5.2 instance. We modified it a lot, but it has been under > development for months with no problems, until we started to see “Time out > waiting for idle object” and other errors. There wasn’t any major code > change when it started to occur, but we tried to disable the aspect that was > modified that day and the errors still happened. While looking for the > cause, I tried changing the number of connections and the maximum number of > idle connections, but I didn’t touch the preparedstatements. After a few > days looking for a solution, I decided to try changing it, it wasn’t working > fine anyway. And when I set it to false, the error disappeared. > > > > Today I noticed that our JDBC driver didn’t match our Postgres version (we > use 8.3), so I updated it and tried setting the PS on again, but the error > quickly appeared once again (DSpace becomes unusable after a few minutes). > > > > Apparently, prepared statements are meant to improve performance and aren’t > really necessary, but I don’t think they should cause any problems too, so > I’m just wondering what could be the issue here. > > > > We upgraded Postgres and a few other softwares when we were preparing to > migrate and looking for solutions for this problem, but IIRC Postgres (it’s > still 8.3) wasn’t one of them. > > > > Even if our DSpace seems to be running fine without prepared statements, I > just wanted to know if anyone had similar issues and what might be the > possible cause. > > > Thanks, > > > > Rafael Henkin > > > ------------------------------------------------------------------------------ > > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > >
------------------------------------------------------------------------------
_______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech