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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
