[Pgpool-general] Where the query come from

[Tatsuo Ishii]

> 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

Non of pgpool-II/pcp commands or pgpoolAdmin issue such a query.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp