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

2025-08-26 Thread Achilleas Mantzios
On 8/25/25 17:11, Achilleas Mantzios wrote: On 25/8/25 17:58, Adrian Klaver wrote: On 8/25/25 07:40, Achilleas Mantzios wrote: On 8/20/25 14:59, Achilleas Mantzios wrote: On 8/14/25 16:01, Achilleas Mantzios wrote: Hi Adrian On 8/14/25 15:39, Adrian Klaver wrote: On 8/14/25 00:07, Achi

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

2025-08-26 Thread Achilleas Mantzios
On 8/26/25 07:22, Laurenz Albe wrote: On Mon, 2025-08-25 at 15:40 +0100, Achilleas Mantzios wrote: 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 t

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

2025-08-25 Thread Laurenz Albe
On Mon, 2025-08-25 at 15:40 +0100, Achilleas Mantzios wrote: > > > > > 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/targ

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

2025-08-25 Thread Achilleas Mantzios
On 25/8/25 17:58, Adrian Klaver wrote: On 8/25/25 07:40, Achilleas Mantzios wrote: On 8/20/25 14:59, Achilleas Mantzios wrote: On 8/14/25 16:01, Achilleas Mantzios wrote: Hi Adrian On 8/14/25 15:39, Adrian Klaver wrote: On 8/14/25 00:07, Achilleas Mantzios wrote: Hi All We've been hit

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

2025-08-25 Thread Adrian Klaver
On 8/25/25 07:40, Achilleas Mantzios wrote: On 8/20/25 14:59, Achilleas Mantzios wrote: On 8/14/25 16:01, Achilleas Mantzios wrote: Hi Adrian On 8/14/25 15:39, Adrian Klaver wrote: On 8/14/25 00:07, Achilleas Mantzios wrote: Hi All We've been hit by a weird deadlock which it took me some

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

2025-08-25 Thread Achilleas Mantzios
On 8/20/25 14:59, Achilleas Mantzios wrote: On 8/14/25 16:01, Achilleas Mantzios wrote: Hi Adrian On 8/14/25 15:39, Adrian Klaver wrote: 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

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

2025-08-20 Thread Achilleas Mantzios
On 8/14/25 16:01, Achilleas Mantzios wrote: Hi Adrian On 8/14/25 15:39, Adrian Klaver wrote: 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 expli

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

2025-08-14 Thread Achilleas Mantzios
Hi Adrian On 8/14/25 15:39, Adrian Klaver wrote: 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 o

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

2025-08-14 Thread Adrian Klaver
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 ha

Strange deadlock with object/target of lock : transaction

2025-08-14 Thread Achilleas Mantzios
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 show the schema of the table and its triggers f