[Pgpool-general] SQL statements not printed in pgpool log

[Tatsuo Ishii]

> Hi Tatsuo,
> 
> Thanks, that solved my long-time problem.  It's working now and am able to
> see the SQL statements printing in the pgpool log.
> 
> I've couple of questions in this regard:
> 1. Is it fixed by default in the new releases of pgpool-II or again I need
> to patch this on top of the installation, if I would like to continue with
> my JDBC 4 driver?

Yes, the fix is in the newer version of pgpool-II.

> 2. What is an "extended query" concept in database? Any pointers to relevant
> articles, documentation, etc. are also appreciated.

It appears in PostgreSQL manual. See:
http://www.postgresql.org/docs/8.4/static/protocol-flow.html#PROTOCOL-FLOW-EXT-QUERY
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Regards,
> Gnanam
> 
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp] 
> Sent: Tuesday, August 24, 2010 1:54 PM
> To: gnanam at zoniac.com
> Cc: pgpool-general at pgfoundry.org
> Subject: Re: [Pgpool-general] SQL statements not printed in pgpool log
> 
> > Any ideas/suggestions?
> > 
> > -----Original Message-----
> > From: pgpool-general-bounces at pgfoundry.org
> > [mailto:pgpool-general-bounces at pgfoundry.org] On Behalf Of Gnanakumar
> > Sent: Tuesday, August 10, 2010 5:55 PM
> > To: pgpool-general at pgfoundry.org
> > Subject: [Pgpool-general] SQL statements not printed in pgpool log
> > 
> > Hi,
> > 
> > Our production server is running PostgreSQL 8.2.3 and pgpool-II-2.0.1.
> > Recently, we upgraded our JDBC driver 2 to JDBC driver 4.
> > After changing JDBC driver, I'm not able to see none of the SQL statements
> > printed in pgpool log.  What's going wrong?
> > Instead of SQL statements, I can see only the following lines:
> > 
> > 2010-08-09 20:22:20 LOG: pid 20794: YYYYY
> > 2010-08-09 20:22:20 LOG: pid 20794: YYYYY
> > 2010-08-09 20:22:20 LOG: pid 20794: YYYYY
> > 
> > If I use JDBC driver 2, I don't have this problem.
> > 
> > How do I fix this issue, so that SQL statements are also printed in the
> log.
> 
> 2.0.1 is pretty old and my memory about it had almost gone:-)
> Anyway...
> 
> > 2010-08-09 20:22:20 LOG: pid 20794: YYYYY
> 
> This is a debug statement and someone forgot to remove it. You can
> safely remove this by changing following (line 3898 in
> pool_process_query.c)
> 
> 		pool_log("YYYYY");
> to
> 		pool_debug("YYYYY");
> 
> Next. The reason why you do not see the statement log is, JDBC 4 uses
> "extended query" which is totaly different method from JDBC 2
> uses. Pgpool-II 2.0.1 was not able to log the statement of the
> extended query. Fix will be simple though I have not tested it:
> 
> Insert followins after line 1586 of pool_process_query.c:
> 
> 	if (pool_config->log_statement)
> 	{
> 		pool_log("statement: %s", stmt);
> 	}
> 
> Hope this helps,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp