Thanks a lot. Now it is working fine. From application point I am not getting any error. But at Pgpool Log the following error is occured:
May 20 16:02:37 dev04 postgres[28063]: [8-2] STATEMENT: send invalid query from pgpool to abort transaction May 20 16:02:38 dev04 postgres[28063]: [9-1] ERROR: syntax error at or near "send" at character 1 May 20 16:02:38 dev04 postgres[28063]: [9-2] STATEMENT: send invalid query from pgpool to abort transaction May 20 16:02:38 dev04 postgres[28063]: [10-1] ERROR: syntax error at or near "send" at character 1 May 20 16:02:38 dev04 postgres[28063]: [10-2] STATEMENT: send invalid query from pgpool to abort transaction May 20 16:02:38 dev04 postgres[28063]: [11-1] ERROR: syntax error at or near "send" at character 1 May 20 16:02:38 dev04 postgres[28063]: [11-2] STATEMENT: send invalid query from pgpool to abort transaction May 20 16:02:38 dev04 postgres[28063]: [12-1] ERROR: syntax error at or near "send" at character 1 May 20 16:02:38 dev04 postgres[28063]: [12-2] STATEMENT: send invalid query from pgpool to abort transaction May 20 16:02:38 dev04 postgres[28063]: [13-1] ERROR: syntax error at or near "send" at character 1 Could you please tell me why ? On Tue, May 11, 2010 at 8:15 AM, Tatsuo Ishii <[email protected]> wrote: > 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
