Re: Re: PANIC: invalid index offnum: 186 when processing BRIN indexes in VACUUM

Thanks everyone for the analysis downthread. Here's a test case that
provokes the crash faster. Initialize with

create table brin_test (a text);
create index on brin_test using brin (a) with (pages_per_range = 1);

Then in one psql, run this:
select brin_summarize_new_values('brin_test_a_idx') \watch 0.1

and a pgbench running a script with this line (one client is enough):

insert into brin_test values (repeat(chr(ascii('A') + int4(random() * 61)), int4(random() * 200)));

It crashes in 10-20 seconds for me.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services