Re: BUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: melody_xiaodi(at)sina(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0
Date: 2022-08-01 07:57:40
Message-ID: YueHdMn3YMv88OVE@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Aug 01, 2022 at 02:39:36AM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 17563
> Logged by: Melody Liu
> Email address: melody_xiaodi(at)sina(dot)com
> PostgreSQL version: 12.0
> Operating system: CentOS Linux release 7.7.1908 (Core)
> Description:
>
> i executed the sql below to rebuild an index in my pg database(version 12.0)
> :
> psql> reindex index concurrently myindex;
> an unexpectend error was reported and all of the client processes exited
> abnormally .
> error messages in pg logs:
> db=,user=,app=,client=LOG: 00000: server process (PID 36031) was terminated
> by signal 11: Segmentation fault
> db=,user=,app=,client=DETAIL: Failed process was running: reindex index
> concurrently public.myindex;

12.0 is 3 years behind in terms of bug fixes, 12.11 being the latest
minor version available. So you may want to check with this version
first and see if the problem reproduces there are well.
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Laetitia Avrot 2022-08-01 08:13:36 Re: Statistics updates is delayed when using `commit and chain`
Previous Message Егор Чиндяскин 2022-08-01 07:17:09 Re[2]: BUG #17561: Server crashes on executing row() with very long argument list