[pgpool-general: 5050] PGPool - failover issue

[Bezas, Michael]

Hi I have setup PGPool with Load Balancing and Postgres streaming relication (using postgres not PGPool replication).

Everything is as expected, but on failover from Primary to Standby, it appears that existing connections to PGPool/Postgres are then terminated. ie: the web application loses its connection to PGPool. I have to refresh my browser to re-connect to PGPool. I would have thought that on failover the application would continue working 'seamlessly' to the end user - without having to refresh browser sessions. Does PGPool not handle this ie: re-create a new connection to the new Master? Can this be configured in PGPool?

New connections obviously connect fine but its existing connections have these issues.

I also notice the same behaviour with PG Admin. If I have an SQL session open, the perform failover, then the sessions get a connection error.

Can this be configured in PGPool? Example of error in our application logs is below:

org.postgresql.util.PSQLException: This connection has been closed.
        at org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:796)
        at org.postgresql.jdbc.PgConnection.getAutoCommit(PgConnection.java:767)
        at sun.reflect.GeneratedMethodAccessor279.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126)
        at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
        at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)

Regards
Michael

=============================================================================== 
Please access the attached hyperlink for an important electronic communications disclaimer: 
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html 
=============================================================================== 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161017/ae960fab/attachment.html>