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

[Soni Maula Harriz]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120712/39195f98/attachment.html>