Connection Pool Exhausted
Posted: Sun Apr 19, 2009 5:13 pm
Hi,
I'm loading 500,000 records into OpenEMM using SOAP addSubscriber and setBinding.
When I start up my loader program it inserts about 20,000 records per hour. Then it gradually runs slower and slower until after 10 hours it can only insert two or three records per minute. Then finally any attempt to insert gets the "Cannot get a connection, pool exhausted" error message. We restart OpenEMM to recover.
I have seen these forum posts:
http://www.openemm.org/forums/viewtopic ... properties
http://www.openemm.org/forums/viewtopic.php?p=2296
In emm.properties I have
jdbc.maxCount=30
I have changed my loader program so it now it inserts a maximum 4000 records at one time. This runs in about 10 minutes, and I start this job with cron once each hour. This is working. The performance is not slowing down like before.
Can you tell me what is going on with the connection pool, and how can I tune it?
Thank you
John
I'm loading 500,000 records into OpenEMM using SOAP addSubscriber and setBinding.
When I start up my loader program it inserts about 20,000 records per hour. Then it gradually runs slower and slower until after 10 hours it can only insert two or three records per minute. Then finally any attempt to insert gets the "Cannot get a connection, pool exhausted" error message. We restart OpenEMM to recover.
I have seen these forum posts:
http://www.openemm.org/forums/viewtopic ... properties
http://www.openemm.org/forums/viewtopic.php?p=2296
In emm.properties I have
jdbc.maxCount=30
I have changed my loader program so it now it inserts a maximum 4000 records at one time. This runs in about 10 minutes, and I start this job with cron once each hour. This is working. The performance is not slowing down like before.
Can you tell me what is going on with the connection pool, and how can I tune it?
Thank you
John