Skip site navigation (1) Skip section navigation (2)

Re: signal 11

From: "Tanya Mamedalin" <tmamedalin(at)registrypro(dot)pro>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: signal 11
Date: 2004-01-26 19:59:26
Message-ID: DHEJKCBNACCFLFCBKJKJEEAPCAAA.tmamedalin@registrypro.pro (view raw or flat)
Thread:
Lists: 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(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



In response to

Responses

pgsql-bugs by date

Next:From: Hamedany, AllenDate: 2004-01-26 21:05:50
Subject: Can not always connect to postmaster. Sometimes get "Connection refused".
Previous:From: Bruce MomjianDate: 2004-01-26 18:26:54
Subject: Re: BUG #1064: work with temporary table in plpgsql function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group