From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | need help urgent |
Date: | 2000-11-03 19:35:20 |
Message-ID: | 3A031378.F6D5CA66@ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-sql |
Hi,
Is anybody have experience about core dump?
We have some scripts have been used for a long time, however, recently,
they seem to have some problems,
the message I got:
SSELECT priority from priority where source=lower('questionable')
Total insert into preunchecked: 1
Segmentation fault - core dumped
Segmentation fault - core dumped
This script has been used for a few monthes, no problem.
I checked my pgsql.log, I saw:
Nov 3 00:58:45 wipeout postgres[1638]: query: INSERT INTO
source(id,source) SELECT id,'questionable' from
preunchecked WHERE insertdate>= '2000-11
-03 00:58:45-08'
Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT version()
Nov 3 00:58:46 wipeout postgres[1642]: query: begin
Nov 3 00:58:46 wipeout postgres[1642]: ProcessUtility: begin
Nov 3 00:58:46 wipeout postgres[1642]: query: set transaction isolation
level serializable
Nov 3 00:58:46 wipeout postgres[1642]: ProcessUtility: set transaction
isolation level serializable
Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT oid from
pg_database where datname = 'template1'
Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT pg_type.oid,
typowner, typname, typlen, typprtlen, typinput, typoutput, typreceive,
typsend, typelem, typdeli
m, typdefault, typrelid, typbyval, usename from pg_type, pg_user where
typowner = usesysid
Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT pg_proc.oid,
proname, prolang, pronargs, prorettype, proretset, proargtypes, prosrc,
probin, usename from pg_
proc, pg_user where pg_proc.oid > '17216'::oid and proowner = usesysid
Nov 3 00:58:46 wipeout postgres[1642]: query: SELECT pg_aggregate.oid,
aggname, aggtransfn1, aggtransfn2, aggfinalfn, aggtranstype1,
aggbasetype, aggtranstype2, a
gginitval1, agginitval2, usename from pg_aggregate, pg_user where
aggowner = usesysid
................
We have no script to open a new session[1642], how this happen? how I
to prevent this??
Thanks!
--
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.ipinc.com
From | Date | Subject | |
---|---|---|---|
Next Message | matthew.copeland | 2000-11-03 19:48:29 | problem creating database |
Previous Message | Judith Elizabeth Trejo Alvarez | 2000-11-03 15:57:30 | Consulta |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-11-03 20:02:24 | Re: user defined functions in Java ? |
Previous Message | Tom Lane | 2000-11-03 17:48:14 | Re: Subqueries in from clause |