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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, kunert(at)cms(dot)hu-berlin(dot)de, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16162: create index using gist_trgm_ops leads to panic
Date: 2019-12-13 00:05:53
Message-ID: CAMkU=1ymVJWS_u6ndDarWfaOQz44Td2DWgpA_3t4+OV4xsV3WQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Dec 12, 2019 at 8:44 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(dot)linnakangas(at)iki(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joe Conway 2019-12-13 00:08:04 Re: ltrim function
Previous Message Serdar Başyiğit 2019-12-12 23:15:33 ltrim function