segfault with incremental sort

Поиск
Список
Период
Сортировка
От luis.roberto@siscobra.com.br
Тема segfault with incremental sort
Дата
Msg-id 622580997.37108180.1604080457319.JavaMail.zimbra@siscobra.com.br
обсуждение исходный текст
Ответы Re: segfault with incremental sort  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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.


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 fault
# 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:


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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: REL_13_STABLE Windows 10 Regression Failures
Следующее
От: Tom Lane
Дата:
Сообщение: Re: segfault with incremental sort