[Pgpool-general] Fwd: PGPOOL II 2.3.3 hang in ssl mode

[Tatsuo Ishii]

Sean,

It seems the problem only occurs when SSL between pgpool-II and
PostgreSQL enabled. Also it seems that whatever SELECT query which
returns non trivial amount of rows hangs.

Any idea why the problem occurs? Running pgpool-II with debug mode
shows that pgpool-II hangs here:

2010-05-11 09:49:50 DEBUG: pid 2460: pool_process_query: kind from backend: D
2010-05-11 09:49:50 DEBUG: pid 2460: read_kind_from_backend: read kind from 0 th backend D NUM_BACKENDS: 1
2010-05-11 09:49:50 DEBUG: pid 2460: pool_process_query: kind from backend: D
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


> Addition to the above, I found that,
> 
> When I use the following query it works :
> 
> SELECT d.datname as "Name",
>        r.rolname as "Owner",
>        d.encoding as "Encoding"
> FROM pg_catalog.pg_database d
>   JOIN pg_catalog.pg_roles r ON d.datdba = r.oid
> ORDER BY 1
> 
> But the following query does not work:
> 
> SELECT d.datname as "Name",
>        r.rolname as "Owner",
>        pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
> FROM pg_catalog.pg_database d
>   JOIN pg_catalog.pg_roles r ON d.datdba = r.oid
> ORDER BY 1
> 
> The function call "pg_catalog.pg_encoding_to_char(d.encoding)" somehow makes
> the Pgpool hang in SSL mode.
> 
> ---------- Forwarded message ----------
> From: AI Rumman <rummandba at gmail.com>
> Date: Sun, May 9, 2010 at 12:06 PM
> Subject: PGPOOL II 2.3.3 hang in ssl mode
> To: pgpool-general at pgfoundry.org
> 
> 
> I am using Pgpool II 2.3.3 with Postgresql 8.3.8.
> 
> When I use command \l at postgresql client the query is working perfectly.
> 
> But if I used the command from pgpool II client which is connected with
> postgresql in ssl mode, it gets hang.
> 
> Again if I use the command from pgpool II client in non-ssl mode, it works
> fine.
> 
> Any help please.