<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div data-marker="__SIG_PRE__"><div>Hello, in my configuration </div><div><br data-mce-bogus="1"></div><div>connect_timeout = 10000<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Anyway, from 10 august I don't see these delays anymore, I don't know why.</div><div>If it will happen again, I'll try.</div><div>Thank you. </div></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>Da: </b>"Bo Peng" <pengbo@sraoss.co.jp><br><b>A: </b>"fmazzi" <fmazzi@comune.genova.it><br><b>Cc: </b>"pgpool-general" <pgpool-general@pgpool.net><br><b>Inviato: </b>Lunedì, 16 agosto 2021 4:11:30<br><b>Oggetto: </b>[pgpool-general: 7666] Re: Problems with response time<br></div><div><br></div><div data-marker="__QUOTED_TEXT__">Hello,<br><br>Thank you for your log.<br><br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: creating new connection to backend <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: connecting 0 backend <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: pool_connection_pool.c:878 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: creating new connection to backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: connecting 1 backend <br><br>From the log, I found that the connection created to node0 takes 5s.<br><br>I checked the source code and a possible cause might be that <br>pgpool was waiting for "connect_timeout".<br><br>https://www.pgpool.net/docs/latest/en/html/runtime-config-health-check.html#GUC-CONNECT-TIMEOUT <br><br>What's your configuration of "connect_timeout" paramater?<br><br>To identify cause, please check if the response time<br>changes by setting "connect_timeout=1000".<br><br>Regards,<br><br>> Here is the debug log (filtered on only the nagios check process): <br>> <br>> Aug 5 09:50:41 xxxxxx pgpool: 2021-08-05 09:50:41: pid 4811: LOG: fork a new child process with pid: 11242 <br>> Aug 5 09:50:41 xxxxxx pgpool: 2021-08-05 09:50:41: pid 11242: DEBUG: initializing backend status <br>> Aug 5 09:50:41 xxxxxx pgpool: 2021-08-05 09:50:41: pid 11242: LOCATION: child.c:1411 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: I am 11242 accept fd 7 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1831 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOG: new connection received <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: connecting host=192.168.153.5 port=52882 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1844 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: reading startup packet <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: Protocol Major: 1234 Minor: 5679 database: user: <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:744 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: selecting backend connection <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: SSLRequest from client <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1909 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: reading startup packet <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: Protocol Major: 3 Minor: 0 database: template1 user: nagios <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:744 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: md5 authentication successful with frontend <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: pool_auth.c:1609 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: creating new connection to backend <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: connecting 0 backend <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: pool_connection_pool.c:878 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: creating new connection to backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: connecting 1 backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:878 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: creating new connection to backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: connecting 2 backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:878 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: auth kind:5 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:420 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 0 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 1 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 2 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"application_name" value:"" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"application_name" value:"" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"application_name" value:"" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"client_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"client_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"client_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"DateStyle" value:"ISO, MDY" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"DateStyle" value:"ISO, MDY" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"DateStyle" value:"ISO, MDY" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"integer_datetimes" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"integer_datetimes" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"integer_datetimes" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"IntervalStyle" value:"postgres" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"IntervalStyle" value:"postgres" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"IntervalStyle" value:"postgres" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"is_superuser" value:"off" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"is_superuser" value:"off" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"is_superuser" value:"off" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"server_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"server_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"server_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"server_version" value:"12.7" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"server_version" value:"12.7" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"server_version" value:"12.7" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"session_authorization" value:"nagios" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"session_authorization" value:"nagios" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"session_authorization" value:"nagios" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"standard_conforming_strings" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"standard_conforming_strings" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"standard_conforming_strings" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"TimeZone" value:"Europe/Rome" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"TimeZone" value:"Europe/Rome" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"TimeZone" value:"Europe/Rome" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eec08 pid:8102 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eec90 pid:18031 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eed18 pid:31076 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: sending backend key data <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: send pid 31076 to frontend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:917 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: selecting load balance node <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: selected backend id is 2 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_pg_utils.c:462 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: connecting to memcached on Host:"localhost:11211" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:157 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOG: DB node id: 0 backend pid: 8102 statement: SELECT version() <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: username: "nagios" database_name: "template1" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:569 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query: "SELECT version()" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:576 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: `nagiosSELECT version()template1' -> `30c2be92aabe22c2857721765bbe2c7a' <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:587 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: fetching from cache storage <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: search key "30c2be92aabe22c2857721765bbe2c7a" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:471 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: fetching from cache storage <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query="SELECT version()" len:115 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:543 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: hit query cache <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query:SELECT version() <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_relcache.c:268 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: decide where to send the query <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: destination = 3 for query= " DISCARD ALL" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_query_context.c:496 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOG: DB node id: 0 backend pid: 8102 statement: DISCARD ALL <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: waiting for query response <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: waiting for backend:0 to complete the query <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:532 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOG: DB node id: 2 backend pid: 31076 statement: DISCARD ALL <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: waiting for query response <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: waiting for backend:2 to complete the query <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:532 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: setting backend connection close timer <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: close time 1628150146 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:348 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOG: frontend disconnection: session time: 0:00:05.087 user=nagios database=template1 host=192.168.153.5 port=52882 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: child.c:2060 <br>> Aug 5 10:00:46 xxxxxx pgpool: 2021-08-05 10:00:46: pid 11242: DEBUG: child life 300 seconds expired <br>> Aug 5 10:00:46 xxxxxx pgpool: 2021-08-05 10:00:46: pid 11242: LOCATION: child.c:340 <br>> Aug 5 10:00:46 xxxxxx pgpool: 2021-08-05 10:00:46: pid 4811: LOG: child process with pid: 11242 exits with status 256 <br>> <br>> As you can see, there is a hole from 09:55:41 to 09:55:46. <br>> And this is the complete log from 09:55:41 to 09:55:46 with alla processes: <br>> <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: I am 11242 accept fd 7 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1831 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOG: new connection received <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: connecting host=192.168.153.5 port=52882 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1844 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: reading startup packet <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: Protocol Major: 1234 Minor: 5679 database: user: <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:744 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: selecting backend connection <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: SSLRequest from client <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1909 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: reading startup packet <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: Protocol Major: 3 Minor: 0 database: template1 user: nagios <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:744 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: md5 authentication successful with frontend <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: pool_auth.c:1609 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: creating new connection to backend <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: connecting 0 backend <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: pool_connection_pool.c:878 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 10924: DEBUG: child life 300 seconds expired <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 10924: LOCATION: child.c:340 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: DEBUG: reaper handler <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOCATION: pgpool_main.c:2269 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOG: child process with pid: 10924 exits with status 256 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOCATION: pgpool_main.c:2338 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOG: fork a new child process with pid: 11557 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOCATION: pgpool_main.c:2458 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: DEBUG: reaper handler: exiting normally <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOCATION: pgpool_main.c:2472 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11557: DEBUG: initializing backend status <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11557: LOCATION: child.c:1411 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: health_check.c:369 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: authenticate kind = 0 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: pool_auth.c:144 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: authenticate backend: key data received <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: pool_auth.c:254 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: authenticate backend: transaction state: I <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: pool_auth.c:287 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: health_check.c:386 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: health_check.c:386 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: health_check.c:369 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: authenticate kind = 0 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: pool_auth.c:144 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: authenticate backend: key data received <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: pool_auth.c:254 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: authenticate backend: transaction state: I <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: pool_auth.c:287 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: health_check.c:386 <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: health_check.c:386 <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate kind = 0 <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:144 <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate backend: key data received <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:254 <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate backend: transaction state: I <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:287 <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate kind = 0 <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:144 <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate backend: key data received <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:254 <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate backend: transaction state: I <br>> Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:287 <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: health_check.c:369 <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: authenticate kind = 0 <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: pool_auth.c:144 <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: authenticate backend: key data received <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: pool_auth.c:254 <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: authenticate backend: transaction state: I <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: pool_auth.c:287 <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: health_check.c:386 <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: health_check.c:386 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: creating new connection to backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: connecting 1 backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:878 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: creating new connection to backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: connecting 2 backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:878 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: auth kind:5 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:420 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 0 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 1 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 2 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"application_name" value:"" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"application_name" value:"" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"application_name" value:"" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"client_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"client_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"client_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"DateStyle" value:"ISO, MDY" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"DateStyle" value:"ISO, MDY" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"DateStyle" value:"ISO, MDY" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"integer_datetimes" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"integer_datetimes" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"integer_datetimes" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"IntervalStyle" value:"postgres" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"IntervalStyle" value:"postgres" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"IntervalStyle" value:"postgres" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"is_superuser" value:"off" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"is_superuser" value:"off" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"is_superuser" value:"off" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"server_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"server_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"server_encoding" value:"UTF8" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"server_version" value:"12.7" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"server_version" value:"12.7" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"server_version" value:"12.7" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"session_authorization" value:"nagios" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"session_authorization" value:"nagios" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"session_authorization" value:"nagios" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"standard_conforming_strings" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"standard_conforming_strings" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"standard_conforming_strings" value:"on" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"TimeZone" value:"Europe/Rome" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"TimeZone" value:"Europe/Rome" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"TimeZone" value:"Europe/Rome" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eec08 pid:8102 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eec90 pid:18031 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eed18 pid:31076 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: sending backend key data <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: send pid 31076 to frontend <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:917 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: selecting load balance node <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: selected backend id is 2 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_pg_utils.c:462 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: connecting to memcached on Host:"localhost:11211" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:157 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOG: DB node id: 0 backend pid: 8102 statement: SELECT version() <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: username: "nagios" database_name: "template1" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:569 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query: "SELECT version()" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:576 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: `nagiosSELECT version()template1' -> `30c2be92aabe22c2857721765bbe2c7a' <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:587 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: fetching from cache storage <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: search key "30c2be92aabe22c2857721765bbe2c7a" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:471 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: fetching from cache storage <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query="SELECT version()" len:115 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:543 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: hit query cache <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query:SELECT version() <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_relcache.c:268 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: decide where to send the query <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: destination = 3 for query= " DISCARD ALL" <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_query_context.c:496 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOG: DB node id: 0 backend pid: 8102 statement: DISCARD ALL <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: waiting for query response <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: waiting for backend:0 to complete the query <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:532 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOG: DB node id: 2 backend pid: 31076 statement: DISCARD ALL <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: waiting for query response <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: waiting for backend:2 to complete the query <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:532 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: setting backend connection close timer <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: close time 1628150146 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:348 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOG: frontend disconnection: session time: 0:00:05.087 user=nagios database=template1 host=192.168.153.5 port=52882 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: child.c:2060 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: health_check.c:369 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: authenticate kind = 0 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: pool_auth.c:144 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: authenticate backend: key data received <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: pool_auth.c:254 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: authenticate backend: transaction state: I <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: pool_auth.c:287 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: health_check.c:386 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: health_check.c:386 <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4872: DEBUG: health check: clearing alarm <br>> Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4872: LOCATION: health_check.c:369 <br>> <br><br><br>-- <br>Bo Peng <pengbo@sraoss.co.jp><br>SRA OSS, Inc. Japan<br>http://www.sraoss.co.jp/<br>_______________________________________________<br>pgpool-general mailing list<br>pgpool-general@pgpool.net<br>http://www.pgpool.net/mailman/listinfo/pgpool-general<br></div></div></body></html>