Re: pgsql: Avoid improbable PANIC during heap_update.

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Avoid improbable PANIC during heap_update.
Date: 2022-10-03 19:34:19
Message-ID: Yzs5O3o3QQURRv5B@ahch-to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Fri, Sep 30, 2022 at 04:51:20PM -0400, Tom Lane wrote:
> Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
> > Just to confirm I saw this on RC1
>
> What test case are you using?
>

Hi,

Currently the way I have to reproduce it is:

- install the regression database
- drop all tables but:
hash_i4_heap, hash_name_heap, hash_txt_heap,
quad_poly_tbl, road
- run 10 sqlsmith processes... normally in an hour or less the problem
appears

I have the logs from the last time it happened so maybe I can trace the
exact pattern to reproducite at will... at least to keep a test
somewhere.

BTW, so far so good with your last fix (about 12 hours now)...

--
Jaime Casanova
Director de Servicios Profesionales
SystemGuards - Consultores de PostgreSQL

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2022-10-03 21:04:27 pgsql: Stamp 15rc2.
Previous Message Tom Lane 2022-10-03 19:07:25 pgsql: Fix psql's behavior with \g for a multiple-command string.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-10-03 19:37:50 Re: Reducing the chunk header sizes on all memory context types
Previous Message Jaime Casanova 2022-10-03 19:25:49 Re: Crash in BRIN minmax-multi indexes