proxool-user

[Proxool-user] Connection automatically removed

[Ezio P. <Ezi...@at...>]

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:20
22)

 at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:19
40)

 at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:19
25)

 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

Re: [Proxool-user] Connection automatically removed

[Bill H. <bi...@lo...>]

Hi Ezio,

You'll need to change the *maximum-active-time* to something greater than
the default 300 seconds. (Note: the doc says default is 5 minutes but fails
to mention that the unit is seconds).

See http://proxool.sourceforge.net/properties.html

-
Bill

2009/9/1 Ezio Pontiggia <Ezi...@at...>

>  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
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Proxool-user mailing list
> Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-user
>
>