pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0
3+ messages / 3 participants
[nested] [flat]
* BUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0
@ 2022-08-01 02:39 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2022-08-01 02:39 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: melody_xiaodi@sina.com
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0
@ 2022-08-01 07:57 Michael Paquier <michael@paquier.xyz>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Paquier @ 2022-08-01 07:57 UTC (permalink / raw)
To: melody_xiaodi@sina.com; pgsql-bugs@lists.postgresql.org
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
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0
@ 2022-08-01 14:09 Tom Lane <tgl@sss.pgh.pa.us>
parent: Michael Paquier <michael@paquier.xyz>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2022-08-01 14:09 UTC (permalink / raw)
To: Michael Paquier <michael@paquier.xyz>; +Cc: melody_xiaodi@sina.com; pgsql-bugs@lists.postgresql.org
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]. 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-08-01 14:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-08-01 02:39 BUG #17563: exception " Segmentation fault" occured when i executed 'reindex index concurrently' in pg12.0 PG Bug reporting form <noreply@postgresql.org>
2022-08-01 07:57 ` Michael Paquier <michael@paquier.xyz>
2022-08-01 14:09 ` Tom Lane <tgl@sss.pgh.pa.us>
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