Re: signal 11
От | Tanya Mamedalin |
---|---|
Тема | Re: signal 11 |
Дата | |
Msg-id | DHEJKCBNACCFLFCBKJKJEEAPCAAA.tmamedalin@registrypro.pro обсуждение исходный текст |
Ответ на | Re: signal 11 (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: signal 11
|
Список | 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
В списке pgsql-bugs по дате отправления:
Предыдущее
От: pgsql-bugs@postgresql.orgДата:
Сообщение: Virus Infection Alert! Mail Transaction Failed
Следующее
От: "Hamedany, Allen"Дата:
Сообщение: Can not always connect to postmaster. Sometimes get "Connection refused".