From: Tom Lane <tgl@sss.pgh.pa.us>
To: obeltrame@callixbrasil.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15053: SIGSEGV - While executing query with cube agregator
Date: Tue, 06 Feb 2018 14:19:40 -0500
Message-ID: <23669.1517944780@sss.pgh.pa.us> (raw)
In-Reply-To: <151793838713.1243.5246278119990227987@wrigleys.postgresql.org>
References: <151793838713.1243.5246278119990227987@wrigleys.postgresql.org>
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.org> writes:
> the following postgres crash was generated during the execution of this
> query:
> select
> freeswitch_bug_events.created_at::date,
> freeswitch_nodes."name",
> tenants."name",
> count(*) filter(where freeswitch_bug_events.event = 'call received'),
> count(*) filter(where freeswitch_bug_events.event = 'status changed')
> from dev.freeswitch_bug_events
> join public.tenants on freeswitch_bug_events.tenant = tenants.id
> join public.freeswitch_nodes on freeswitch_bug_events.node =
> freeswitch_nodes.id
> group by
> cube (freeswitch_bug_events.created_at::date, freeswitch_nodes."name",
> tenants."name" )
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.)
If not, please see if you can extract a self-contained test case. That
stack trace is not really enough information to fix it.
regards, tom lane
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: tgl@sss.pgh.pa.us, obeltrame@callixbrasil.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15053: SIGSEGV - While executing query with cube agregator
In-Reply-To: <23669.1517944780@sss.pgh.pa.us>
* 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