pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #18229: Multiple vacuum queries fail after upgrading to 13.10 2+ messages / 2 participants [nested] [flat]
* BUG #18229: Multiple vacuum queries fail after upgrading to 13.10 @ 2023-12-05 14:22 PG Bug reporting form <noreply@postgresql.org> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2023-12-05 14:22 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: ganeshpandi.eswaran@chainsys.com The following bug has been logged on the website: Bug reference: 18229 Logged by: Ganeshpandi Eswaran Email address: ganeshpandi.eswaran@chainsys.com PostgreSQL version: 13.10 Operating system: linux Description: We are encountering query execution issues on Postgres versions 13.10 to 16. When we execute numerous vacuum queries with in-application and auto-commit set to false, we receive the following error. Error: VACUUM cannot be performed within a pipeline. The problem appears only after 13.10; previous to 13.09, the same set of queries runs flawlessly. Could you kindly provide any information you have regarding other people who are having similar issues, as well as any other solutions? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18229: Multiple vacuum queries fail after upgrading to 13.10 @ 2023-12-05 15:26 Tom Lane <tgl@sss.pgh.pa.us> parent: PG Bug reporting form <noreply@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2023-12-05 15:26 UTC (permalink / raw) To: ganeshpandi.eswaran@chainsys.com; +Cc: pgsql-bugs@lists.postgresql.org PG Bug reporting form <noreply@postgresql.org> writes: > We are encountering query execution issues on Postgres versions 13.10 to 16. > When we execute numerous vacuum queries with in-application and auto-commit > set to false, we receive the following error. > Error: VACUUM cannot be performed within a pipeline. You've provided no context about how you're invoking VACUUM, but this error message suggests that you're doing so in a way that causes it to be run as part of a multi-command transaction. That's always been disallowed in theory, but the enforcement was incomplete up until our Feb 2023 releases. You need to adjust your application, or else convince us that whatever you're doing should be allowed. There's more context in this long thread: https://www.postgresql.org/message-id/flat/17434-d9f7a064ce2a88a3%40postgresql.org regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-12-05 15:26 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-12-05 14:22 BUG #18229: Multiple vacuum queries fail after upgrading to 13.10 PG Bug reporting form <noreply@postgresql.org> 2023-12-05 15:26 ` Tom Lane <tgl@sss.pgh.pa.us>
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