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

RE: [SQL] really need help

From: "Schlobohm, Jack" <SchlobohmJ(at)DNB(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Cc: "Jie Liang" <jliang(at)ipinc(dot)com>
Subject: RE: [SQL] really need help
Date: 2000-11-03 21:45:07
Message-ID: 161DEB881208673-02@WorldSecure_Server__smtp-gw.us.dnb.com_ (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
Hi,

I would like to stop spending my work day deleting these messages. Is there
anybody out there responsible for this? Make it stop! Now!

Thanks

> -----Original Message-----
> From:	Jie Liang [SMTP:jliang(at)ipinc(dot)com]
> Sent:	Friday, November 03, 2000 1:35 PM
> To:	pgsql-admin(at)postgresql(dot)org; pgsql-sql(at)postgresql(dot)org
> Subject:	[SQL] need help urgent
> 
> 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
> 
> 
> 

Attachment: unknown_filename
Description: application/ms-tnef (3.0 KB)

pgsql-admin by date

Next:From: Rodrigo FernandezDate: 2000-11-03 21:47:49
Subject: Re: Consulta
Previous:From: matthew.copelandDate: 2000-11-03 19:48:29
Subject: problem creating database

pgsql-sql by date

Next:From: Indraneel MajumdarDate: 2000-11-03 23:58:26
Subject: Re: Connecting to Postgres from Windows
Previous:From: Peter EisentrautDate: 2000-11-03 20:02:24
Subject: Re: user defined functions in Java ?

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