Repository navigation
primary_routing_query_pattern_list is appended instead of overwritten on reload #151
Description
Activity
Thank you for reporting the bug.
I was able to reproduce the issue, and I will take a look at it.Reacted by 0713seki-stackThank you for the update.
I'm glad to hear that you were able to reproduce it. Looking forward to the fix!- added 6 commits that reference this issue
on May 21, 2026
Metadata
Metadata
Assignees
Labels
No labels
Description:
In Pgpool-II 4.4.15, when updating primary_routing_query_pattern_list in pgpool.conf and executing systemctl reload (SIGHUP), the new patterns are appended to the existing list rather than replacing them.
Steps to reproduce:
Set primary_routing_query_pattern_list = 'SELECT 1' in pgpool.conf and start Pgpool-II.
Change it to primary_routing_query_pattern_list = 'SELECT 2' and execute pgpool reload.
Pgpool-II now holds both 'SELECT 1' and 'SELECT 2' in its internal list.
Impact:
Deleted or modified patterns remain active.
Memory consumption increases with every reload.
Duplicate patterns lead to redundant evaluation logic.
Environment:
Pgpool-II version: 4.4.15
OS: RHEL8.10