[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