From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: melody_xiaodi@sina.com
Subject: BUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0
Date: Mon, 01 Aug 2022 02:39:36 +0000
Message-ID: <17563-2aeaf763e2edfa83@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17563
Logged by: Melody Liu
Email address: melody_xiaodi@sina.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;
the relative errors in system log(/var/log/message):
kernel: postgres[36031]: segfault at 34 ip 00000000007494de sp
00007ffc8e6d6550 error 4 in postgres[400000+72e000]
then i run the os command: 'addr2line -e /usr/pgsql-12/bin/postgres
00000000007494de -f' and the output was:
WaitForLockersMultiple
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, melody_xiaodi@sina.com
Subject: Re: BUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0
In-Reply-To: <17563-2aeaf763e2edfa83@postgresql.org>
* 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