xmlui BitstreamReader holds database connections open while large files download, exhausting connection pool ------------------------------------------------------------------------------------------------------------
Key: DS-677 URL: http://jira.dspace.org/jira/browse/DS-677 Project: DSpace 1.x Issue Type: Bug Components: XMLUI Affects Versions: 1.6.2, 1.6.1, 1.6.0, 1.5.2, 1.5.1, 1.5.0 Reporter: Keith Gilbertson Attachments: bitstreamreader_closedb.patch.txt The BitstreamReader in the xmlui needs a database connection to locate Bitstreams in the assetstore before sending them back to the client's browser. The database connection seems to be held open until the file is sent completely. This can cause problems on systems with many users, especially where the bitstreams are very large, as with video files. Users will see an error when the application is unable to successfully get a connection from the database pool. A patch is attached that forces the database connection closed by calling context.complete() early. Fix has worked very successfully in 1.5.x under heavy usage. It has only been tested lightly in DSpace 1.6.x. I'd like to commit this for a fix in 1.7, but am unsure: - Does this patch violate some part of the DSpace architecture by closing the db connection in the wrong place? - Could JSPUI have a similar problem? Is anyone aware of a technique for automatically finding this sort of issue? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.dspace.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Dspace-devel mailing list Dspace-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-devel