Re: How to investigate deadlocks

2023-10-03 Thread Andreas Kretschmer
Am 02.10.23 um 13:27 schrieb Matthias Apitz: Hello, One of our clients running our LMS on top of PostgreSQL 13.1 created a ticket with these messages: 2023-09-30 16:50:50.951 CEST [18117] ERROR: deadlock detected 2023-09-30 16:50:50.951 CEST [18117] DETAIL: Process 18117 waits for ShareLoc

Re: How to investigate deadlocks

2023-10-03 Thread Andreas Kretschmer
Am 02.10.23 um 13:27 schrieb Matthias Apitz: Hello, One of our clients running our LMS on top of PostgreSQL 13.1 created a ticket with these messages: 2023-09-30 16:50:50.951 CEST [18117] ERROR: deadlock detected 2023-09-30 16:50:50.951 CEST [18117] DETAIL: Process 18117 waits for ShareLoc

Re: How to investigate deadlocks

2023-10-02 Thread David G. Johnston
On Monday, October 2, 2023, Matthias Apitz wrote: > > Hello, > > One of our clients running our LMS on top of PostgreSQL 13.1 created a > ticket with these messages: > > 2023-09-30 16:50:50.951 CEST [18117] ERROR: deadlock detected > 2023-09-30 16:50:50.951 CEST [18117] DETAIL: Process 18117 wa

Re: How to investigate deadlocks

2023-10-02 Thread Laurenz Albe
On Mon, 2023-10-02 at 13:27 +0200, Matthias Apitz wrote: > One of our clients running our LMS on top of PostgreSQL 13.1 created a > ticket with these messages: > > 2023-09-30 16:50:50.951 CEST [18117] ERROR:  deadlock detected > 2023-09-30 16:50:50.951 CEST [18117] DETAIL:  Process 18117 waits for

Re: How to investigate deadlocks

2023-10-02 Thread Tom Lane
Matthias Apitz writes: > One of our clients running our LMS on top of PostgreSQL 13.1 created a > ticket with these messages: > 2023-09-30 16:50:50.951 CEST [18117] ERROR: deadlock detected > 2023-09-30 16:50:50.951 CEST [18117] DETAIL: Process 18117 waits for > ShareLock on transaction 150396

How to investigate deadlocks

2023-10-02 Thread Matthias Apitz
Hello, One of our clients running our LMS on top of PostgreSQL 13.1 created a ticket with these messages: 2023-09-30 16:50:50.951 CEST [18117] ERROR: deadlock detected 2023-09-30 16:50:50.951 CEST [18117] DETAIL: Process 18117 waits for ShareLock on transaction 150396154; blocked by process