Message-ID: <1ceba18088383dd1a3cfc3d8dcf4a12615609b2f.camel@cybertec.at>
Subject: Re: query hangs out
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: =?UTF-8?Q?=D0=90=D0=BD=D1=82=D0=BE=D0=BD_?=
 =?UTF-8?Q?=D0=93=D0=BB=D1=83=D1=88=D0=B0=D0=BA=D0=BE=D0=B2?=
	 <a.glushakov86@gmail.com>
Cc: ikramuddin <ikram.amani815@gmail.com>, pgsql-admin@lists.postgresql.org
Date: Wed, 21 May 2025 17:09:55 +0200
In-Reply-To: 
 <CAHnOmafmSVpxJGcP6SiVP=4BbdUAspp6K07T9rSvNyae6tk4WQ@mail.gmail.com>
References: 
	<CAHnOmadn1UB-t-=Umd_TSEZ=kw48=ecX3EnesABxbPdboB-ZUQ@mail.gmail.com>
	 <32ad0fda77629362dbdc90136e6d5f667d496e01.camel@cybertec.at>
	 <CAHnOmafAW_Dqc8NEkmi=HOOMp3xf1DZdtOXauU2c1N5hq9BnVw@mail.gmail.com>
	 <CAL9MbytuyCsNoKK4Aus8zsXYiBz+G+YAm+Gvoa1Pz+SvGO7fBA@mail.gmail.com>
	 <CAHnOmacs_JB_wjA9g=PZyuH5jtbFb_qkf-dS7h7H4bkS4nTQeg@mail.gmail.com>
	 <18617cd83b190c4209a9b16597aaacbfa7ba4df8.camel@cybertec.at>
	 <CAHnOmafmSVpxJGcP6SiVP=4BbdUAspp6K07T9rSvNyae6tk4WQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.1 (3.56.1-1.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/1ceba18088383dd1a3cfc3d8dcf4a12615609b2f.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-05-21 at 16:27 +0300, =D0=90=D0=BD=D1=82=D0=BE=D0=BD =D0=93=D0=
=BB=D1=83=D1=88=D0=B0=D0=BA=D0=BE=D0=B2 wrote:
> > What do you see at (47,13)?=20
>=20
> 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 =
=3D 13;
> -[ RECORD 1 ]------------------------------------------------------------=
---------------------------------------------------------------------------=
----
> lp =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 13
> lp_off =C2=A0 =C2=A0 =C2=A0| 4632
> lp_flags =C2=A0 =C2=A0| 1
> lp_len =C2=A0 =C2=A0 =C2=A0| 100
> t_xmin =C2=A0 =C2=A0 =C2=A0| 136385644
> t_xmax =C2=A0 =C2=A0 =C2=A0| 136385520
> t_field3 =C2=A0 =C2=A0| 0
> t_ctid =C2=A0 =C2=A0 =C2=A0| (47,13)
> t_infomask2 | 11
> t_infomask =C2=A0| 8337
> t_hoff =C2=A0 =C2=A0 =C2=A0| 32
> t_bits =C2=A0 =C2=A0 =C2=A0| 1111011000000000
> t_oid =C2=A0 =C2=A0 =C2=A0 |
> t_data =C2=A0 =C2=A0 =C2=A0| \x3e8a7c00000000000100000090877a16b4b308dd94=
60898784c4af2dab692693d29bdf78bcf5153401000000ad43d6a5273608dd947a749769b94=
3ab3cd8020001000000

That tuple should be visible.

So I'd say you should killed the other tuple with heap_force_kill().

Yours,
Laurenz Albe