Thanks once again for the update. -----Original Message----- From: Tatsuo Ishii [mailto:[email protected]] Sent: Tuesday, August 24, 2010 2:50 PM To: [email protected] Cc: [email protected] Subject: Re: [Pgpool-general] SQL statements not printed in pgpool log
> 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-E XT-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:[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
