Re: BUG #13490: Segmentation fault on pg_stat_activity

On Wed, Jul 8, 2015 at 1:52 AM, <michael(at)bommaritollc(dot)com> wrote:
> Environment: Up-to-date instance running Trusty and using apt.postgresql.org
> postgresql-9.5-alpha1. Database was upgraded using pg_dump/restore. All
> other application behavior as expected.
>
> Not sure if this is related to #13286 or #12918, but if so, still affecting
> the binaries in apt. Pretty critical to fly blind without access to this.
>
> Crash example 1:
> 2015-07-07 16:42:45 UTC [26785-2] LOG: server process (PID 11836) was
> terminated by signal 11: Segmentation fault
> 2015-07-07 16:42:45 UTC [26785-3] DETAIL: Failed process was running:
> select * from pg_stat_activity ;
>
> Crash example 2:
> https://github.com/ankane/pghero/issues/30

If this link gets away we would lost the test case, it is better to
directly add it in the email:
SELECT pid, state, application_name AS source, age(now(), xact_start)
AS duration, waiting, query, xact_start AS started_at FROM
pg_stat_activity WHERE query <> '<insufficient privilege>' AND s
tate <> 'idle' AND pid <> pg_backend_pid() AND now() - query_start >
interval '60 seconds' ORDER BY query_start DESC;

This seems unrelated to #13286 which refers to pg_terminate_backend()
crashing, and in the case 1 presented above the query used for the
crash is more simple. Now this may be related to #12918, so could it
be possible to see at least a stack trace to see what is the code path
failing?
--
Michael