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

Jeff Janes <jeff.janes@gmail.com>

From: Jeff Janes <jeff.janes@gmail.com>
To: Alexander Lakhin <exclusion@gmail.com>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>, kunert@cms.hu-berlin.de, pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Date: 2019-12-15T17:57:37Z
Lists: pgsql-bugs
On Sat, Dec 14, 2019 at 2:00 PM Alexander Lakhin <exclusion@gmail.com>
wrote:

> Hello Heikki,
> 14.12.2019 1:02, Heikki Linnakangas wrote:
> >
> > Committed a fix. Many thanks for the reproducer scripts, Andreas and
> > Alexander!
> The script that I presented in [0] still reproduces assertion failure
> for me on REL_12_STABLE (fd005e1a):
>

I've verified that this was introduced by 9155580f and that Heikki's latest
commit a7ee7c851 has not fixed it.  I've reproduced it without cassert.

Cheers,

Jeff

Commits

  1. Fix yet another crash in page split during GiST index creation.

  2. Fix crash when a page was split during GiST index creation.

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