[pgpool-general: 3619] degenerate backend request.

[Armin Nesiren]

Hello,

I'm running pgpool + two postgresql servers in streaming replication with
load balancing enabled.

pgpool version is 3.4.1 (tataraboshi)
postgresql is 9.3

Recently I have a lot of failovers that is happening for unknown reason to
me and puts my master node out.

This is part of my log that is interesting, this is when failover is
started:


Apr 13 09:20:28 localhost pgpool1[28256]: [3299-1] 2015-04-13 09:20:28: pid
28256: LOG:  pool_send_and_wait: Error or notice message from backend: : DB
node id: 1 backend pid: 6667 statement: "begin;" message: "there is already
a transaction in progress"

Apr 13 09:20:31 localhost pgpool1[4539]: [794-1] 2015-04-13 09:20:31: pid
4539: LOG:  received degenerate backend request for node_id: 0 from pid
[4539]

*Apr 13 09:20:31 localhost pgpool1[10204]: [3171-1] 2015-04-13 09:20:31:
pid 10204: LOG:  starting degeneration. shutdown host node1(5432)*

*Apr 13 09:20:31 localhost pgpool1[10204]: [3172-1] 2015-04-13 09:20:31:
pid 10204: LOG:  Restart all children*

*Apr 13 09:20:31 localhost pgpool1[10204]: [3173-1] 2015-04-13 09:20:31:
pid 10204: LOG:  execute command: /etc/pgpool1/failover.sh 0 "node1" 5432
/var/lib/pgsql/9.3/data 1 0 "node2" 0*

Apr 13 09:20:31 localhost pgpool1[23945]: [2964-1] 2015-04-13 09:20:31: pid
23945: LOG:  child process received shutdown request signal 3

Apr 13 09:20:31 localhost pgpool1[28278]: [3166-1] 2015-04-13 09:20:31: pid
28278: LOG:  child process received shutdown request signal 3

Part of pgpool configuration that might be interesting:

replication_stop_on_mismatch = off
failover_if_affected_tuples_mismatch = off
health_check_period = 30
health_check_timeout = 60


Of course I can provide more info if needed.
Can someone please help me where to look and how to indentify/prevent this
problem.

Thanks a lot.

-- 
Armin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150413/519e1e79/attachment.html>