Re: REINDEX INDEX results in a crash for an index of pg_class since 9.6

Hi,

On 2019-04-30 18:42:36 -0400, Tom Lane wrote:
> markhor just reported in with results showing that we have worse
> problems than deadlock-prone tests in the back branches: 9.4
> for example looks like

> -- whole tables
> REINDEX TABLE pg_class; -- mapped, non-shared, critical
> + ERROR: could not read block 0 in file "base/16384/27769": read only 0 of 8192 bytes

Ugh. Also failed on 9.6.

> Given this, I'm rethinking my position that we can dispense with these
> test cases. Let's try putting them in a standalone test script, and
> see whether that leads to failures or not. Even if it does, we'd
> better keep them until we've got a fully clean bill of health from
> the buildfarm.

Yea. Seems likely this indicates a proper, distinct, bug :/

I'll move the test into a new "reindex_catalog" test, with a comment
explaining that the failure cases necessitating that are somewhere
between bugs, ugly warts, an hard to fix edge cases.

Greetings,

Andres Freund