[Pgpool-general] failover question

[Tatsuo Ishii]

I don't think of any idea which explains why you have the problem with
9.0 but you don't have with 8.4. Have you changed pgpool.conf?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
> 
> I'm running pgpool2 3.0.1 with replication mode on two postgresql
> 9.0.4 db servers (updated from 8.4.4).  I have the 'replicate_select'
> and 'replication_stop_on_mismatch' both set to 'true'.
> I just noticed that under psql, if I cancel a long select sql (before
> any output displayed), I'll get the following message and the pgpool
> failed over.  I don't recall this happened with 8.4.4.  Can anyone
> explain why and how to avoid this ?
> 
> [sd3ops1.ops1_admin].sd3ops1> select * from file;
> Cancel request sent
> ERROR: kind mismatch among backends. Possible last query was: "select
> * from file;" kind details are: 0[E: canceling statement due to user
> request] 1[D]
> HINT:  check data consistency among db nodes
> server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> The connection to the server was lost. Attempting reset: Succeeded.
> 
> 
> Thanks,
> Gary
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general