4 Replies Latest reply on Feb 25, 2013 11:42 AM by mircea.markus

MySQL drops connections after 8 hours...

edschepis Feb 10, 2013 4:55 PM

I see the following error after some inactivity of my Infinispan clients. Infinispan 5.1.6 is using MySQL as cachestore.

Googling around it seems that the suggested "autoReconnect=true" property couldn't work (http://hibernatedb.blogspot.it/2009/05/automatic-reconnect-from-hibernate-to.html).

Any suggestion? Do I have some control on these settings from Infinispan?

Thanks

Edoardo

ERROR [org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore] (http--127.8.96.129-8080-2) ISPN008024: Error while storing string key to database; key: 'EC:85:2F:03:B3:CC', buffer size of value: 133 bytes: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 210,721,446 milliseconds ago. The last packet sent successfully to the server was 210,721,446 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_09-icedtea]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_09-icedtea]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_09-icedtea]

at java.lang.reflect.Constructor.newInstance(Constructor.java:525) [rt.jar:1.7.0_09-icedtea]

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [mysql-connector-java-5.1.22-bin.jar:]

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117) [mysql-connector-java-5.1.22-bin.jar:]

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3851) [mysql-connector-java-5.1.22-bin.jar:]

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2471) [mysql-connector-java-5.1.22-bin.jar:]

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) [mysql-connector-java-5.1.22-bin.jar:]

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734) [mysql-connector-java-5.1.22-bin.jar:]

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) [mysql-connector-java-5.1.22-bin.jar:]

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458) [mysql-connector-java-5.1.22-bin.jar:]

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375) [mysql-connector-java-5.1.22-bin.jar:]

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359) [mysql-connector-java-5.1.22-bin.jar:]

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) [c3p0-0.9.1.2.jar:0.9.1.2]

at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.storeLockSafe(JdbcStringBasedCacheStore.java:243) [infinispan-cachestore-jdbc.jar:5.1.6.FINAL]

at org.infinispan.loaders.jdbc.stringbased.JdbcStringBasedCacheStore.storeLockSafe(JdbcStringBasedCacheStore.java:87) [infinispan-cachestore-jdbc.jar:5.1.6.FINAL]

at org.infinispan.loaders.LockSupportCacheStore.store(LockSupportCacheStore.java:207) [infinispan-core-5.1.6.FINAL.jar:5.1.6.FINAL]

at org.infinispan.interceptors.CacheStoreInterceptor.visitPutKeyValueCommand(CacheStoreInterceptor.java:235) [infinispan-core-5.1.6.FINAL.jar:5.1.6.FINAL]