[Pgpool-general] Mismatch among backends

[Tatsuo Ishii]

> > Mar  5 14:51:08 pgsql1 pgpool: ERROR: pid 19538: kind mismatch among
> > backends. Possible last query was: "delete from "TSearcher"" kind
> > details are: 0[C] 1[E]
> 
> Regarding this error, I found out that the developer was using
> pgAdmin3 1.8.4 and tried to cancel the looooong request. I suppose he
> did not have the sentence inside a transaction and that made it fail.
> Could have it been this, Tatsuo?

I don't what the developer was actually doing but If the develper was
connecting to pgpool-II 2.2, then it should have automatically started
a transaction. You could always check if it's the case by enabling
statement log in your PostgreSQL.
--
Tatsuo Ishii
SRA OSS, Inc. Japan