[pgpool-general: 8499] Re: received degenerate backend request for node_id: 0 from pid [$pid]

[Giuseppe Sacco]

Il giorno mer, 16/11/2022 alle 17.38 +0900, Bo Peng ha scritto:
> Hello,
> 
> > [unknown] pid 3166920: LOG:  received degenerate backend request for
> > node_id: 0 from pid [3166920]
> 
> Could you show more logs which include the logs of process [3166920]?
> I need to check what causes the failover.

This is a complete log for more than 20 minutes before the problem occurred
again today:

2022-11-18 12:58:34.378: child pid 3363754: DETAIL:  backend will still use md5 auth
2022-11-18 12:58:34.378: child pid 3363754: HINT:  you can disable this behavior by setting allow_clear_text_frontend_auth to off
2022-11-18 13:03:35.331: child pid 3353374: LOG:  new connection received
2022-11-18 13:03:35.331: child pid 3353374: DETAIL:  connecting host=<IP2 redacted> port=51470
2022-11-18 13:03:35.444: child pid 3353374: LOG:  using clear text authentication with frontend
2022-11-18 13:03:35.444: child pid 3353374: DETAIL:  backend will still use md5 auth
2022-11-18 13:03:35.444: child pid 3353374: HINT:  you can disable this behavior by setting allow_clear_text_frontend_auth to off
2022-11-18 13:03:35.570: main pid 1486879: LOG:  child process with pid: 3327680 exits with status 256
2022-11-18 13:03:35.571: main pid 1486879: LOG:  fork a new child process with pid: 3363833
2022-11-18 13:05:50.713: [unknown] pid 3339823: LOG:  new connection received
2022-11-18 13:05:50.713: [unknown] pid 3339823: DETAIL:  connecting host=<IP2 redacted> port=51472
2022-11-18 13:08:36.383: [unknown] pid 3353374: LOG:  new connection received
2022-11-18 13:08:36.383: [unknown] pid 3353374: DETAIL:  connecting host=<IP2 redacted> port=51474
2022-11-18 13:09:47.767: [unknown] pid 3323799: LOG:  received degenerate backend request for node_id: 0 from pid [3323799]
2022-11-18 13:09:47.767: [unknown] pid 3323799: LOG:  signal_user1_to_parent_with_reason(0)
2022-11-18 13:09:47.767: main pid 1486879: LOG:  Pgpool-II parent process received SIGUSR1
2022-11-18 13:09:47.767: main pid 1486879: LOG:  Pgpool-II parent process has received failover request
2022-11-18 13:09:47.767: main pid 1486879: LOG:  starting degeneration. shutdown host <IPredacted>(5995)
2022-11-18 13:09:47.768: main pid 1486879: LOG:  Restart all children
2022-11-18 13:09:47.768: main pid 1486879: LOG:  find_primary_node_repeatedly: waiting for finding a primary node
2022-11-18 13:09:47.768: main pid 1486879: LOG:  failover: set new primary node: 0
2022-11-18 13:09:47.768: main pid 1486879: LOG:  failover: set new main node: 1
failover done. shutdown host <IPredacted>(5995)
2022-11-18 13:09:47.773: sr_check_worker pid 3276996: LOG:  worker process received restart request
2022-11-18 13:09:47.773: main pid 1486879: LOG:  failover done. shutdown host <IPredacted>(5995)

I only see a mention about exit status 256, but this was about 6 minutes
before the problem. Should I change a log level or such?

Thank you,
Giuseppe