From: | "Peter Darley" <pdarley(at)kinesis-cem(dot)com> |
---|---|
To: | "Pgsql-General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Bad records in table |
Date: | 2002-07-02 15:15:01 |
Message-ID: | NNEAICKPNOGDBHNCEDCPCEKPCKAA.pdarley@kinesis-cem.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Friends,
I have a table with bad data in it. Whenever the backend hits the tupples
with bad data I get:
Jul 2 07:44:18 db postgres[2652]: [22] DEBUG: server process (pid 2869)
was terminated by signal 11
Jul 2 07:44:18 db postgres[2652]: [23] DEBUG: terminating any other active
server processes
Jul 2 07:44:18 db postgres[2652]: [24] DEBUG: all server processes
terminated; reinitializing shared memory and semaphores
Jul 2 07:44:18 db postgres[2871]: [25] FATAL 1: The database system is
starting up
Jul 2 07:44:18 db postgres[2870]: [25] DEBUG: database system was
interrupted at 2002-07-02 07:42:30 PDT
Jul 2 07:44:18 db postgres[2870]: [26] DEBUG: checkpoint record is at
1/94E54768
Jul 2 07:44:18 db postgres[2870]: [27] DEBUG: redo record is at
1/94E54768; undo record is at 0/0; shutdown TRUE
Jul 2 07:44:18 db postgres[2870]: [28] DEBUG: next transaction id:
55508992; next oid: 13249044
Jul 2 07:44:18 db postgres[2870]: [29] DEBUG: database system was not
properly shut down; automatic recovery in progress
Jul 2 07:44:18 db postgres[2870]: [30] DEBUG: redo starts at 1/94E547A8
Jul 2 07:44:18 db postgres[2870]: [31] DEBUG: ReadRecord: record with zero
length at 1/94E547CC
Jul 2 07:44:18 db postgres[2870]: [32] DEBUG: redo done at 1/94E547A8
Jul 2 07:44:20 db postgres[2870]: [33] DEBUG: database system is ready
I can identify the bad records with a simple perl script that reads all the
records sequentially and lets me know which ones crash the back end. Now
that I know which ones they are, how can I get rid of them?
Once I get this all fixed, what kinds of tests should I do on the machine
to see if it's got some kind of hardware problem? It's RedHat Linux
2.4.9-31smp.
Thanks for your help!
Peter Darley
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2002-07-02 15:41:04 | Re: (A) native Windows port |
Previous Message | Scott Marlowe | 2002-07-02 15:13:31 | Re: Case-sensitive problem |