agora inbox for pgpool-committers@postgresql.orghelp / color / mirror / Atom feed
pgpool: Fix query cache lock file handling. 4+ messages / 1 participants [nested] [flat]
* pgpool: Fix query cache lock file handling. @ 2025-09-04 08:11 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 4+ messages in thread From: Tatsuo Ishii @ 2025-09-04 08:11 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix query cache lock file handling. Query cache module creates a lock file under logdir for concurrency control. However, there were bugs in the handling: 1) Garbage file "QUERY_CACHE_LOCK_FILE" was created by pgpool main process. 2) The lock file was not removed upon pgpool shutdown. This commit fixes the bugs. Author: Tatsuo Ishii <ishii@postgresql.org> Reported-by: Bo Peng <pengbo@sraoss.co.jp> Reviewed-by: Bo Peng <pengbo@sraoss.co.jp> Backpatch-through: v4.4 Branch ------ V4_4_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=a03106cea5632f06e595de0760d1131fab1ca... Modified Files -------------- src/main/pgpool_main.c | 23 +++++++++++++---------- 1 file changed, 13 insertions(+), 10 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgpool: Fix query cache lock file handling. @ 2025-09-04 08:11 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 4+ messages in thread From: Tatsuo Ishii @ 2025-09-04 08:11 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix query cache lock file handling. Query cache module creates a lock file under logdir for concurrency control. However, there were bugs in the handling: 1) Garbage file "QUERY_CACHE_LOCK_FILE" was created by pgpool main process. 2) The lock file was not removed upon pgpool shutdown. This commit fixes the bugs. Author: Tatsuo Ishii <ishii@postgresql.org> Reported-by: Bo Peng <pengbo@sraoss.co.jp> Reviewed-by: Bo Peng <pengbo@sraoss.co.jp> Backpatch-through: v4.4 Branch ------ V4_5_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=1f29d3b37f7b3a94852718694c6143dc35d38... Modified Files -------------- src/main/pgpool_main.c | 23 +++++++++++++---------- 1 file changed, 13 insertions(+), 10 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgpool: Fix query cache lock file handling. @ 2025-09-04 08:12 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 4+ messages in thread From: Tatsuo Ishii @ 2025-09-04 08:12 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix query cache lock file handling. Query cache module creates a lock file under logdir for concurrency control. However, there were bugs in the handling: 1) Garbage file "QUERY_CACHE_LOCK_FILE" was created by pgpool main process. 2) The lock file was not removed upon pgpool shutdown. This commit fixes the bugs. Author: Tatsuo Ishii <ishii@postgresql.org> Reported-by: Bo Peng <pengbo@sraoss.co.jp> Reviewed-by: Bo Peng <pengbo@sraoss.co.jp> Backpatch-through: v4.4 Branch ------ V4_6_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=9e03245757ce4fb638fc674da8025c0a33659... Modified Files -------------- src/main/pgpool_main.c | 23 +++++++++++++---------- 1 file changed, 13 insertions(+), 10 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgpool: Fix query cache lock file handling. @ 2025-09-04 08:12 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 4+ messages in thread From: Tatsuo Ishii @ 2025-09-04 08:12 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix query cache lock file handling. Query cache module creates a lock file under logdir for concurrency control. However, there were bugs in the handling: 1) Garbage file "QUERY_CACHE_LOCK_FILE" was created by pgpool main process. 2) The lock file was not removed upon pgpool shutdown. This commit fixes the bugs. Author: Tatsuo Ishii <ishii@postgresql.org> Reported-by: Bo Peng <pengbo@sraoss.co.jp> Reviewed-by: Bo Peng <pengbo@sraoss.co.jp> Backpatch-through: v4.4 Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=09cd631edb0f962403a503ff02bdbea739de4... Modified Files -------------- src/main/pgpool_main.c | 22 ++++++++++++++-------- 1 file changed, 14 insertions(+), 8 deletions(-) ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-09-04 08:12 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-09-04 08:11 pgpool: Fix query cache lock file handling. Tatsuo Ishii <ishii@postgresql.org> 2025-09-04 08:11 pgpool: Fix query cache lock file handling. Tatsuo Ishii <ishii@postgresql.org> 2025-09-04 08:12 pgpool: Fix query cache lock file handling. Tatsuo Ishii <ishii@postgresql.org> 2025-09-04 08:12 pgpool: Fix query cache lock file handling. Tatsuo Ishii <ishii@postgresql.org>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox