Re: gist segmentation fault

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Arup Nanda <Arup(dot)Nanda(at)protonmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: gist segmentation fault
Date: 2022-04-04 14:12:06
Message-ID: 1886767.1649081526@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arup Nanda <Arup(dot)Nanda(at)protonmail(dot)com> writes:
> We're preparing to upgrade postgresql from 12.8 to 14.2 but still we have some bugs and issues. Most of them are our fault, but now we have problem wedon't know how to play with it.
> [ crash in copy_ltree for an upgraded GIST index ]

I think this is the same problem already reported at [1].
It's an unfortunate error in the GIST ltree opclass.
You could apply the patch [2] locally perhaps, if you
don't want to wait around for 14.3.

regards, tom lane

[1] https://www.postgresql.org/message-id/flat/17406-71e02820ae79bb40%40postgresql.org
[2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=patch;h=7d30f59da

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2022-04-04 14:18:48 Trigger functions and FDW tables
Previous Message David G. Johnston 2022-04-04 13:47:12 Re: Transaction and SQL errors