Jose and Dorothea: The same thing happens to us as well. I have to restart Tomcat about every morning. I haven't found the magic combination of db connections. We are using:
db.maxconnections = 50 db.maxwait = 5000 db.maxidle = 5 At 11:06 AM 1/19/2007, Jose Blanco wrote: >So what do you do? Restart tomcat all day long? For some reason, it is >happening very frequently today. It's making the system kind of unusable >when every 30 minutes to an hour tomcat has to be restarted. > >It's a bit comforting to know it's not just my problem. Will you be at the >Open repository conference in San Antonio next week? I'll be there, and >hope we can get some help on this. > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Dorothea >Salo >Sent: Friday, January 19, 2007 11:03 AM >Cc: dspace-tech@lists.sourceforge.net >Subject: Re: [Dspace-tech] connections to db seem to be getting stuck > >Jose Blanco wrote: > > We have our db connections set to 30. We are being heavily crawled right > > now, and it seems like when we get to 30 "idle in transaction" connections > > to the db, we start getting the errors that the connection pool is being > > exhausted, and tomcat has to be restarted to get dspace to work again. > > > > > > > > It seems like connections to the db are getting stuck. Any suggestions >out > > there on how to solve this problem? > > No suggestions, just sympathy. It's happening to us too, though I'm >not sure >that our magic number is the same as yours. > >Dorothea > >-- >Dorothea Salo, Digital Repository Services Librarian >(703)993-3742 [EMAIL PROTECTED] AIM: gmumars >MSN 2FL, Fenwick Library >George Mason University >4400 University Drive, Fairfax VA 22031 > >------------------------------------------------------------------------- >Take Surveys. Earn Cash. Influence the Future of IT >Join SourceForge.net's Techsay panel and you'll get the chance to share your >opinions on IT & business topics through brief surveys - and earn cash >http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >_______________________________________________ >DSpace-tech mailing list >DSpace-tech@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/dspace-tech > > > > >------------------------------------------------------------------------- >Take Surveys. Earn Cash. Influence the Future of IT >Join SourceForge.net's Techsay panel and you'll get the chance to share your >opinions on IT & business topics through brief surveys - and earn cash >http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV >_______________________________________________ >DSpace-tech mailing list >DSpace-tech@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/dspace-tech *************************** George Kozak Acting Coordinator Web Development and Management Digital Media Group 504 Olin Library Cornell University 607-255-8924 *************************** [EMAIL PROTECTED] ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech