From: Tom Lane <tgl@sss.pgh.pa.us>
To: ganeshpandi.eswaran@chainsys.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18229: Multiple vacuum queries fail after upgrading to 13.10
Date: Tue, 05 Dec 2023 10:26:13 -0500
Message-ID: <924356.1701789973@sss.pgh.pa.us> (raw)
In-Reply-To: <18229-fc177bc9708a2787@postgresql.org>
References: <18229-fc177bc9708a2787@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, ganeshpandi.eswaran@chainsys.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18229: Multiple vacuum queries fail after upgrading to 13.10
In-Reply-To: <924356.1701789973@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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