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

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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:16:18
Message-ID: 20191213001618.jqeousv77xnlds7x@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On Thu, Dec 12, 2019 at 07:05:53PM -0500, Jeff Janes wrote:
>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.

Thanks for the bisect. I've planned to try reproducing this on 11, but
this commit only in 12, so Tom is right it's a recent bug.


Tomas Vondra
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to


Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2019-12-13 02:47:33 Re: REINDEX CONCURRENTLY unexpectedly fails
Previous Message Joe Conway 2019-12-13 00:08:04 Re: ltrim function