[Pgpool-general] Difficulty keeping things in sync
Chris Coleman
chrisc at vmunix.com
Tue Feb 9 06:34:04 UTC 2010
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100209/4cec97ce/attachment-0001.html>
More information about the Pgpool-general
mailing list