Re: signal 11

"Tanya Mamedalin" <tmamedalin@registrypro.pro> writes:
> Possible ways to reproduce the error:  Run a multipart query similar to:

> SELECT DISTINCT o.outage_id, o.machine, o.service, o.level, o.comments,
> o2.time, e.num
>        FROM outages o, outages o2, escalation e
>        WHERE o.outage_id='31009'
>        AND e.pathname = (SELECT pathname from escalation_link el
>                          WHERE el.machine=o.machine AND el.service=o.service)
>        AND e.level=o.level
>      AND o2.outage_id=o.outage_id
>        AND o2.status in ('ALERT','WARN','CRIT','DOWN','UNKNOWN')
>      ORDER BY LEVEL DESC LIMIT 1;

This is difficult to do when you have not offered the definitions of the
tables used by the query ...

            regards, tom lane