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

[Lazáro Rubén García Martínez]

yes.

regards.
________________________________________
From: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] On Behalf Of Soni Maula Harriz [soni.harriz at sangkuriang.co.id]
Sent: Thursday, July 12, 2012 12:14 PM
To: Tatsuo Ishii; pgpool-general at pgpool.net
Subject: [pgpool-general: 724] Re: oid mismatch on pg_database

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<mailto: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<mailto: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


________________________________
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com