Re: pg15b3: crash in paralell vacuum

2022-08-18 Thread Peter Geoghegan
On Thu, Aug 18, 2022 at 7:25 AM Masahiko Sawada wrote: > Justin, if it's reproducible in your environment, could you please try > it again with the attached patch? Pushed, thanks. I wonder how this issue could have been caught earlier, or even avoided in the first place. Would the bug have been

Re: pg15b3: crash in paralell vacuum

2022-08-18 Thread Justin Pryzby
On Thu, Aug 18, 2022 at 11:24:22PM +0900, Masahiko Sawada wrote: > The status = 11 is invalid value. Probably because indstats was not > initialized to 0 as I mentioned. > > Justin, if it's reproducible in your environment, could you please try > it again with the attached patch? Yes, this seems

Re: pg15b3: crash in paralell vacuum

2022-08-18 Thread Masahiko Sawada
On Thu, Aug 18, 2022 at 11:04 PM Justin Pryzby wrote: > > On Thu, Aug 18, 2022 at 08:34:06AM -0500, Justin Pryzby wrote: > > Unfortunately, it looks like the RPM packages are compiled with -O2, so > > this is > > of limited use. So I'll be back shortly with more... > > #3 0x006874f1 in

Re: pg15b3: crash in paralell vacuum

2022-08-18 Thread Masahiko Sawada
On Thu, Aug 18, 2022 at 11:06 PM Masahiko Sawada wrote: > > Hi, > > On Thu, Aug 18, 2022 at 10:34 PM Justin Pryzby wrote: > > > > Immediately after upgrading an internal instance, a loop around "vacuum" did > > this: > > Thank you for the report! > > > > > TRAP: FailedAssertion("indstats->status

Re: pg15b3: crash in paralell vacuum

2022-08-18 Thread Masahiko Sawada
Hi, On Thu, Aug 18, 2022 at 10:34 PM Justin Pryzby wrote: > > Immediately after upgrading an internal instance, a loop around "vacuum" did > this: Thank you for the report! > > TRAP: FailedAssertion("indstats->status == PARALLEL_INDVAC_STATUS_INITIAL", > File: "vacuumparallel.c", Line: 611, PI

Re: pg15b3: crash in paralell vacuum

2022-08-18 Thread Justin Pryzby
On Thu, Aug 18, 2022 at 08:34:06AM -0500, Justin Pryzby wrote: > Unfortunately, it looks like the RPM packages are compiled with -O2, so this > is > of limited use. So I'll be back shortly with more... #3 0x006874f1 in parallel_vacuum_process_all_indexes (pvs=0x25bdce0, num_index_scans

pg15b3: crash in paralell vacuum

2022-08-18 Thread Justin Pryzby
Immediately after upgrading an internal instance, a loop around "vacuum" did this: TRAP: FailedAssertion("indstats->status == PARALLEL_INDVAC_STATUS_INITIAL", File: "vacuumparallel.c", Line: 611, PID: 27635) postgres: postgres pryzbyj [local] VACUUM(ExceptionalCondition+0x8d)[0x99d9fd] postgres: