| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Антон Глушаков <a(dot)glushakov86(at)gmail(dot)com> |
| Cc: | ikramuddin <ikram(dot)amani815(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: query hangs out |
| Date: | 2025-05-21 15:09:55 |
| Message-ID: | 1ceba18088383dd1a3cfc3d8dcf4a12615609b2f.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2025-05-21 21:27:58 | Re: Stop sending |
| Previous Message | Ffd | 2025-05-21 13:44:37 | Stop sending |