On Sep 30, 2010, at 6:36 PM, Pottinger, Hardy J. wrote: > > > 3. Back when we were running on DSpace 1.5.1, after a period of about 24-36 > hours of uptime, Tomcat became unavailable. Apache reported 503: service > unavailable. Looking at a dump after killing all Java processes, it appeared > that all database connections were unavailable. Changing the > db.maxconnections and db.maxidle settings (see above) was helpful, but we are > proactively rebooting tomcat and apache every night, to "clean out the > cobwebs". Have not disabled the nightly reboot since the upgrade to 1.6.2, so > do not have current data/log files. I'm willing to try other config settings. > I'm pretty sure I saw an interesting looking patch that drops database > connections (mainly for streaming situations) that I can't seem to find right > now, but might help this particular stability issue.
There's a patch here for xmlui: http://jira.dspace.org/jira/browse/DS-677 I'm don't know if this addresses the problem that you used to have in 1.5, though. I think I've seen something like what you're talking about with a scheduling conflict between vacuuming or other maintenance of the database and the media filter processes running. It's been a long time though and I'm very fuzzy on this. In 1.6, the solr statistics code seems to make heavy use of database connections to figure out which item, collections, and communities a bitstream belongs. I haven't spent enough time poking around though to see if the database usage might be reduced, or the connections held open less often. On a side note, I noticed that in the slides for the recent presentation from @mire about the statistics system, there are a few suggestions for optimizing solr sites with heavy usage. I missed the seminar, though, so I'm not sure of the details. --keith ------------------------------------------------------------------------------ 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-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
