#4 Connection automatically removed

open
nobody
Behaviour (3)
5
2009-09-01
2009-09-01
Ezio Pontiggia
No

Hi,
I use proxool-0.9.1.jar and in my case I open a connection that needs to make a lot of insert statement.
But after 5-6 minutes I receive this exception:
1-set-2009 16.15.55 org.logicalcobwebs.proxool.HouseKeeper sweep
AVVERTENZA: #0006 was active for 318203 milliseconds and has been removed automaticaly. The Thread responsible was named 'Processor iGLFRE.insertDB', but the last SQL it performed is unknown because the trace property is not enabled.
2009-09-01 16:15:55,141 | ERROR | ProcessorContextImpl | Error in processor "iGLFRE.insertDB"
Error message: "Unmanaged Exception thrown."

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2873)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2763)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3299)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
And every other statement, raise this exception:
java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).

When I register my connection pool, I set only proxool.maximum-connection-count, but I don't think that these configs can affect it.
maximum-connection-lifetime must be 4 hour, right?

Thank you for any help,
Ezio

Discussion