[pgpool-hackers: 25] Re: [pgpool-II 0000002]: Client connection hangs in daemon mode

[Tatsuo Ishii]

Just for record, I forward.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

From: pgpool Bug Tracker <bugtracker at pgpool.net>
Subject: [pgpool-II 0000002]: Client connection hangs in daemon mode
Date: Mon, 6 Feb 2012 22:39:57 +0900
Message-ID: <6ef930a49690933c46bb3d3e3c88839d at www.pgpool.net>

> 
> The following issue has been SUBMITTED. 
> ====================================================================== 
> http://www.pgpool.net/mantisbt/view.php?id=2 
> ====================================================================== 
> Reported By:                tuomas
> Assigned To:                
> ====================================================================== 
> Project:                    pgpool-II
> Issue ID:                   2
> Category:                   Bug
> Reproducibility:            always
> Severity:                   major
> Priority:                   normal
> Status:                     new
> ====================================================================== 
> Date Submitted:             2012-02-06 22:39 JST
> Last Modified:              2012-02-06 22:39 JST
> ====================================================================== 
> Summary:                    Client connection hangs in daemon mode
> Description: 
> The issues happens at least with md5 pool authentication enabled
> 
> pgpool version 3.1.2
> postgresql 9.1
> 
> pg_hba.conf:
> host    all             all             0.0.0.0/0               md5
> 
> pool_hba.conf:
> host    all             all             0.0.0.0/0               md5
> 
> pgpool.conf:
> streaming master-slave configuration is used. ssl = off in pgpool and server.
> enable_pool_hba = on
> authentication_timeout = 5
> 
> user/password pair generated by pg_md5 is in pool_passwd.
> 
> when trying to connect to pgpool, by i.e.
> $ psql --host=127.0.0.1 --user=username -d template1
> 
> The "pgpool: accept connection" and the psql process just hang up forever.
> Nothing happens, no errors in pgpool or stdout/err.
> 
> In postgresql server log is an error:
> 2012-02-06 13:15:38.636 UTC LOG:  connection received: host=10.x.x.x port=45207
> 2012-02-06 13:15:38.639 UTC LOG:  could not receive data from client: Connection
> reset by peer
> 2012-02-06 13:15:38.639 UTC LOG:  unexpected EOF within message length word
> 
> In debug mode I get the following to syslog:
> Feb  6 13:33:57 qa01 pgpool[18845]: I am 18845 accept fd 6
> Feb  6 13:33:57 qa01 pgpool[18845]: connection received: host=localhost
> port=46606
> Feb  6 13:33:57 qa01 pgpool[18845]: Protocol Major: 1234 Minor: 5679 database: 
> user:
> Feb  6 13:33:57 qa01 pgpool[18845]: SSLRequest from client
> Feb  6 13:33:57 qa01 pgpool[18845]: pool_ssl: SSL requested but SSL support is
> not available
> Feb  6 13:33:57 qa01 pgpool[18845]: read_startup_packet: application_name: psql
> Feb  6 13:33:57 qa01 pgpool[18845]: Protocol Major: 3 Minor: 0 database: yyy
> user: xxx
> 
> Nothing after that.
> 
> Strangely enough, everything seem to work fine if i run pgpool in foreground
> mode with -n.
> 
> 
> 
> 
> ====================================================================== 
> 
> Issue History 
> Date Modified    Username       Field                    Change               
> ====================================================================== 
> 2012-02-06 22:39 tuomas         New Issue                                    
> ======================================================================
>