Atomikos Forum

Hi,

We are using Atomikos (3.9.3) with tomcat6 and mysql. Following are the values of the poolSizes:
poolSize=20
minPoolSize=20
maxPoolSize=80

Intermittently an error is observed to increase the poolSize value or the borrowConnectionTimeout.

Please correct me if I am wrong, but I am of the understanding that the connections shown in 'show full processlist' of mysql is the number of connections in the pool.

In one of our applications, when it starts, it does so with the minPoolSize value definitely, which is 20 in our case. But after a day or two, it keeps on decreasing steadily (reached around 4 once). Then we consistently get errors about creating a new connection. After restarting the server it worked fine for some time, before the same issue occurred.

Other applications deployed in different boxes also using atomikos work fine. The number of connections shown in 'show full processlist' never goes down below the minPoolSize.

We are using Spring with Hibernate and also there are some direct JDBC calls. I am guessing there's some kind of leak which is closing the connection outright and is not again created in the pool.

Has anybody else come across this problem?

I for one do not recall this kind of behaviour. You might want to grab the 4.0 pool at maven central, which has been refactored. Otherwise, I recommend getting a subscription so we can go through your logs.