Re: Strange deadlock with object/target of lock : transaction

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Strange deadlock with object/target of lock : transaction
Date: 2025-08-14 14:39:35
Message-ID: d39c5f45-1c4c-4225-8462-20a1cf10c173@aklaver.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/14/25 00:07, Achilleas Mantzios wrote:
> Hi All
>
> We've been hit by a weird deadlock which it took me some days to isolate
> and replicate. It does not have to do with order of updates or any
> explicit TABLE-level locking, the objects/targets of the deadlock in
> question are transactions.

I have some questions:

1) Did this work in versions prior to 18?

2) The test case you ran was done on 18beta1, are you planning to test
on the just released 18beta3?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2025-08-14 15:01:12 Re: Strange deadlock with object/target of lock : transaction
Previous Message Adrian Klaver 2025-08-14 14:29:15 Re: help with upgrade from v15 to v16 rhel z/linux needed