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

Tomasz Chmielewski mangoo at wpkg.org
Mon Mar 1 00:38:31 UTC 2010


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.


-- 
Tomasz Chmielewski
http://wpkg.org


More information about the Pgpool-general mailing list