[Pgpool-general] Difficulty keeping things in sync
Tatsuo Ishii
ishii at sraoss.co.jp
Tue Feb 9 10:06:01 UTC 2010
pgpool-II 2.3.1 has a problem with unixODBC(=older
protocol). pgpool-II 2.3.2 should have solved the problem.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> I'm looking through the logs on some of the other affected programs and
> found this too:
>
> ERROR: kind mismatch among backends.
> message contents do not agree with length in message type "E"
>
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
>
> I tried running 2.3.1 but had to downgrade to 2.2.6 because I use unixODBC
> for some of my connections and they stopped working after the upgrade.
>
>
> -Chris
>
> On Tue, Feb 9, 2010 at 12:14 AM, Chris Coleman <chrisc at vmunix.com> wrote:
>
> > I'm having a difficult time keeping my databases in sync.
> >
> > Warning: pg_query(): Query failed: ERROR: pgpool detected difference of
> > the number of inserted, updated or deleted tuples. Possible last query was:
> > "update queue set process_time=now(), status = 1 where id = 256"
> >
> > I'm running FBSD 7.2, pgpool 2.2.6 and postgres 8.4. I have 3 postgres
> > servers setup in load balance mode
> >
> > # Replication mode
> > replication_mode = true
> >
> > # Load balancing mode, i.e., all SELECTs are load balanced.
> > # This is ignored if replication_mode is false.
> > load_balance_mode = true
> >
> > # if there's a data mismatch between master and secondary
> > # start degeneration to stop replication mode
> > replication_stop_on_mismatch = false
> >
> > # If true, replicate SELECT statement when load balancing is disabled.
> > # If false, it is only sent to the master node.
> > replicate_select = false
> >
> > This latest sync lasted about 4 hours. I used pg_dumpall to sync up the
> > DBs the last time. I'm working on getting online recovery setup still.
> >
> > --
> > Chris Coleman -- http://Podlinez.com
> >
>
>
>
> --
> Chris Coleman -- http://Podlinez.com
More information about the Pgpool-general
mailing list