[Pgpool-general] RE : pool_do_auth: failed to read kind while processing ParamterStatus

Fri Jun 8 18:00:45 UTC 2007

it could also be because something is accessing one of the databases without
pgpool or a stats row estamate miss match (solvabe with a full vaccum )
issue and posibly but unlikly the different versions

though having the same version of postgresql helps because it allows you to
shutdown the databases and rsync one to the other there by ensuring they are
in sync when you first start them.

On 6/8/07, sergey kapustin <master.sergey at gmail.com> wrote:
>
> Thanks for the replay, Aitali but it doesn't work for me regardless the
> replication_strict.
> is it possible that 8.0 and 8.1 can't work properly together?
>
> On 6/8/07, aitali lahcen <aitali.lahcen at yahoo.fr> wrote:
> >
> > hi,
> > I think that you must do that:
> >
> > replication_strict = false,
> >
> > regards
> >
> > *sergey kapustin < master.sergey at gmail.com>* a écrit :
> >
> > Hello!
> > i'm running pgpool in replication mode on 2 machines:
> > 1 - gentoo, postgresql 8.0.4 (master)
> > 2 - debian, postgresql 8.1.8 (slave)
> >
> > ssl mode is set to off both on master and slave.
> >
> > below is my pgpool.conf and debug. Please help!
> > Thank you!
> >
> > listen_addresses = '*'
> > port = 9999
> > socket_dir = '/tmp'
> > backend_host_name = '192.168.1.254'
> > backend_port = 5432
> > backend_socket_dir = '/var/run/postgresql'
> > secondary_backend_host_name = '192.168.1.99'
> > secondary_backend_port = 5432
> > num_init_children = 32
> > max_pool = 4
> > child_life_time = 300
> > connection_life_time = 0
> > replication_mode = true
> > replication_strict = true
> >
> >
> > 2007-06-07 09:23:31 DEBUG: pid 18661: I am 18661 accept fd 6
> > 2007-06-07 09:23:31 DEBUG: pid 18661: Protocol Major: 1234 Minor: 5679
> > database:  user:
> > 2007-06-07 09:23:31 DEBUG: pid 18661: SSLRequest: sent N; retry startup
> > 2007-06-07 09:23:31 DEBUG: pid 18661: Protocol Major: 3 Minor: 0
> > database: msgs user: slony
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length: lenghth: 8
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> > lenghth: 30
> > 2007-06-07 09:23:31 DEBUG: pid 18661: name: client_encoding value:
> > SQL_ASCII
> > 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: client_encoding
> > value: SQL_ASCII
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> > lenghth: 23
> > 2007-06-07 09:23:31 DEBUG: pid 18661: name: DateStyle value: ISO, MDY
> > 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: DateStyle value:
> > ISO, MDY
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> > lenghth: 25
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: length does
> > not match between backends master(25) secondary(26)
> > 2007-06-07 09:23:31 DEBUG: pid 18661: name: integer_datetimes value: on
> > 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: integer_datetimes
> > value: off
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> > lenghth: 20
> > 2007-06-07 09:23:31 DEBUG: pid 18661: name: is_superuser value: on
> > 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: is_superuser
> > value: on
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> > lenghth: 30
> > 2007-06-07 09:23:31 DEBUG: pid 18661: name: server_encoding value:
> > SQL_ASCII
> > 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: server_encoding
> > value: SQL_ASCII
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> > lenghth: 25
> > 2007-06-07 09:23:31 DEBUG: pid 18661: name: server_version value: 8.1.8
> > 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: server_version
> > value: 8.0.4
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> > lenghth: 32
> > 2007-06-07 09:23:31 DEBUG: pid 18661: name: session_authorization value:
> > slony
> > 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name:
> > session_authorization value: slony
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: master
> > lenghth: 36
> > 2007-06-07 09:23:31 DEBUG: pid 18661: read_message_length2: length does
> > not match between backends master(36) secondary(17)
> > 2007-06-07 09:23:31 DEBUG: pid 18661: name: standard_conforming_strings
> > value: off
> > 2007-06-07 09:23:31 DEBUG: pid 18661: secondary name: TimeZone value:
> > GMT
> > 2007-06-07 09:23:31 ERROR: pid 18661: read_kind: kind does not match
> > between backends master(83) secondary(75)
> > 2007-06-07 09:23:31 ERROR: pid 18661: pool_do_auth: failed to read kind
> > while processing ParamterStatus
> >
> > _______________________________________________
> > Pgpool-general mailing list
> > Pgpool-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgpool-general
> >
> >
> > ------------------------------
> > Découvrez une nouvelle façon d'obtenir des réponses à toutes vos
> > questions ! Profitez des connaissances, des opinions et des expériences des
> > internautes sur Yahoo! Questions/Réponses<http://fr.rd.yahoo.com/evt=42054/*http://fr.answers.yahoo.com>
> > .
> >
> > ------------------------------
> > Stockage illimité de vos mails avec Yahoo! Mail. Changez aujourd'hui de
> > mail ! <http://fr.promotions.yahoo.com/mail/nouveau_yahoomail2.html>
> >
> >
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20070608/4a0c93c5/attachment.html 