Re: BUG #15053: SIGSEGV - While executing query with cube agregator - Mailing list pgsql-bugs

From Andreas Seltenreich
Subject Re: BUG #15053: SIGSEGV - While executing query with cube agregator
Date
Msg-id 87wozpye0g.fsf@credativ.de
Whole thread Raw
In response to Re: BUG #15053: SIGSEGV - While executing query with cube agregator  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #15053: SIGSEGV - While executing query with cube agregator
List pgsql-bugs
Tom Lane writes:
> =?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
>> the following postgres crash was generated during the execution of this
>> query:
[...]
>> group by cube
>
> Hmm, well, first please update to something newer than 9.6.3, to see if
> the problem is already resolved.  (9.6.7 is being released this week.)

backtrace and query look similar to the issue we reported leading to the
following commitfest entry:

    https://commitfest.postgresql.org/16/1413/

Our customer hasn't seen any crashes with cube() statements since
setting

    replacement_sort_tuples = 0

I'm afraid this workaround might be needed here as well unless a fix
makes it into 9.6.7.

regards,
Andreas


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15053: SIGSEGV - While executing query with cube agregator
Next
From: Peter Geoghegan
Date:
Subject: Re: BUG #15053: SIGSEGV - While executing query with cube agregator