Hi Richard,
There has not been any talk of a DSpace 1.8.2 release at any of the
recent developer meetings, so you might have to volunteer if you wanted
to get that one off the ground.
Cheers, Robin.
On 25/01/12 14:31, Richard Jones wrote:
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
<mailto: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
<mailto:sword-app-tech@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/sword-app-tech
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.
------------------------------------------------------------------------------
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
