[pgpool-general: 3499] Re: ERROR: unable to read message length

[Luan Huynh]

I am sorry about information above, I will provide more:
+ machine 1 on google cloud compute (GGC): centos x64 , instaled postgres
plus advanced server 9.3  , installed pgpool II 3.4
+ machine 2 on local : rhel x64, instaled postgres plus advanced server 9.3

GGC  ---------------------------------------------- Local
    |                                                      |
    |                                                      |
pgpool                                                 ppas 9.3
    |
    |
ppas 9.3














On Fri, Mar 6, 2015 at 12:21 AM, Luan Huynh <onlinegvn9x at gmail.com> wrote:

> I changed both machine type to  "rhel 6 x 64 "and configured pgpool for
> two servers but It still error.
> When I start pgpool, in log file, I just see it find primary in node id =
> 0 without node = 1. Until I run "psql -h localhost -p 9999 -d postgres" ,
> it raise error (if I just start pgpool , the log will show as below).
>
> 2015-03-05 16:22:52: pid 30045: LOG: Setting up socket for 0.0.0.0:9999
> 2015-03-05 16:22:52: pid 30045: LOG: Setting up socket for :::9999
> 2015-03-05 16:22:52: pid 30045: LOG: pgpool-II successfully started.
> version 3.4.0 (tataraboshi)
> 2015-03-05 16:22:52: pid 30045: LOG: find_primary_node: checking backend
> no 0
> 2015-03-05 16:22:52: pid 30045: LOG: find_primary_node: primary node id is
> 0
>
>
> Here pgpool log when I debug:
>
> 2015-03-05 16:44:35: pid 30758: LOG: find_primary_node: primary node id is
> 0
> 2015-03-05 16:44:45: pid 30790: DEBUG: I am 30790 accept fd 6
> 2015-03-05 16:44:45: pid 30790: DEBUG: reading startup packet
> 2015-03-05 16:44:45: pid 30790: DETAIL: Protocol Major: 1234 Minor: 5679
> database: user:
> 2015-03-05 16:44:45: pid 30790: DEBUG: selecting backend connection
> 2015-03-05 16:44:45: pid 30790: DETAIL: SSLRequest from client
> 2015-03-05 16:44:45: pid 30790: DEBUG: reading startup packet
> 2015-03-05 16:44:45: pid 30790: DETAIL: application_name: psql
> 2015-03-05 16:44:45: pid 30790: DEBUG: reading startup packet
> 2015-03-05 16:44:45: pid 30790: DETAIL: Protocol Major: 3 Minor: 0
> database: postgres user: enterprisedb
> 2015-03-05 16:44:45: pid 30790: DEBUG: creating new connection to backend
> 2015-03-05 16:44:45: pid 30790: DETAIL: connecting 0 backend
> 2015-03-05 16:44:45: pid 30790: DEBUG: creating new connection to backend
> 2015-03-05 16:44:45: pid 30790: DETAIL: connecting 1 backend
> 2015-03-05 16:44:45: pid 30790: DEBUG: reading message length
> 2015-03-05 16:44:45: pid 30790: DETAIL: slot: 0 length: 12
> 2015-03-05 16:44:45: pid 30790: DEBUG: reading message length
> 2015-03-05 16:44:45: pid 30790: DETAIL: slot: 1 length: 8
> 2015-03-05 16:44:45: pid 30790: ERROR: unable to read message length
> 2015-03-05 16:44:45: pid 30790: DETAIL: message length (8) in slot 1 does
> not match with slot 0(12)
>
> On Thu, Mar 5, 2015 at 5:43 PM, Luan Huynh <onlinegvn9x at gmail.com> wrote:
>
>> Hi all ,
>>
>> I am newbie in pgpool II 3.4.1
>>
>> My configuration:
>> + master machine : centos 6 x64, postgresql 9.3, pgpool II 3.4.1
>> + slave machine : redhat 6 x64 , postgresql 9.3
>> + master-slave is configured streaming replication together
>> + ssh between master - slave is ok .
>>
>> After starting pgpool  and try connect to database via port 9999, I get
>> log:
>>
>> 2015-03-05 09:43:35: pid 6821: LOG:  Setting up socket for 0.0.0.0:9999
>> 2015-03-05 09:43:35: pid 6821: LOG:  Setting up socket for :::9999
>> 2015-03-05 09:43:35: pid 6821: LOG:  pgpool-II successfully started.
>> version 3.4.0 (tataraboshi)
>> 2015-03-05 09:43:35: pid 6821: LOG:  find_primary_node: checking backend
>> no 0
>>
>> 2015-03-05 09:43:35: pid 6821: LOG:  find_primary_node: primary node id
>> is 0
>> 2015-03-05 09:45:49: pid 6853: LOG:  new connection received
>> 2015-03-05 09:45:49: pid 6853: DETAIL:  connecting host=::1 port=43040
>> 2015-03-05 09:45:49: pid 6853: ERROR:  unable to read message length
>> 2015-03-05 09:45:49: pid 6853: DETAIL:  message length (8) in slot 1 does
>> not match with slot 0(12)
>> 2015-03-05 09:48:41: pid 6852: LOG:  new connection received
>> 2015-03-05 09:48:41: pid 6852: DETAIL:  connecting host=::1 port=43061
>> 2015-03-05 09:48:41: pid 6852: ERROR:  unable to read message length
>> 2015-03-05 09:48:41: pid 6852: DETAIL:  message length (8) in slot 1 does
>> not match with slot 0(12)
>> 2015-03-05 09:51:01: pid 6853: LOG:  new connection received
>> 2015-03-05 09:51:01: pid 6853: DETAIL:  connecting host=::1 port=43078
>> 2015-03-05 09:51:02: pid 6853: ERROR:  unable to read message length
>> 2015-03-05 09:51:02: pid 6853: DETAIL:  message length (8) in slot 1 does
>> not match with slot 0(12)
>> 2015-03-05 09:51:05: pid 6853: LOG:  new connection received
>> 2015-03-05 09:51:05: pid 6853: DETAIL:  connecting host=::1 port=43084
>> 2015-03-05 09:51:05: pid 6853: ERROR:  unable to read message length
>> 2015-03-05 09:51:05: pid 6853: DETAIL:  message length (8) in slot 1 does
>> not match with slot 0(12)
>>
>> I search on google and found website
>> http://code.metager.de/source/xref/postgresql/pgpool2/src/auth/pool_auth.c
>> to show code but I do not know clearly my problems. Please give me some
>> solutions or point me what I am wrong  .
>>
>>
>> Thanks .
>>
>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150306/eede68fd/attachment.html>