[pgpool-hackers: 1568] Pgpool Hangs connections when shutting down interface of the secondary
Ricardo Larrañaga
ricardo.larranaga at gmail.com
Fri May 20 03:22:30 JST 2016
Hello Guys:
i have posted this issue in pgpool-Users, but i got no answer. At this
point i am thinking about switching solutions as i cannot make mine work,
but i really like the idea of using pgpool, so i was wondering if i could
get an answer here. This is the issue i am experiencing:
I am running pgpool 3.5.2 in a 2 node cluster with postgresql-9.5 in
master-slave and streaming replication mode.
I have been testing failover and failback for a while. While doing failover
by shutting down the processes, everything looks fine.
The one test that is failing is when i shutdown the interface of one node.
Right now i am shutting down the interface of the slave node (both pgool
slave and postgresql slave).
The problem i am running into is that after doing this, all connections to
my database (through pgpool) hang. i am testing it with psql, and psql just
hangs and does not give me an output. When i bring the interface of the
slave back up, and try to connect to psql again, it looks like pgpool never
marked the postgresql node as disconnected.
I tried both with and without health check, and also tried with different
values of health_check_timeout. my connect timeout value is default (10
seconds).
Any one has encountered this issue? I just dont see pgpool attempting to do
any failover. Pgpool is still running though, i can see the logs still
comming. I just never see an error.
I am NOT using interface monitoring, and i would prefer not to use it.
Any pointers on how could i troubleshoot this?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20160519/766e6063/attachment.html>
More information about the pgpool-hackers
mailing list