public inbox for [email protected]help / color / mirror / Atom feed
pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). 6+ messages / 1 participants [nested] [flat]
* pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). @ 2026-05-25 22:16 Tom Lane <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Tom Lane @ 2026-05-25 22:16 UTC (permalink / raw) To: [email protected] Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Given a WHERE clause like "int[] @@ query_int" or "query_int ~~ int[]" where the query_int side is a table column having statistics, _int_matchsel() exited without remembering to free the statistics tuple. This would typically lead to warnings about cache refcount leakage, like WARNING: resource was not closed: cache pg_statistic (73), tuple 42/12 has count 1 It's been wrong since this code was added, in commit c6fbe6d6f. Bug: #19492 Reported-by: Man Zeng <[email protected]> Author: Man Zeng <[email protected]> Reviewed-by: Tom Lane <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 14 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/524cc0f638745489f55bafa12f3f93fe8944e027 Modified Files -------------- contrib/intarray/_int_selfuncs.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). @ 2026-05-25 22:16 Tom Lane <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Tom Lane @ 2026-05-25 22:16 UTC (permalink / raw) To: [email protected] Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Given a WHERE clause like "int[] @@ query_int" or "query_int ~~ int[]" where the query_int side is a table column having statistics, _int_matchsel() exited without remembering to free the statistics tuple. This would typically lead to warnings about cache refcount leakage, like WARNING: resource was not closed: cache pg_statistic (73), tuple 42/12 has count 1 It's been wrong since this code was added, in commit c6fbe6d6f. Bug: #19492 Reported-by: Man Zeng <[email protected]> Author: Man Zeng <[email protected]> Reviewed-by: Tom Lane <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 14 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/e7544c518ab0943fc85e2a4b44df9f7561ad2d0c Modified Files -------------- contrib/intarray/_int_selfuncs.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). @ 2026-05-25 22:16 Tom Lane <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Tom Lane @ 2026-05-25 22:16 UTC (permalink / raw) To: [email protected] Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Given a WHERE clause like "int[] @@ query_int" or "query_int ~~ int[]" where the query_int side is a table column having statistics, _int_matchsel() exited without remembering to free the statistics tuple. This would typically lead to warnings about cache refcount leakage, like WARNING: resource was not closed: cache pg_statistic (73), tuple 42/12 has count 1 It's been wrong since this code was added, in commit c6fbe6d6f. Bug: #19492 Reported-by: Man Zeng <[email protected]> Author: Man Zeng <[email protected]> Reviewed-by: Tom Lane <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 14 Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/94b57ab54a0ed4b4fcc8ee0bb5860461b926bbb7 Modified Files -------------- contrib/intarray/_int_selfuncs.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). @ 2026-05-25 22:16 Tom Lane <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Tom Lane @ 2026-05-25 22:16 UTC (permalink / raw) To: [email protected] Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Given a WHERE clause like "int[] @@ query_int" or "query_int ~~ int[]" where the query_int side is a table column having statistics, _int_matchsel() exited without remembering to free the statistics tuple. This would typically lead to warnings about cache refcount leakage, like WARNING: resource was not closed: cache pg_statistic (73), tuple 42/12 has count 1 It's been wrong since this code was added, in commit c6fbe6d6f. Bug: #19492 Reported-by: Man Zeng <[email protected]> Author: Man Zeng <[email protected]> Reviewed-by: Tom Lane <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/273be484aadd03b8f8d45dd3aa6768ab4512d702 Modified Files -------------- contrib/intarray/_int_selfuncs.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). @ 2026-05-25 22:16 Tom Lane <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Tom Lane @ 2026-05-25 22:16 UTC (permalink / raw) To: [email protected] Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Given a WHERE clause like "int[] @@ query_int" or "query_int ~~ int[]" where the query_int side is a table column having statistics, _int_matchsel() exited without remembering to free the statistics tuple. This would typically lead to warnings about cache refcount leakage, like WARNING: resource was not closed: cache pg_statistic (73), tuple 42/12 has count 1 It's been wrong since this code was added, in commit c6fbe6d6f. Bug: #19492 Reported-by: Man Zeng <[email protected]> Author: Man Zeng <[email protected]> Reviewed-by: Tom Lane <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 14 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/702a6d5f634860fb9e5efc5504cf95ad3b398206 Modified Files -------------- contrib/intarray/_int_selfuncs.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). @ 2026-05-25 22:16 Tom Lane <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Tom Lane @ 2026-05-25 22:16 UTC (permalink / raw) To: [email protected] Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Given a WHERE clause like "int[] @@ query_int" or "query_int ~~ int[]" where the query_int side is a table column having statistics, _int_matchsel() exited without remembering to free the statistics tuple. This would typically lead to warnings about cache refcount leakage, like WARNING: resource was not closed: cache pg_statistic (73), tuple 42/12 has count 1 It's been wrong since this code was added, in commit c6fbe6d6f. Bug: #19492 Reported-by: Man Zeng <[email protected]> Author: Man Zeng <[email protected]> Reviewed-by: Tom Lane <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 14 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/a96b051a98e346fe03f5fb27f21b539842295745 Modified Files -------------- contrib/intarray/_int_selfuncs.c | 3 +++ 1 file changed, 3 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2026-05-25 22:16 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-05-25 22:16 pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Tom Lane <[email protected]> 2026-05-25 22:16 pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Tom Lane <[email protected]> 2026-05-25 22:16 pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Tom Lane <[email protected]> 2026-05-25 22:16 pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Tom Lane <[email protected]> 2026-05-25 22:16 pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Tom Lane <[email protected]> 2026-05-25 22:16 pgsql: Fix missed ReleaseVariableStats() in intarray's _int_matchsel(). Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox