Hi Pavel,
I have seen a similar issue to this too. I think it's a database
connection leak somewhere in the code.
Stuart - what is our scope for updating the Sword implementation in DSpace,
is there a 1.8.2 release on the horizon? If so, I can look into a fix for
that.
Cheers,
Richard
On Sun, Jan 8, 2012 at 1:57 PM, Pavel Mika <ki...@seznam.cz> wrote:
> Hello,
>
> I am not sure if this problem is related to sword or dspace, but I have
> noticed there is some problem with database pooling or closing connections.
> While i was testing the sword ingesting and swordv2 partialmedia-content
> upload/replacement/delete, the server often returned
> Internal Server error 500.
>
> the tomcat log contained:
> org.dspace.sword2.DSpaceSwordException:
> org.postgresql.util.PSQLException: This statement has been closed.
>
> the strange was, that even simple operations started to fail on error 500,
> sometimes it returned response and with next action again error 500 and
> only restart of Tomcat helped.
>
> I have noticed its related to the database, so i have increased the max
> database connections from 30 to 100 and set max idle to 40, but still, when
> i was working with uploads, refresh a lot, it started to return Internal
> error 500 from Tomcat. So i have increased the max idle to 80. After Tomcat
> server restart I have started rapidly upload additional files to the
> package media files, and from one moment (about 8 files added + refresh of
> package) it started to occasionaly throw the error 500.
>
> I have checked the postgresql console and found probably like maximum
> allowed 80 dspace connections, active in the database (enclosed in the
> attachment) and almost all of them had status <IDLE> in transaction.
>
> My question is, if the DSpace requires so many active connections for each
> operation, or perhaps is there some problem with connection closing at end
> of command so less connections are available after each such operation?
> Temporarily I can increase the maximum number of connections to hundreds,
> but It can run into same problem with more concurrent users, if the
> connections are blocked.
>
>
> Best regards
> Pavel Mika
>
>
>
>
>
> ------------------------------------------------------------------------------
> Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
> infrastructure or vast IT resources to deliver seamless, secure access to
> virtual desktops. With this all-in-one solution, easily deploy virtual
> desktops for less than the cost of PCs and save 60% on VDI infrastructure
> costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
> _______________________________________________
> sword-app-tech mailing list
> sword-app-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sword-app-tech
>
>
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
sword-app-tech mailing list
sword-app-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sword-app-tech
