public inbox for [email protected]
help / color / mirror / Atom feedFrom: Durgamahesh Manne <[email protected]>
To: pgsql-general <[email protected]>
Subject: Lock contention issues with repack
Date: Wed, 23 Oct 2024 00:28:06 +0530
Message-ID: <CAJCZkoKRi1NLZd6gKX_NYsNQx5JyfTLMaaxSo8fiXZenKkK_=w@mail.gmail.com> (raw)
Hi
DEBUG: Poll returned: 1
LOG: Command finished in worker 1: CREATE UNIQUE INDEX index_3199790649 ON
repack.table_5832724 USING btree (id)
DEBUG: ---- swap ----
DEBUG: query failed: ERROR: canceling statement due to statement timeout
DETAIL: query was: LOCK TABLE offer.market IN ACCESS EXCLUSIVE MODE
DEBUG: query failed: ERROR: canceling statement due to statement timeout
DETAIL: query was: LOCK TABLE offer.market IN ACCESS EXCLUSIVE MODE
While running pg_repack i was facing this issue as concurrent selects and
updates on tables being repacked .However raised the same to
pg_repack channel . No issues with low traffic on db
How to resolve this issue even on moderate db workload ?
reply
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Lock contention issues with repack
In-Reply-To: <CAJCZkoKRi1NLZd6gKX_NYsNQx5JyfTLMaaxSo8fiXZenKkK_=w@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox