[Pgpool-general] thousands of queries from pgpool to one of the backends (queries I don't do)

[Tatsuo Ishii]

> Tatsuo Ishii wrote:
> > Unless you have those queries in reset_query_list, there's no
> > possibilty for pgpool to send such queries.
> 
> This is what I have there:
> 
> ABORT; DISCARD ALL
> 
> 
> > It seems you have a back door on backend1. I recommend you to enaale
> > log_connections to see who is sending the query.
> 
> It may well be that the queries are sent by my application running in 
> the network - but:
> 
> - backend0 has weight 1; backend1 has weight 0 - doesn't in mean these 
> queries should be sent to backend0? Right now, backend0 gets only few 
> queries; backend1 gets thousands.

If those queries are sent to backend1 directory, there's no point to
discuss about pgpool's weight parameters.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp