Comment 48 for bug 1243551

Revision history for this message
Shane Pitts (yhane) wrote :

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:
db.default.partitionCount=4
db.default.minConnectionsPerPartition=2
db.default.maxConnectionsPerPartition=25
db.default.maxConnectionAge=0
db.default.acquireIncrement=4

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)