[pgpool-general: 3625] Re: degenerate backend request.

[Armin Nesiren]

Now expect those two lines:

pgpool1[24660]: [13034-1] 2015-04-15 10:00:10: pid 24660: FATAL:  unable to
read data from frontend
pgpool1[24660]: [13034-2] 2015-04-15 10:00:10: pid 24660: DETAIL:  EOF
encountered with frontend

I have nothing in log, even failover is not triggered.
Cluster was ok for some time (about 20 hours), but when traffic is
increased, we gave degeneration... any hinting where I can look at?

On Mon, Apr 13, 2015 at 10:30 AM, Armin Nesiren <armin.nesiren at intera.si>
wrote:

> 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
>



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