Re: [Pgpool-general] kind mismatch among backends. keeps changing between servers

Wed, 08 Jul 2009 10:08:52 -0700

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

Reply via email to