Re: [Proxool-user] Question about Proxool connection pool

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

Hi Joe,
No need to post the message to all the Proxool lists! I'm replying to
proxool-user because I think it's most appropriate.

This error occurs when you try to use a connection that Proxool has closed
itself. This often (always?) happens if a connection has remained active for
more than the maximum-active-time, which defaults to 5 minutes. There are
two common reasons for that: 1) a genuine but lengthy query that takes
longer than 5 minutes, or 2) a connection reference being kept in reference
and not closed.

As the error says, take a look back in the logs a bit further and see if you
can see where the connection is closed. Proxool should explain why it is
being closed.

It's not unusual for it to work on the second attempt - you'll be picking up
a fresh connection.

Regards,
--
Bill Horsman
http://www.logicalcobwebs.com/bill_horsman