Re: signal 11 - Mailing list pgsql-bugs

Sorry, I wasn't sure how much information I should provide.  To be thorough:

-Tanya

----------------------------------------------------------------------------
-

-- TOC Entry ID 18 (OID 16580)
--
-- Name: escalation Type: TABLE Owner: postgres
--

CREATE TABLE "escalation" (
    "pathname" character varying(20) NOT NULL,
    "level" smallint,
    "contact" character varying(20),
    "notify_method" character varying(12),
    "days" character varying(12),
    "hours" character varying(12),
    "period" integer,
    "num" integer
);

--
-- TOC Entry ID 36 (OID 16611)
--
-- Name: outages Type: TABLE Owner: postgres
--

CREATE TABLE "outages" (
    "outage_id" serial NOT NULL,
    "machine" character varying(30),
    "service" character varying(30),
    "status" character varying(12) NOT NULL,
    "time" timestamp with time zone,
    "owner" character varying(60),
    "level" smallint DEFAULT 0 NOT NULL,
    "comments" text
);


--
-- TOC Entry ID 40 (OID 16618)
--
-- Name: escalation_link Type: TABLE Owner: postgres
--

CREATE TABLE "escalation_link" (
    "machine" character varying(30),
    "service" character varying(30),
    "status" character varying(12),
    "pathname" character varying(20)
);

--
-- TOC Entry ID 41 (OID 16618)
--
-- Name: escalation_link Type: ACL Owner:
--

REVOKE ALL on "escalation_link" from PUBLIC;
GRANT ALL on "escalation_link" to "postgres";
GRANT SELECT on "escalation_link" to "ops2";
GRANT SELECT on "escalation_link" to GROUP "operators";
GRANT ALL on "escalation_link" to GROUP "opsadmins";
--
-- TOC Entry ID 37 (OID 16611)
--
-- Name: outages Type: ACL Owner:
--

REVOKE ALL on "outages" from PUBLIC;
GRANT ALL on "outages" to "postgres";
GRANT INSERT,SELECT,UPDATE,DELETE on "outages" to "ops2";
GRANT INSERT,SELECT on "outages" to GROUP "operators";
GRANT ALL on "outages" to GROUP "opsadmins";
--
-- TOC Entry ID 19 (OID 16580)
--
-- Name: escalation Type: ACL Owner:
--

REVOKE ALL on "escalation" from PUBLIC;
GRANT ALL on "escalation" to "postgres";
GRANT SELECT on "escalation" to "ops2";
GRANT SELECT on "escalation" to GROUP "operators";



-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, January 26, 2004 11:59 AM
To: Tanya Mamedalin
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] 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