[Pgpool-general] failover question

[Gary Fu]

Thanks for the response.  No, I did not change the pgpool.conf when I 
updated postgresql from 8.4 to 9.0.4.
By the way, did you try this under your environment without problem ?

Thanks,
Gary
> 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