pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedneed help urgent
3+ messages / 2 participants
[nested] [flat]
* need help urgent
@ 2000-11-03 19:35 Jie Liang <jliang@ipinc.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jie Liang @ 2000-11-03 19:35 UTC (permalink / raw)
To: pgsql-admin; pgsql-sql@postgresql.org
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@ipinc.com
www.ipinc.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Need HELP - URGENT
@ 2005-10-19 11:55 Gourish Singbal <gourish@gmail.com>
2005-10-20 09:10 ` Fwd: Need HELP - URGENT Gourish Singbal <gourish@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Gourish Singbal @ 2005-10-19 11:55 UTC (permalink / raw)
To: pgsql-admin
Tom,
Need some help in analyzing the pg_controldata output.
pg_control version number: 72
Catalog version number: 200310211
Database cluster state: in production
pg_control last modified: Wed 19 Oct 2005 02:40:53 AM PDT
Current log file ID: 875
Next log file segment: 165
Latest checkpoint location: 36B/9E7BFAB8
Prior checkpoint location: 36B/94485F20
Latest checkpoint's REDO location: 36B/9E2065F8
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's StartUpID: 69
Latest checkpoint's NextXID: 52699733
*Latest checkpoint's NextOID: 3508694151
*Time of latest checkpoint: Wed 19 Oct 2005 02:37:19 AM PDT
Database block size: 8192
Blocks per segment of large relation: 131072
Maximum length of identifiers: 64
Maximum number of function arguments: 32
Date/time type storage: 64-bit integers
Maximum length of locale name: 128
LC_COLLATE: en_US.UTF-8
LC_CTYPE: en_US.UTF-8
*From Whats given Below i understand that The OID of my database is
3.5Billion and O
IDs are stored as 4-byte integers, and will overflow at 4 billion.*
**
http://www.sql.org/sql-database/postgresql/FAQ/#4.16
We am using Postgresql 7.4.5 version and its a production database.
Are the OIDs going to Overflow ?. if so whats the Solution, Need help,
please.
--
Best,
Gourish Singbal
^ permalink raw reply [nested|flat] 3+ messages in thread
* Fwd: Need HELP - URGENT
2005-10-19 11:55 Need HELP - URGENT Gourish Singbal <gourish@gmail.com>
@ 2005-10-20 09:10 ` Gourish Singbal <gourish@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Gourish Singbal @ 2005-10-20 09:10 UTC (permalink / raw)
To: pgsql-admin
---------- Forwarded message ----------
From: Gourish Singbal <gourish@gmail.com>
Date: Oct 19, 2005 5:25 PM
Subject: Need HELP - URGENT
To: pgsql-admin <pgsql-admin@postgresql.org>
Tom,
Need some help in analyzing the pg_controldata output.
pg_control version number: 72
Catalog version number: 200310211
Database cluster state: in production
pg_control last modified: Wed 19 Oct 2005 02:40:53 AM PDT
Current log file ID: 875
Next log file segment: 165
Latest checkpoint location: 36B/9E7BFAB8
Prior checkpoint location: 36B/94485F20
Latest checkpoint's REDO location: 36B/9E2065F8
Latest checkpoint's UNDO location: 0/0
Latest checkpoint's StartUpID: 69
Latest checkpoint's NextXID: 52699733
*Latest checkpoint's NextOID: 3508694151
*Time of latest checkpoint: Wed 19 Oct 2005 02:37:19 AM PDT
Database block size: 8192
Blocks per segment of large relation: 131072
Maximum length of identifiers: 64
Maximum number of function arguments: 32
Date/time type storage: 64-bit integers
Maximum length of locale name: 128
LC_COLLATE: en_US.UTF-8
LC_CTYPE: en_US.UTF-8
*From Whats given Below i understand that The OID of my database is
3.5Billion and O
IDs are stored as 4-byte integers, and will overflow at 4 billion.*
**
http://www.sql.org/sql-database/postgresql/FAQ/#4.16
We am using Postgresql 7.4.5 version and its a production database.
Are the OIDs going to Overflow ?. if so whats the Solution, Need help,
please.
--
Best,
Gourish Singbal
--
Best,
Gourish Singbal
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-10-20 09:10 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-03 19:35 need help urgent Jie Liang <jliang@ipinc.com>
2005-10-19 11:55 Need HELP - URGENT Gourish Singbal <gourish@gmail.com>
2005-10-20 09:10 ` Fwd: Need HELP - URGENT Gourish Singbal <gourish@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox