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 <[email protected]> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
