Thanks for the info, Stefano, I'll verify the mailet code to ensure no connection leaks. But I'm pretty sure it's clean. Also, it is using a different datasource for all of its db accesses. And my datasource is having no problem getting connections at the same time the container is failing.
This mailet runs the same distribution list 100 times correctly and fails once, then runs another 100 times and fails. So whatever is causing the connection pool exhaustion is most likely other activities on the mail server that accidentally coincide with running this mailet. >> The problem is with mysql connection: fix that I agree. But I don't know why it randomly exceeds the limit in the first place, and I have no clue how to guarantee 100% that no matter what.. there will NEVER be an overrun of the connection pool. (Don't think it's possible to guarantee 100%). (Is there an easy way to log/track/plot connection usage in mySQL?) Thanks. Jerry -----Original Message----- From: Stefano Bagnara [mailto:[EMAIL PROTECTED] Sent: Thursday, March 23, 2006 10:05 AM To: James Users List Subject: Re: Mail List Mailet Infinite Loop on db failure JWM wrote: > Here is a small segment from my mailet log. This is the first occurance of > the error. There are hundreds of others below these lines. This is in the > middle of my loop sending the mail to the addresses in the list. The exception is clear: > java.io.IOException: java.sql.SQLException: Cannot connect to MySQL > server on 127.0.0.1:3306. Is there a MySQL server running on the > machine/port you are trying to connect to? (java.net.BindException) James cannot connect to MySQL. If it cannot write to DB it cannot persist any state to remember not to try again. The problem is with mysql connection: fix that, you can't fix the loop issue in james otherwise. Furthermore: check JWMMailList sourcecode for db connection leaks connections. Stefano --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
