I have also been trying to track this down for the last few months. We are on a gallera cluster, mariadb. I have not tried the 0.8.1 Snapshot, but it looks like from the comments that it may not have provided the fix?
Each time this error is thrown, a connection seems to be "lost" to the pool, and I start going negative on the leased statistics
Current stats on one production server:
Total Connections Requested: 57691
Total Created Connections: 24
Cache Hit Ratio: 0
Total Leased Connections: -1
Total Free Connections: 25
Connection Wait Time Avg: 0.0108
Statements Prepared: 17594
Statements Executed: 91571
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
at sun.reflect.GeneratedConstructorAccessor31.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ConnectionImpl.throwConnectionClosedException(ConnectionImpl.java:1269)
at com.mysql.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:1261)
at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4261)
at com.mysql.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:4227)
at com.jolbox.bonecp.ConnectionHandle.prepareStatement(ConnectionHandle.java:1024)
at com.zaneray.foundation.sql.SQLCreator.getPreparedStatement(SQLCreator.java:96)
I have also been trying to track this down for the last few months. We are on a gallera cluster, mariadb. I have not tried the 0.8.1 Snapshot, but it looks like from the comments that it may not have provided the fix?
Each time this error is thrown, a connection seems to be "lost" to the pool, and I start going negative on the leased statistics
Current stats on one production server:
Total Connections Requested: 57691
Total Created Connections: 24
Cache Hit Ratio: 0
Total Leased Connections: -1
Total Free Connections: 25
Connection Wait Time Avg: 0.0108
Statements Prepared: 17594
Statements Executed: 91571
Config: partitionCount= 4 minConnectionsP erPartition= 2 maxConnectionsP erPartition= 25 maxConnectionAg e=0 acquireIncremen t=4
db.default.
db.default.
db.default.
db.default.
db.default.
com.mysql. jdbc.exceptions .jdbc4. MySQLNonTransie ntConnectionExc eption: No operations allowed after connection closed. GeneratedConstr uctorAccessor31 .newInstance( Unknown Source) DelegatingConst ructorAccessorI mpl.newInstance (DelegatingCons tructorAccessor Impl.java: 27) reflect. Constructor. newInstance( Constructor. java:513) jdbc.Util. handleNewInstan ce(Util. java:411) jdbc.Util. getInstance( Util.java: 386) jdbc.SQLError. createSQLExcept ion(SQLError. java:1014) jdbc.SQLError. createSQLExcept ion(SQLError. java:988) jdbc.SQLError. createSQLExcept ion(SQLError. java:974) jdbc.SQLError. createSQLExcept ion(SQLError. java:919) jdbc.Connection Impl.throwConne ctionClosedExce ption(Connectio nImpl.java: 1269) jdbc.Connection Impl.checkClose d(ConnectionImp l.java: 1261) jdbc.Connection Impl.prepareSta tement( ConnectionImpl. java:4261) jdbc.Connection Impl.prepareSta tement( ConnectionImpl. java:4227) bonecp. ConnectionHandl e.prepareStatem ent(ConnectionH andle.java: 1024) foundation. sql.SQLCreator. getPreparedStat ement(SQLCreato r.java: 96)
at sun.reflect.
at sun.reflect.
at java.lang.
at com.mysql.
at com.mysql.
at com.mysql.
at com.mysql.
at com.mysql.
at com.mysql.
at com.mysql.
at com.mysql.
at com.mysql.
at com.mysql.
at com.jolbox.
at com.zaneray.