Corrupted Table
От | Bryan White |
---|---|
Тема | Corrupted Table |
Дата | |
Msg-id | 005b01bffb21$8edb6a20$2dd260d1@arcamax.com обсуждение исходный текст |
Ответы |
Re: Corrupted Table
|
Список | 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.
В списке pgsql-general по дате отправления: