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

[AI Rumman]

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 <ishii at sraoss.co.jp> 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 <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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100520/4113309e/attachment-0001.html>