do all the backends need to be the same version of postgresql? On Wed, Jul 8, 2009 at 10:08 AM, » Ruben Alves <[email protected]> wrote:
> Hi, > > It's all explained online, > http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#config > > Regards, > > > > paul jobs wrote: > > in parallel_mode > shud i turn on load_balance or not > > if load_balance is turned on nothing works > if it is turned off it gets partial data which is not godo > > On Wed, Jul 8, 2009 at 1:44 AM, » Ruben Alves <[email protected]> wrote: > >> Hello, I had the same problem last week. >> Maybe is because the two nodes are not exactly the same. Functions like >> pg_dump/pg_restore are not sufficient to make a perfect replication. You >> should try rsync or tar.gz your postgresql folder and send it to the others >> nodes. >> I also found an interesting point, the way postgresql is configured in >> node1 and node2 should be practically the same (in my case: >> /etc/postgresql/8.3/main/postgresql.conf) >> >> Regards, >> >> Ruben >> >> [email protected] wrote: >> >>> this keeps changing and causing errors >>> >>> The connection kind keeps changing how do we detect this - this is >>> causing a major problem - how do we debug this >>> >>> has any one encountered this behavior in pgpool-II parallel mode >>> thanks >>> >>> 2009-07-07 14:28:23 LOG: pid 5582: statement: select * from zeitgist >>> where keywords=E'megan foxx tattoos' >>> 2009-07-07 14:28:23 ERROR: pid 5582: read_kind_from_backend: 3 th kind D >>> does not match with master or majority connection kind C >>> 2009-07-07 14:28:23 ERROR: pid 5582: kind mismatch among backends. >>> Possible last query was: "select * from zeitgist where keywords=E'megan foxx >>> tattoos'" kind details are: 0[C] 1[C] 2[C] 3[D] >>> 2009-07-07 14:28:23 LOG: pid 5582: do_child: exits with status 1 due to >>> error >>> >>> ot match with master or majority connection kind C >>> 2009-07-07 14:35:46 ERROR: pid 19440: kind mismatch among backends. >>> Possible last query was: "select * from zeitgist where keywords=E'hrvatski >>> porno'" kind details are: 0[C] 1[C] 2[C] 3[D] >>> 2009-07-07 14:35:46 LOG: pid 19440: do_child: exits with status 1 due >>> to error >>> >>> >>> >>> 2009-07-07 14:29:27 LOG: pid 4859: statement: select * from zeitgist >>> where keywords=E'niñas follando de edad 13' >>> 2009-07-07 14:29:27 ERROR: pid 4859: read_kind_from_backend: 2 th kind D >>> does not match with master or majority connection kind C >>> 2009-07-07 14:29:27 ERROR: pid 4859: kind mismatch among backends. >>> Possible last query was: "select * from zeitgist where keywords=E'niñas >>> follando de edad 13'" kind details are: 0[C] 1[C] 2[D] 3[C] >>> 2009-07-07 14:29:27 LOG: pid 4859: do_child: exits with status 1 due to >>> error >>> >>> 2009-07-07 14:34:38 LOG: pid 19436: do_child: exits with status 1 due >>> to error >>> 2009-07-07 14:34:46 LOG: pid 19448: pool_read_message_length2: message >>> length (17) in slot 2 does not match with slot 0(24) >>> 2009-07-07 14:34:46 LOG: pid 19448: statement: SET DATESTYLE TO 'ISO' >>> 2009-07-07 14:34:46 LOG: pid 19448: statement: SHOW client_encoding >>> 2009-07-07 14:34:46 LOG: pid 19448: statement: SHOW >>> default_transaction_isolation >>> 2009-07-07 14:34:46 LOG: pid 19448: statement: BEGIN; SET TRANSACTION >>> ISOLATION LEVEL READ COMMITTED >>> 2009-07-07 14:34:46 LOG: pid 19448: statement: select * from zeitgist >>> order by count desc limit 10 >>> 2009-07-07 14:34:46 ERROR: pid 19448: read_kind_from_backend: 2 th kind C >>> does not match with master or majority connection kind D >>> 2009-07-07 14:34:46 ERROR: pid 19448: kind mismatch among backends. >>> Possible last query was: "select * from zeitgist order by count desc limit >>> 10" kind details are: 0[D] 1[D] 2[C] 3[D] >>> 2009-07-07 14:34:46 LOG: pid 19448: do_child: exits with status 1 due >>> to error >>> >>> >>> >>> -- >>> Bidegg worlds best auction site >>> http://bidegg.com >>> >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> Pgpool-general mailing list >>> [email protected] >>> http://pgfoundry.org/mailman/listinfo/pgpool-general >>> >>> >> >> >> -- >> Ruben Alves >> System Analyst USI @ Instituto de Medicina Molecular >> >> _______________________________________________ >> Pgpool-general mailing list >> [email protected] >> http://pgfoundry.org/mailman/listinfo/pgpool-general >> > > > > -- > BidEgg - Worlds best low price Auction site > http://bidegg.com > > > > -- > Ruben Alves > > System Analyst > USI @ Instituto de Medicina Molecular > > > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > > -- Bidegg worlds best auction site http://bidegg.com
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
