pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: Victor Yegorov <vyegorov@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Cc: Alexander Korotkov <aekorotkov@gmail.com>
Subject: Re: BUG #17406: Segmentation fault on GiST index after 14.2 upgrade
Date: Thu, 24 Feb 2022 22:17:27 +0100
Message-ID: <6bc7e8a7-382f-9d8d-8b8d-9c6607f7fa15@enterprisedb.com> (raw)
In-Reply-To: <5cd74597-f555-d4e1-4dc2-d399180bb8cc@enterprisedb.com>
References: <17406-71e02820ae79bb40@postgresql.org>
	<cb3a777a-99c7-f671-532d-b828a2223502@enterprisedb.com>
	<CAGnEbojzf-uObyWeu1MPNKaYsnL_U2kg48K6Ec43waPRBu3DrQ@mail.gmail.com>
	<788a0a51-b1e3-3601-5783-3f6488796ec4@enterprisedb.com>
	<CAGnEboiQ-cnhXceFa9WfXk7y06fuVVsf9WcmEdPerjqth8QJxA@mail.gmail.com>
	<c733dae0-15ba-bcdd-e465-1a9f2fdefebf@enterprisedb.com>
	<e544c795-2c7a-e662-19d2-e34da12bfa66@enterprisedb.com>
	<14ac4567-3285-f549-67df-debaeab7719f@enterprisedb.com>
	<5cd74597-f555-d4e1-4dc2-d399180bb8cc@enterprisedb.com>

On 2/24/22 19:36, Tomas Vondra wrote:
>
> ...
> 
> Attached is a patch that fixes this, but I wonder what will happen to
> new indexes created on 13+. Will check.
> 

Unfortunately, the patch fixes indexes built on PG12, but it also breaks
indexes created after pg_upgrade :-(

I'm not sure if a good solution even exists, because we can't really
distinguish those indexes. It only affects ltree_gist, though, and we
didn't get any other reports so far, so either few people are using it
or have not upgraded yet.

I've created a thread on pgsql-hackers [1], where it might get more
attention from other developers. Maybe they'll have a better idea on how
to fix this.

regards

[1]
https://www.postgresql.org/message-id/d80e0a55-6c3e-5b26-53e3-3c4f973f737c%40enterprisedb.com

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company





view thread (15+ messages)

Message-ID: <6bc7e8a7-382f-9d8d-8b8d-9c6607f7fa15@enterprisedb.com>
Permalink:  ../6bc7e8a7-382f-9d8d-8b8d-9c6607f7fa15@enterprisedb.com/
Also on:    postgresql.org/message-id/6bc7e8a7-382f-9d8d-8b8d-9c6607f7fa15@enterprisedb.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tomas.vondra@enterprisedb.com, vyegorov@gmail.com, pgsql-bugs@lists.postgresql.org, aekorotkov@gmail.com
  Subject: Re: BUG #17406: Segmentation fault on GiST index after 14.2 upgrade
  In-Reply-To: <6bc7e8a7-382f-9d8d-8b8d-9c6607f7fa15@enterprisedb.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox