Re: BUG #16162: create index using gist_trgm_ops leads to panic

Jeff Janes <[email protected]> Thu, 12 Dec 2019 19:05:53 -0500

Newsgroups	gmane.comp.db.postgresql.bugs
Message-ID	<CAMkU=1ymVJWS_u6ndDarWfaOQz44Td2DWgpA_3t4+OV4xsV3WQ@mail.gmail.com>

On Thu, Dec 12, 2019 at 8:44 AM Tom Lane <[email protected]> wrote:

>
> I wonder if this could be a recently-introduced bug?  I do not
> recall seeing complaints like this before v12.
>

Looks like the culprit is:

commit 9155580fd5fc2a0cbb23376dfca7cd21f59c2c7b
Author: Heikki Linnakangas <[email protected]>
Date:   Wed Apr 3 17:03:15 2019 +0300

    Generate less WAL during GiST, GIN and SP-GiST index build.

The commit before went 150 iterations with no failures, while this one
failed on the 15th iteration, then again on 4th.

Cheers,

Jeff