pg.ddx.io pgpool-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS 6+ messages / 1 participants [nested] [flat]
* pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS @ 2026-10-21 02:13 Taiki Koshino <koshino@sraoss.co.jp> 0 siblings, 0 replies; 6+ messages in thread From: Taiki Koshino @ 2026-10-21 02:13 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix extended-protocol DISCARD ALL and statement reuse after DISCARD PLANS. DISCARD ALL cleared the sent message list before CommandComplete() finished using the current query context, causing a "no query context" error and closing the frontend connection. Defer cleanup until the context is no longer needed. DISCARD PLANS also removed saved Query and Parse messages, although PostgreSQL preserves prepared statements. Keep these records so that subsequent Bind messages can reuse the statements without another Parse. Author: Taiki Koshino(koshino@sraoss.co.jp) Discussion: https://github.com/pgpool/pgpool2/issues/175 Backpatch-through: v4.3 Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=3462d5e6ee12ca5fc58d446ecd62b54ac112e... Modified Files -------------- src/protocol/CommandComplete.c | 29 +++++++++++++++-------------- 1 file changed, 15 insertions(+), 14 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS @ 2026-10-21 02:14 Taiki Koshino <koshino@sraoss.co.jp> 0 siblings, 0 replies; 6+ messages in thread From: Taiki Koshino @ 2026-10-21 02:14 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix extended-protocol DISCARD ALL and statement reuse after DISCARD PLANS. DISCARD ALL cleared the sent message list before CommandComplete() finished using the current query context, causing a "no query context" error and closing the frontend connection. Defer cleanup until the context is no longer needed. DISCARD PLANS also removed saved Query and Parse messages, although PostgreSQL preserves prepared statements. Keep these records so that subsequent Bind messages can reuse the statements without another Parse. Author: Taiki Koshino(koshino@sraoss.co.jp) Discussion: https://github.com/pgpool/pgpool2/issues/175 Backpatch-through: v4.3 Branch ------ V4_7_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=56e29a9c0ade90d0dd17334da0e97fcfb3eb0... Modified Files -------------- src/protocol/CommandComplete.c | 29 +++++++++++++++-------------- 1 file changed, 15 insertions(+), 14 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS @ 2026-10-21 02:15 Taiki Koshino <koshino@sraoss.co.jp> 0 siblings, 0 replies; 6+ messages in thread From: Taiki Koshino @ 2026-10-21 02:15 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix extended-protocol DISCARD ALL and statement reuse after DISCARD PLANS. DISCARD ALL cleared the sent message list before CommandComplete() finished using the current query context, causing a "no query context" error and closing the frontend connection. Defer cleanup until the context is no longer needed. DISCARD PLANS also removed saved Query and Parse messages, although PostgreSQL preserves prepared statements. Keep these records so that subsequent Bind messages can reuse the statements without another Parse. Author: Taiki Koshino(koshino@sraoss.co.jp) Discussion: https://github.com/pgpool/pgpool2/issues/175 Backpatch-through: v4.3 Branch ------ V4_6_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=d6f15abd5b053be2ae36e3a0d8197d03454ae... Modified Files -------------- src/protocol/CommandComplete.c | 29 +++++++++++++++-------------- 1 file changed, 15 insertions(+), 14 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS @ 2026-10-21 02:16 Taiki Koshino <koshino@sraoss.co.jp> 0 siblings, 0 replies; 6+ messages in thread From: Taiki Koshino @ 2026-10-21 02:16 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix extended-protocol DISCARD ALL and statement reuse after DISCARD PLANS. DISCARD ALL cleared the sent message list before CommandComplete() finished using the current query context, causing a "no query context" error and closing the frontend connection. Defer cleanup until the context is no longer needed. DISCARD PLANS also removed saved Query and Parse messages, although PostgreSQL preserves prepared statements. Keep these records so that subsequent Bind messages can reuse the statements without another Parse. Author: Taiki Koshino(koshino@sraoss.co.jp) Discussion: https://github.com/pgpool/pgpool2/issues/175 Backpatch-through: v4.3 Branch ------ V4_5_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=a4217268bd0c3567c1002b60fdbf7d1537844... Modified Files -------------- src/protocol/CommandComplete.c | 29 +++++++++++++++-------------- 1 file changed, 15 insertions(+), 14 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS @ 2026-10-21 02:16 Taiki Koshino <koshino@sraoss.co.jp> 0 siblings, 0 replies; 6+ messages in thread From: Taiki Koshino @ 2026-10-21 02:16 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix extended-protocol DISCARD ALL and statement reuse after DISCARD PLANS. DISCARD ALL cleared the sent message list before CommandComplete() finished using the current query context, causing a "no query context" error and closing the frontend connection. Defer cleanup until the context is no longer needed. DISCARD PLANS also removed saved Query and Parse messages, although PostgreSQL preserves prepared statements. Keep these records so that subsequent Bind messages can reuse the statements without another Parse. Author: Taiki Koshino(koshino@sraoss.co.jp) Discussion: https://github.com/pgpool/pgpool2/issues/175 Backpatch-through: v4.3 Branch ------ V4_4_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=4608d80ddf8dac6e80281b01b7cff05b0d7b6... Modified Files -------------- src/protocol/CommandComplete.c | 29 +++++++++++++++-------------- 1 file changed, 15 insertions(+), 14 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS @ 2026-10-21 02:17 Taiki Koshino <koshino@sraoss.co.jp> 0 siblings, 0 replies; 6+ messages in thread From: Taiki Koshino @ 2026-10-21 02:17 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org Fix extended-protocol DISCARD ALL and statement reuse after DISCARD PLANS. DISCARD ALL cleared the sent message list before CommandComplete() finished using the current query context, causing a "no query context" error and closing the frontend connection. Defer cleanup until the context is no longer needed. DISCARD PLANS also removed saved Query and Parse messages, although PostgreSQL preserves prepared statements. Keep these records so that subsequent Bind messages can reuse the statements without another Parse. Author: Taiki Koshino(koshino@sraoss.co.jp) Discussion: https://github.com/pgpool/pgpool2/issues/175 Backpatch-through: v4.3 Branch ------ V4_3_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=afa3cfe47918432ea9723c4976526d66a9289... Modified Files -------------- src/protocol/CommandComplete.c | 29 +++++++++++++++-------------- 1 file changed, 15 insertions(+), 14 deletions(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2026-10-21 02:17 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-10-21 02:13 pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS Taiki Koshino <koshino@sraoss.co.jp> 2026-10-21 02:14 pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS Taiki Koshino <koshino@sraoss.co.jp> 2026-10-21 02:15 pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS Taiki Koshino <koshino@sraoss.co.jp> 2026-10-21 02:16 pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS Taiki Koshino <koshino@sraoss.co.jp> 2026-10-21 02:16 pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS Taiki Koshino <koshino@sraoss.co.jp> 2026-10-21 02:17 pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS Taiki Koshino <koshino@sraoss.co.jp>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox