| From: | "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | DB/clog corruption |
| Date: | 2005-07-11 12:02:14 |
| Message-ID: | F71C0DC6B4FD3648815AAA7F969E35290153081C@sr002-2kexc.ateb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've a db table generating the error below on pg_dump. Per the
archives, i've tried creating a clog file 1559 but w/o success (
continue to get the same error) even when i extended the clog file to >
64K. Are there other options to recovering this table? Do i need to
extend clog 1559 to a greater size? Do i have to 'do something' to
create a non-zero length record at 1/669E0568? ( if so, how?)
thanks,
reid
$ pg_dump -f table_dump.sql -t table_with_error dbname
FATAL 2: read of clog file 1559, offset 0 failed: Success
pg_dump: FATAL 2: read of clog file 1559, offset 0 failed: Success
pg_dump: lost synchronization with server, resetting connection
DEBUG: server process (pid 1672) exited with exit code 2
DEBUG: terminating any other active server processes
DEBUG: all server processes terminated; reinitializing shared memory
and semaphores
DEBUG: database system was interrupted at 2005-07-11 08:41:39 EDT
DEBUG: checkpoint record is at 1/669E0528
DEBUG: redo record is at 1/669E0528; undo record is at 0/0; shutdown
TRUE
DEBUG: next transaction id: 1237894; next oid: 2850421
DEBUG: database system was not properly shut down; automatic recovery
in progress
FATAL 1: The database system is starting up
pg_dump: SQL command to dump the contents of table "table_with_error"
failed: PQendcopy() failed.
pg_dump: Error message from server: FATAL 1: The database system is
starting up
pg_dump: The command was: COPY "table_with_error" TO stdout;
$ DEBUG: ReadRecord: record with zero length at 1/669E0568
DEBUG: redo is not required
DEBUG: database system is ready
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus | 2005-07-11 12:33:18 | How to fix invalid multibyte character for locale error |
| Previous Message | André M. Winter - Carto.net | 2005-07-11 07:25:57 | array Q |