[pgpool-general: 724] Re: oid mismatch on pg_database

[Soni Maula Harriz]

got it, i should set :
failover_if_affected_tuples_mismatch : on
replication_stop_on_mismatch : on

so, if the mismatch happen, the mismatch node will be degenerated, and the
service still goes on.
after that, i should do online recovery to sync the nodes back.

am i right?

On Thu, Jul 12, 2012 at 11:13 PM, Soni Maula Harriz <
soni.harriz at sangkuriang.co.id> wrote:

> pgpool version :
> pgpool-II version 3.1.3 (hatsuiboshi)
>
> i downloaded the version from this site :
>
> http://git.postgresql.org/gitweb/?p=pgpool2.git;a=snapshot;h=7015e9f16d34c4f1d28096753638ca78d3d6a7f6;sf=tgz
>
> mode used : replication mode with load balancing
>
>
> On Thu, Jul 12, 2012 at 9:23 PM, Tatsuo Ishii <ishii at postgresql.org>wrote:
>
>> Please tell us more info.  Pgpool version? What mode are you using?
>> streaming replication mode?
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>> > dear all,
>> > i get this issue when testing pgpool.
>> >
>> > 2012-07-12 15:19:49 ERROR: pid 30170: read_kind_from_backend: 1 th kind
>> D
>> > does not match with master or majority connection kind C
>> > 2012-07-12 15:19:49 ERROR: pid 30170: kind mismatch among backends.
>> > Possible last query was: "SET DateStyle=ISO;
>> > SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
>> >   FROM pg_database WHERE oid = 17611" kind details are: 0[C] 1[D]
>> > 2012-07-12 15:19:49 LOG:   pid 30170: do_child: exits with status 1 due
>> to
>> > error
>> >
>> >
>> > There are oid mismatch in pg_database.
>> > My question is : how to resolve this ?
>> > thanks all.
>> >
>> > --
>> > Best Regards,
>> >
>> > Soni Maula Harriz
>> > Database Administrator
>> > PT. Data Aksara Sangkuriang
>>
>
>
>
> --
> Best Regards,
>
> Soni Maula Harriz
> Database Administrator
> PT. Data Aksara Sangkuriang
>
>


-- 
Best Regards,

Soni Maula Harriz
Database Administrator
PT. Data Aksara Sangkuriang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120712/2c8a3af1/attachment-0001.html>