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

[Luan Huynh]

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/a91bf000/attachment.html>