public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: Антон Глушаков <[email protected]>
Cc: ikramuddin <[email protected]>
Cc: [email protected]
Subject: Re: query hangs out
Date: Wed, 21 May 2025 17:09:55 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAHnOmafmSVpxJGcP6SiVP=4BbdUAspp6K07T9rSvNyae6tk4WQ@mail.gmail.com>
References: <CAHnOmadn1UB-t-=Umd_TSEZ=kw48=ecX3EnesABxbPdboB-ZUQ@mail.gmail.com>
<[email protected]>
<CAHnOmafAW_Dqc8NEkmi=HOOMp3xf1DZdtOXauU2c1N5hq9BnVw@mail.gmail.com>
<CAL9MbytuyCsNoKK4Aus8zsXYiBz+G+YAm+Gvoa1Pz+SvGO7fBA@mail.gmail.com>
<CAHnOmacs_JB_wjA9g=PZyuH5jtbFb_qkf-dS7h7H4bkS4nTQeg@mail.gmail.com>
<[email protected]>
<CAHnOmafmSVpxJGcP6SiVP=4BbdUAspp6K07T9rSvNyae6tk4WQ@mail.gmail.com>
On Wed, 2025-05-21 at 16:27 +0300, Антон Глушаков wrote:
> > What do you see at (47,13)?
>
> I have restored the data before the freeze, here is the content (47.13)
> SELECT * FROM heap_page_items(get_raw_page('"InboxState"', 47)) where lp = 13;
> -[ RECORD 1 ]-------------------------------------------------------------------------------------------------------------------------------------------
> lp | 13
> lp_off | 4632
> lp_flags | 1
> lp_len | 100
> t_xmin | 136385644
> t_xmax | 136385520
> t_field3 | 0
> t_ctid | (47,13)
> t_infomask2 | 11
> t_infomask | 8337
> t_hoff | 32
> t_bits | 1111011000000000
> t_oid |
> t_data | \x3e8a7c00000000000100000090877a16b4b308dd9460898784c4af2dab692693d29bdf78bcf5153401000000ad43d6a5273608dd947a749769b943ab3cd8020001000000
That tuple should be visible.
So I'd say you should killed the other tuple with heap_force_kill().
Yours,
Laurenz Albe
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], [email protected], [email protected]
Subject: Re: query hangs out
In-Reply-To: <[email protected]>
* 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