BUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0
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
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@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;
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
Michael Paquier <michael@paquier.xyz> writes:
On Mon, Aug 01, 2022 at 02:39:36AM +0000, PG Bug reporting form wrote:
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 .
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.
Yeah, and REINDEX CONCURRENTLY has been one of the more-often-fixed
features :-(. If it does still reproduce with 12.11, please see if
you can get a stack trace from the crash [1]https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend. Also, does it crash
if you omit CONCURRENTLY?
regards, tom lane
[1]: https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend