| From: | Koshino Taiki <koshino(at)sraoss(dot)co(dot)jp> |
|---|---|
| To: | JOSE MARIA Marin <jmmarint(at)gmail(dot)com>, "pgpool-general(at)lists(dot)postgresql(dot)org" <pgpool-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Bug report: Hardcoded debug logs "pi->node_ids" in pcp_child (v4.7.0) |
| Date: | 2026-04-07 08:55:38 |
| Message-ID: | TY4PR01MB1737497B2EB107A54E3CA545E945AA@TY4PR01MB17374.jpnprd01.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgpool-general |
Hi,
Thank you for the report.
This has already been fixed. The debug messages were incorrectly emitted at LOG level, and have been downgraded to DEBUG5.
The fix will be included in the 4.7.2 release.
The related commit is here:
https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=f647c4a372ea2c2cfae80e4e60f209e236fe41ec
Best regards,
Taiki Koshino<koshino(at)sraoss(dot)co(dot)jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/
________________________________
差出人: JOSE MARIA Marin <jmmarint(at)gmail(dot)com>
送信日時: 2026年4月6日 20:14
宛先: pgpool-general(at)lists(dot)postgresql(dot)org <pgpool-general(at)lists(dot)postgresql(dot)org>
件名: Bug report: Hardcoded debug logs "pi->node_ids" in pcp_child (v4.7.0)
Description: After upgrading to PgPool-II 4.7.0, the logs are being flooded with internal debug messages every time pcp_proc_info is executed.
Log Example: pcp_child pid XXXX: LOG: pi->node_ids[0]:1 pi->node_ids[1]:0. Repeats tens of times.
...
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:1 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:1 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
2026-04-06 11:11:03.367: psql pid 188: LOG: pi->node_ids[0]:3 pi->node_ids[1]:0
...
Steps to reproduce:
1. Run PgPool-II 4.7.0.
2. Execute pcp_proc_info.
3. Check the main PgPool log.
Current behavior: Even with log_min_messages = warning and log_pcp_messages = off, these messages persist. It seems like a hardcoded pool_log or fprintf in the source code of the PCP child handler.
Expected behavior: Internal structure debugging like pi->node_ids should only appear when debug_level is high or during development builds.
Environment:
* PgPool-II version: 4.7.0
* OS: Ubuntu (Docker)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Koshino Taiki | 2026-04-09 05:11:24 | Re: pgpool-II 4.4.16: Version mismatch between configure.ac and generated configure script |
| Previous Message | JOSE MARIA Marin | 2026-04-06 11:14:36 | Bug report: Hardcoded debug logs "pi->node_ids" in pcp_child (v4.7.0) |