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

[Bo Peng]

Sorry for the late response.

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

I couldn't find any logs that causes the degeneration.
If it's possible, could you change the log devel to debug5 
and share your debug logs and pgpool.conf?

-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/