MySQL Forums

I have a couple batch jobs that run a large number of queries. On certain data sets the jobs fail every time with a Communcations Link Failure. The caused by in the stack trace is another Communications Link Failure, which doesn't help me much.

I tried printing out the queries that were being run at the time of error, and I found that it was the same arguments causing the problem each time, yet I was able to both run the query in mysql and also through my application by calling it outside the batch process with the same arguments that keep causing it to fail...

I'm at a bit of a loss here and am hoping someone can help me identify the problem. These errors typically only happen after the patch processes have run for several hours, so I know I've got a good connection string, etc.

I'm using the c3p0 connection pool and have tried changing various settings such as having it check connections on check-in and I've had the idle connection life from 2 minutes to 15 seconds and am still getting the same results. The queries it's failing on aren't very remarkable... Just selects with a couple table joins that return < 10 rows. The tables involved have 5 - 10 million rows.

Thanks!



Edited 1 time(s). Last edit at 11/14/2008 03:25PM by Daniel Quaroni.