[Pgpool-general] Where the query come from

Gary Fu gfu at sigmaspace.com
Thu Nov 18 15:15:40 UTC 2010


  Hi,

In the pgpool (ver 3.0) log (below), the fail over happened due to a 
query from the local host (127.0.0.1).  However, I don't know any of our 
applications will use that query.  Can anyone tell if this query comes 
from any pgpool utilities (pcp_xxx_xxx) or any other applications 
(pgAdmin, ...) ?

2010-11-15 18:17:16 LOG:   pid 29794: connection received: 
host=127.0.0.1 port=60340
2010-11-15 18:17:16 ERROR: pid 29794: read_kind_from_backend: 1 th kind 
C does not match with master or majority connection kind D
2010-11-15 18:17:16 ERROR: pid 29794: kind mismatch among backends. 
Possible last query was: "SELECT oid, *, 
pg_catalog.shobj_description(oid, 'pg_authid') AS description  FROM 
pg_roles WHERE rolcanlogin ORDER BY rolname" kind details are: 0[D] 1[C]
2010-11-15 18:17:16 LOG:   pid 29794: notice_backend_error: 1 fail over 
request from pid 29794

Thanks,
Gary



More information about the Pgpool-general mailing list