Re: Undetected Deadlock

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Michael Harris <harmic(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Undetected Deadlock
Date: 2022-01-25 05:06:09
Message-ID: 21587598-F7BE-47FD-8FCF-C18E5095976B@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Jan 24, 2022, at 10:02 PM, Michael Harris <harmic(at)gmail(dot)com> wrote:
>
> My apologies,
>
> After posting this and looking at how it appears I realised that line
> wrapping makes the tables totally illegible.
>
> Here they are again with all unnecessary columns removed and others shortened.
>
> locktype | database | relation | pid | mode |
> granted | waitstart | relation
> ----------+----------+------------+---------+---------------------+---------+-------------------------------+--------------------
> relation | 529986 | 1842228045 | 2130531 | AccessShareLock | f
> | 2022-01-19 00:32:32.626152+01 | st.ctr_table_efr_oa
> relation | 529986 | 1842228045 | 2128603 | AccessExclusiveLock | t
> | | st.ctr_table_efr_oa
> relation | 529986 | 1842231489 | 2128603 | AccessExclusiveLock | f
> | 2022-01-19 00:32:32.924694+01 | st.tpd_oa
> relation | 529986 | 1842231489 | 2130531 | AccessShareLock | t
> | | st.tpd_oa
>
>
> pid | query_start | state_change | wait_event_type |
> wait_event | query
> ---------+--------------------+--------------------+-----------------+------------+-------------------------------------------------------------
> 2128603 | 00:32:32.924413+01 | 00:32:32.924413+01 | Lock |
> relation | DROP TABLE st.tpd_oa_18929
> 2130531 | 00:32:32.625706+01 | 00:32:32.625708+01 | Lock |
> relation | DELETE FROM st.ctr_table_efr_oa_19010 WHERE ropid =
> 44788868
>
> I hope this version is easier to read.
>
> Cheers
> Mike
> On Tue, 25 Jan 2022 at 15:49, Michael Harris <harmic(at)gmail(dot)com> wrote:
It’s definitely tidier, but on my mac Mail.app and on Thunderbird there is still a line wrap problem. I don’t think that will prevent the experts from helping out. I’m not one of them.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shaozhong SHI 2022-01-25 13:55:54 Robust ways for checking allowed values in a column
Previous Message Michael Harris 2022-01-25 05:02:03 Re: Undetected Deadlock