Re: signal 11

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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, January 26, 2004 11:59 AM
To: Tanya Mamedalin
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] signal 11

"Tanya Mamedalin" <tmamedalin(at)registrypro(dot)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