[Pgpool-general] backend mismatch

Thu Jul 16 13:19:59 UTC 2009

Hi,

thanks for the answer. But unfortunately i get this error when simply 
trying to enter Postgres via PgAdmin.
So I've been away for a while, so what I have done today.
Configured postgresql to listen for 5433 port, and pgpool for 5432 
(attached postgresql.conf and pgpool.conf)

and when trying to launch simple command such as:
postgres at testlab /DB/bin $ ./createdb -p 5432 test

i get the following
2009-07-16 15:45:56 LOG: pid 4076: pgpool successfully started
2009-07-16 15:45:56 DEBUG: pid 4109: I am PCP 4109
2009-07-16 15:47:10 DEBUG: pid 4077: I am 4077 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4077: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4077: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4078: I am 4078 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4077: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4078: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4078: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4079: I am 4079 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4079: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4079: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4078: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4108: I am 4108 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4108: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4108: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4107: I am 4107 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4107: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4107: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4106: I am 4106 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4106: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4106: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4105: I am 4105 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4104: I am 4104 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4104: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4104: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4103: I am 4103 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4103: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4103: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4103: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4102: I am 4102 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4101: I am 4101 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4101: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4101: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4101: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4100: I am 4100 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4100: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4100: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4100: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4099: I am 4099 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4099: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4099: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4099: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4098: I am 4098 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4097: I am 4097 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4097: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4097: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4096: I am 4096 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4096: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4096: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4095: I am 4095 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4095: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4095: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4094: I am 4094 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4093: I am 4093 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4093: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4093: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4092: I am 4092 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4092: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4092: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4091: I am 4091 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4091: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4091: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4090: I am 4090 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4090: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4090: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4089: I am 4089 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4088: I am 4088 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4088: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4088: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4087: I am 4087 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4087: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4087: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4086: I am 4086 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4086: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4086: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4085: I am 4085 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4085: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4085: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4084: I am 4084 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4083: I am 4083 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4083: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4083: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4082: I am 4082 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4082: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4082: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4081: I am 4081 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4081: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4081: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4080: I am 4080 accept fd 5
2009-07-16 15:47:10 DEBUG: pid 4080: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4080: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4088: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4082: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4083: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4090: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4085: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4093: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4081: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4091: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4080: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4097: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4087: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4086: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4095: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4092: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4096: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4108: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4102: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4102: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4102: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4079: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4105: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4105: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4105: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4107: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4104: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4098: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4098: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4089: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4089: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4089: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4098: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4106: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4094: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4094: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4084: Protocol Major: 3 Minor: 0 
database: postgres user: postgres
2009-07-16 15:47:10 DEBUG: pid 4084: new_connection: connecting 0 backend
2009-07-16 15:47:10 DEBUG: pid 4084: new_connection: connecting 1 backend
2009-07-16 15:47:10 DEBUG: pid 4094: new_connection: connecting 1 backend

and system just hangs .. waits for smthn and no further information 
until i stop pgpool.

Tatsuo Ishii wrote:
>> i configured pgpool without much of a problem, and replication works 
>> fine (at least master/slave). But very often i get this error.
>>
>> 2009-07-02 15:26:27 ERROR: pid 3892: read_kind_from_backend: 1 th kind D 
>> does not match with master or majority connection kind C
>> 2009-07-02 15:26:27 ERROR: pid 3892: kind mismatch among backends. 
>> Possible last query was: "SET DateStyle=ISO;SELECT oid, 
>> pg_encoding_to_char(encoding) AS encoding, datlastsysoid
>> FROM pg_database WHERE oid = 24629" kind details are: 0[C] 1[D]
>>
>> maybe anyone has any ideas?
>> Both servers have freshly installed Gentoo Linux on them with 
>> Postgresql-8.3.4 and pgpool-II-2.2.2
>>     
>
> There are 2 possible reasons:
>
> - Multi statement(mulitple SQL statements conjuncted with ";") does
>   not work with pgpool-II.
>
> - Queries relying on OID does not work with pgpool-II.
>
> I thought these are stated in the doc as limitations of pgpool-II.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>   

-- 
Pagarbiai,

nSoft UAB
Konstantin Pakalenko
IT Administratorius
mob: +370 659 01025
kostas at nsoft.lt
http://www.nsoft.lt
P. Lukšio g. 16, vilnius
Lietuva 

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: pgpool.conf
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090716/3af2bfeb/attachment-0002.ksh>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: postgresql.conf
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090716/3af2bfeb/attachment-0003.ksh>