Corrupted Table

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: "pgsql-general" <pgsql-general(at)postgreSQL(dot)org>
Subject: Corrupted Table
Date: 2000-07-31 19:00:13
Message-ID: 005b01bffb21$8edb6a20$2dd260d1@arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table that seems to have become corrupted.

---------------
$ pg_dump -t archivewords ec > aw.dump
pqWait() -- connection not open
PQendcopy: resetting connection
SQL query to dump the contents of Table 'archivewords' did not execute
correctly. After we read all the table contents from the backend,
PQendcopy() failed. Explanation from backend: 'The Data Base System is
starting up
'.
The query was: 'COPY "archivewords" TO stdout;
'.
---------------

As a result of this event, in the log file I see:
---------------
Server process (pid 21764) exited with status 139 at Mon Jul 31 14:51:44
2000
Terminating any active server processes...
Server processes were terminated at Mon Jul 31 14:51:44 2000
Reinitializing shared memory and semaphores
The Data Base System is starting up
000731.14:51:44.967 [21766] DEBUG: Data Base System is starting up at Mon
Jul 31 14:51:44 2000
000731.14:51:44.967 [21766] DEBUG: Data Base System was interrupted being
in production at Mon Jul 31 14:50:24 2000
000731.14:51:44.968 [21766] DEBUG: Data Base System is in production state
at Mon Jul 31 14:51:44 2000
---------------

Here is what the table looks like:
CREATE TABLE "archivewords" (
"docid" text NOT NULL,
"word" text NOT NULL,
"weight" int4 DEFAULT 0 NOT NULL
);
CREATE UNIQUE INDEX "iarcwordsword" on "archivewords" using btree ( "word"
"text_ops", "docid" "text_ops" );

Does anyone know what would couse this or how to recover from it? In this
particular case I can recreate the file but I am concerned that this might
happen on a more critical file so I would like to pursue recovering it if
possible.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herbert Liechti 2000-07-31 19:10:51 Re: How I can undelete recodes?
Previous Message Joseph Shraibman 2000-07-31 18:10:45 vacuum messges