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? 2. What is an "extended query" concept in database? Any pointers to relevant articles, documentation, etc. are also appreciated. Regards, Gnanam -----Original Message----- From: Tatsuo Ishii [mailto:[email protected]] Sent: Tuesday, August 24, 2010 1:54 PM To: [email protected] Cc: [email protected] Subject: Re: [Pgpool-general] SQL statements not printed in pgpool log > Any ideas/suggestions? > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Gnanakumar > Sent: Tuesday, August 10, 2010 5:55 PM > To: [email protected] > 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
