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 <[email protected]> > Date: Sun, May 9, 2010 at 12:06 PM > Subject: PGPOOL II 2.3.3 hang in ssl mode > To: [email protected] > > > 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. _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
