[Pgpool-general] pgpool losing queries

[Tatsuo Ishii]

How do you judge your queries "lost"? If an insert query commits *and* you
do not see the data, that's definitely a serious problem. On the
contrary if you do not confirm the query gets committed, then it's not
surprising at all.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I detected that my "lost" queries, are lost in the first stage, not in the
> second. Well, provably they are lost just when the postgreSQL server falls,
> maybe pgpool is not noticeing that inmediatly?
> 
> The error it gives to me, the client is:
> psql: server closed the connection unexpectedly
>     This probably means the server terminated abnormally
>     before or while processing the request.
> 
> Sending queries every second, more or less, 7 or 8 of them are lost with
> that message.
> 
> Thanks!