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

Wed Jul 8 22:25:49 UTC 2009

do all the backends need to be the same version of postgresql?

On Wed, Jul 8, 2009 at 10:08 AM, » Ruben Alves <rubenalves at fm.ul.pt> 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 <rubenalves at fm.ul.pt> 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
>>
>> mobiledreamers at gmail.com 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
>>> Pgpool-general at pgfoundry.org
>>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>>
>>>
>>
>>
>> --
>> Ruben Alves
>> System Analyst USI @ Instituto de Medicina Molecular
>>
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> 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
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>

-- 
Bidegg worlds best auction site
http://bidegg.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090708/a25a5eb3/attachment-0001.html>