<html><body><div id="zimbraEditorContainer" style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000" class="22"><div>Here is the debug log (filtered on only the nagios check process):</div><div><br data-mce-bogus="1"></div><div><div>Aug 5 09:50:41 xxxxxx pgpool: 2021-08-05 09:50:41: pid 4811: LOG: fork a new child process with pid: 11242</div><div>Aug 5 09:50:41 xxxxxx pgpool: 2021-08-05 09:50:41: pid 11242: DEBUG: initializing backend status</div><div>Aug 5 09:50:41 xxxxxx pgpool: 2021-08-05 09:50:41: pid 11242: LOCATION: child.c:1411</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: I am 11242 accept fd 7</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1831</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOG: new connection received</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: connecting host=192.168.153.5 port=52882</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1844</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: reading startup packet</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: Protocol Major: 1234 Minor: 5679 database: user:</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:744</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: selecting backend connection</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: SSLRequest from client</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1909</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: reading startup packet</div><div>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</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:744</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: md5 authentication successful with frontend</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: pool_auth.c:1609</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: creating new connection to backend</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: connecting 0 backend</div><div>Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: pool_connection_pool.c:878</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: creating new connection to backend</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: connecting 1 backend</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:878</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: creating new connection to backend</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: connecting 2 backend</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:878</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: auth kind:5</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:420</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 0</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 1</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 2</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"application_name" value:""</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"application_name" value:""</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"application_name" value:""</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"client_encoding" value:"UTF8"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"client_encoding" value:"UTF8"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"client_encoding" value:"UTF8"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"DateStyle" value:"ISO, MDY"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"DateStyle" value:"ISO, MDY"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"DateStyle" value:"ISO, MDY"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"integer_datetimes" value:"on"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"integer_datetimes" value:"on"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"integer_datetimes" value:"on"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"IntervalStyle" value:"postgres"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"IntervalStyle" value:"postgres"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"is_superuser" value:"off"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"is_superuser" value:"off"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"is_superuser" value:"off"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"server_encoding" value:"UTF8"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"server_encoding" value:"UTF8"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"server_encoding" value:"UTF8"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"server_version" value:"12.7"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"server_version" value:"12.7"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"server_version" value:"12.7"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"session_authorization" value:"nagios"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"session_authorization" value:"nagios"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"session_authorization" value:"nagios"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"standard_conforming_strings" value:"on"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"standard_conforming_strings" value:"on"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"TimeZone" value:"Europe/Rome"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"TimeZone" value:"Europe/Rome"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"TimeZone" value:"Europe/Rome"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eec08 pid:8102</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eec90 pid:18031</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eed18 pid:31076</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: sending backend key data</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: send pid 31076 to frontend</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:917</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: selecting load balance node</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: selected backend id is 2</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_pg_utils.c:462</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: connecting to memcached on Host:"localhost:11211"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:157</div><div>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()</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: username: "nagios" database_name: "template1"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:569</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query: "SELECT version()"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:576</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: `nagiosSELECT version()template1' -> `30c2be92aabe22c2857721765bbe2c7a'</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:587</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: fetching from cache storage</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: search key "30c2be92aabe22c2857721765bbe2c7a"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:471</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: fetching from cache storage</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query="SELECT version()" len:115</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:543</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: hit query cache</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query:SELECT version()</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_relcache.c:268</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: decide where to send the query</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: destination = 3 for query= " DISCARD ALL"</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_query_context.c:496</div><div>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</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: waiting for query response</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: waiting for backend:0 to complete the query</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:532</div><div>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</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: waiting for query response</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: waiting for backend:2 to complete the query</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:532</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: setting backend connection close timer</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: close time 1628150146</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:348</div><div>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</div><div>Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: child.c:2060</div><div>Aug 5 10:00:46 xxxxxx pgpool: 2021-08-05 10:00:46: pid 11242: DEBUG: child life 300 seconds expired</div><div>Aug 5 10:00:46 xxxxxx pgpool: 2021-08-05 10:00:46: pid 11242: LOCATION: child.c:340</div><div>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</div></div><div><br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__">As you can see, there is a hole from 09:55:41 to 09:55:46.</div><div data-marker="__QUOTED_TEXT__">And this is the complete log from 09:55:41 to 09:55:46 with alla processes:</div><div data-marker="__QUOTED_TEXT__"><br data-mce-bogus="1"></div><div data-marker="__QUOTED_TEXT__"><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: I am 11242 accept fd 7</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1831</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOG: new connection received</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: connecting host=192.168.153.5 port=52882</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1844</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: reading startup packet</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: Protocol Major: 1234 Minor: 5679 database: user:</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:744</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: selecting backend connection</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: SSLRequest from client</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:1909</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: reading startup packet</div><div data-marker="__QUOTED_TEXT__">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</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: child.c:744</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: md5 authentication successful with frontend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: pool_auth.c:1609</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DEBUG: creating new connection to backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: DETAIL: connecting 0 backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11242: LOCATION: pool_connection_pool.c:878</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 10924: DEBUG: child life 300 seconds expired</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 10924: LOCATION: child.c:340</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: DEBUG: reaper handler</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOCATION: pgpool_main.c:2269</div><div data-marker="__QUOTED_TEXT__">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</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOCATION: pgpool_main.c:2338</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOG: fork a new child process with pid: 11557</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOCATION: pgpool_main.c:2458</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: DEBUG: reaper handler: exiting normally</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4811: LOCATION: pgpool_main.c:2472</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11557: DEBUG: initializing backend status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 11557: LOCATION: child.c:1411</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: health_check.c:369</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: authenticate kind = 0</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: pool_auth.c:144</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: authenticate backend: key data received</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: pool_auth.c:254</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: authenticate backend: transaction state: I</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: pool_auth.c:287</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: health_check.c:386</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4870: LOCATION: health_check.c:386</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: health_check.c:369</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: authenticate kind = 0</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: pool_auth.c:144</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: authenticate backend: key data received</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: pool_auth.c:254</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: authenticate backend: transaction state: I</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: pool_auth.c:287</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: health_check.c:386</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:41 xxxxxx pgpool: 2021-08-05 09:55:41: pid 4872: LOCATION: health_check.c:386</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate kind = 0</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:144</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate backend: key data received</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:254</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate backend: transaction state: I</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:287</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate kind = 0</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:144</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate backend: key data received</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:254</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: DEBUG: authenticate backend: transaction state: I</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:44 xxxxxx pgpool: 2021-08-05 09:55:44: pid 29464: LOCATION: pool_auth.c:287</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: health_check.c:369</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: authenticate kind = 0</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: pool_auth.c:144</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: authenticate backend: key data received</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: pool_auth.c:254</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: authenticate backend: transaction state: I</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: pool_auth.c:287</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: health_check.c:386</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:45 xxxxxx pgpool: 2021-08-05 09:55:45: pid 4871: LOCATION: health_check.c:386</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: creating new connection to backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: connecting 1 backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:878</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: creating new connection to backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: connecting 2 backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:878</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: auth kind:5</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:420</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 0</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 1</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend: 2</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: trying md5 authentication</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:543</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"application_name" value:""</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"application_name" value:""</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"application_name" value:""</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"client_encoding" value:"UTF8"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"client_encoding" value:"UTF8"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"client_encoding" value:"UTF8"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"DateStyle" value:"ISO, MDY"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"DateStyle" value:"ISO, MDY"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"DateStyle" value:"ISO, MDY"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"integer_datetimes" value:"on"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"integer_datetimes" value:"on"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"integer_datetimes" value:"on"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"IntervalStyle" value:"postgres"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"IntervalStyle" value:"postgres"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"IntervalStyle" value:"postgres"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"is_superuser" value:"off"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"is_superuser" value:"off"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"is_superuser" value:"off"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"server_encoding" value:"UTF8"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"server_encoding" value:"UTF8"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"server_encoding" value:"UTF8"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"server_version" value:"12.7"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"server_version" value:"12.7"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"server_version" value:"12.7"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"session_authorization" value:"nagios"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"session_authorization" value:"nagios"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"session_authorization" value:"nagios"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"standard_conforming_strings" value:"on"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"standard_conforming_strings" value:"on"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"standard_conforming_strings" value:"on"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:0 name:"TimeZone" value:"Europe/Rome"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:1 name:"TimeZone" value:"Europe/Rome"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: process parameter status</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: backend:2 name:"TimeZone" value:"Europe/Rome"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:928</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eec08 pid:8102</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eec90 pid:18031</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: authentication backend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: cp->info[i]:0x7f5d669eed18 pid:31076</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:777</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: sending backend key data</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: send pid 31076 to frontend</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_auth.c:917</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: selecting load balance node</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: selected backend id is 2</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_pg_utils.c:462</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: connecting to memcached on Host:"localhost:11211"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:157</div><div data-marker="__QUOTED_TEXT__">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()</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: username: "nagios" database_name: "template1"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:569</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query: "SELECT version()"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:576</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: memcache encode key</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: `nagiosSELECT version()template1' -> `30c2be92aabe22c2857721765bbe2c7a'</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:587</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: fetching from cache storage</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: search key "30c2be92aabe22c2857721765bbe2c7a"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:471</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: fetching from cache storage</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query="SELECT version()" len:115</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_memqcache.c:543</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: hit query cache</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: query:SELECT version()</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: CONTEXT: while searching system catalog, When relcache is missed</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_relcache.c:268</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: decide where to send the query</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: destination = 3 for query= " DISCARD ALL"</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_query_context.c:496</div><div data-marker="__QUOTED_TEXT__">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</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: waiting for query response</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: waiting for backend:0 to complete the query</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:532</div><div data-marker="__QUOTED_TEXT__">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</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_proto_modules.c:3486</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: waiting for query response</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: waiting for backend:2 to complete the query</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_process_query.c:532</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DEBUG: setting backend connection close timer</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: DETAIL: close time 1628150146</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: pool_connection_pool.c:348</div><div data-marker="__QUOTED_TEXT__">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</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 11242: LOCATION: child.c:2060</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: health_check.c:369</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: authenticate kind = 0</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: pool_auth.c:144</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: authenticate backend: key data received</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: pool_auth.c:254</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: authenticate backend: transaction state: I</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: pool_auth.c:287</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: health_check.c:386</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4870: LOCATION: health_check.c:386</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4872: DEBUG: health check: clearing alarm</div><div data-marker="__QUOTED_TEXT__">Aug 5 09:55:46 xxxxxx pgpool: 2021-08-05 09:55:46: pid 4872: LOCATION: health_check.c:369</div><div><br data-mce-bogus="1"></div></div></div></body></html>