From: luis.roberto@siscobra.com.br
To: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Cc: alan.formagi <alan.formagi@siscobra.com.br>
Subject: segfault with incremental sort
Date: Fri, 30 Oct 2020 14:54:17 -0300 (BRT)
Message-ID: <622580997.37108180.1604080457319.JavaMail.zimbra@siscobra.com.br> (raw)
Hi!
I'm running a query that is causing the server to segfault.
This is the plan generated by setting "enable_incremental_sort" to off.
[ https://explain.depesz.com/s/T3sY | https://explain.depesz.com/s/T3sY ]
setting the option to "on", causes:
# 2020-10-30 14:49:06 -03 - - 519945 - - () : LOG:background worker "parallel worker" (PID 522547) was terminated by signal 11: Segmentation faul t
# 2020-10-30 14:49:06 -03 - ::1(46826) - 521801 - username- (database_name) : WARNING: terminating connection because of crash of another server process
# 2020-10-30 14:49:06 -03 - ::1(46826) - 521801 - username - (database_name) : DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
# 2020-10-30 14:49:06 -03 - ::1(46826) - 521801 - username - ( database_name ) : HINT: In a moment you should be able to reconnect to the database and repeat your command.
Running explain only gives the following plan:
[ https://explain.depesz.com/s/Eh3F | https://explain.depesz.com/s/Eh3F ]
Version:
PostgreSQL 13.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit
Installed via package manager.
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: luis.roberto@siscobra.com.br, pgsql-bugs@lists.postgresql.org, alan.formagi@siscobra.com.br
Subject: Re: segfault with incremental sort
In-Reply-To: <622580997.37108180.1604080457319.JavaMail.zimbra@siscobra.com.br>
* 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