Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16162: create index using gist_trgm_ops leads to panic - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #16162: create index using gist_trgm_ops leads to panic
Date
Msg-id CAMkU=1ymVJWS_u6ndDarWfaOQz44Td2DWgpA_3t4+OV4xsV3WQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16162: create index using gist_trgm_ops leads to panic  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #16162: create index using gist_trgm_ops leads to panic  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-bugs
Tree view
On Thu, Dec 12, 2019 at 8:44 AM Tom Lane <tgl@sss.pgh.pa.us> 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 <heikki.linnakangas@iki.fi>
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

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: postgres has no spinlock support on riscv rv64imafdc
Next
From: Joe Conway
Date:
Subject: Re: ltrim function