View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000360 | Pgpool-II | Bug | public | 2017-10-31 12:29 | 2017-12-08 11:36 |
| Reporter | tom-sato | Assigned To | t-ishii | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | Linux | OS | CentOS | OS Version | 7.2 |
| Product Version | 3.6.6 | ||||
| Summary | 0000360: log_statement does not work with extended protocol | ||||
| Description | Even if log_statement is set to on, SQL executed by extended protocol will not be output to Pgpool log file. | ||||
| Steps To Reproduce | $ pgpool_setup $ echo -e "log_per_node_statement = off\nlog_statement = on" >> etc/pgpool.conf $ ./startall $ pgbench -p 11000 -i test $ pgbench -p 11000 -M extended test $ grep "SELECT abalance FROM pgbench_accounts" log/pgpool.log data*/pg_log/*.log data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; $ pgbench -p 11000 -M simple test $ grep "SELECT abalance FROM pgbench_accounts" log/pgpool.log data*/pg_log/*.log log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 57816; log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 57551; log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 94487; log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 99149; log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 29298; log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 57916; log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 97965; log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 73630; log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 56011; log/pgpool.log:2017-10-31 12:27:04: pid 27683: LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 52532; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:27798 2017-10-31 12:23:23 JST LOG: execute <unnamed>: SELECT abalance FROM pgbench_accounts WHERE aid = $1; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 57816; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 57551; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 94487; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 99149; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 29298; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 57916; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 97965; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 73630; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 56011; data0/pg_log/Tuesday.log:28001 2017-10-31 12:27:04 JST LOG: statement: SELECT abalance FROM pgbench_accounts WHERE aid = 52532; | ||||
| Tags | pgpool, settings | ||||
|
|
By the way log_per_node_statement works correctly. |
|
|
This is a known limitation since log_statement was implemented. Since log_per_node_statement is much more useful, it is recommended to use it. Do you have particular reasons why log_statement is more useful? |
|
|
No response since 2017/11/9. Issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-10-31 12:29 | tom-sato | New Issue | |
| 2017-10-31 12:29 | tom-sato | Tag Attached: pgpool | |
| 2017-10-31 12:29 | tom-sato | Tag Attached: settings | |
| 2017-10-31 12:37 | tom-sato | Note Added: 0001793 | |
| 2017-11-09 13:05 | t-ishii | Note Added: 0001815 | |
| 2017-11-09 13:06 | t-ishii | Assigned To | => t-ishii |
| 2017-11-09 13:06 | t-ishii | Status | new => feedback |
| 2017-12-08 11:35 | t-ishii | Note Added: 0001852 | |
| 2017-12-08 11:36 | t-ishii | Status | feedback => closed |
