Got to make it work, but now, when i try to make a dump it says
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 2969644
pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor
tried reindex:
reindexdb: reindexing of database "hostel" failed: ERROR: missing chunk number 0 for
toast value 2969644
and vacuum -f
vacuumdb: vacuuming of database "hostel" failed: ERROR: missing chunk number 0 for toast
value 2970344
Vilen Tambovtsev wrote:
Hello,
My disk went out of space, so pgsql crashed, and had some FS troubles
occurred.
I fixed FS, then tried to start and got this:
- 2005-12-28 19:02:49 NOVT - - 2747: LOG: database system was
interrupted at 2005-12-28 19:02:09 NOVT
- 2005-12-28 19:02:49 NOVT - - 2747: LOG: checkpoint record is at
5/FA0000E8
- 2005-12-28 19:02:49 NOVT - - 2747: LOG: redo record is at
5/FA0000E8; undo record is at 0/0; shutdown TRUE
- 2005-12-28 19:02:49 NOVT - - 2747: LOG: next transaction ID:
74678708; next OID: 2982120
- 2005-12-28 19:02:49 NOVT - - 2747: LOG: next MultiXactId: 1; next
MultiXactOffset: 0
- 2005-12-28 19:02:49 NOVT - - 2747: LOG: database system was not
properly shut down; automatic recovery in progress
- 2005-12-28 19:02:49 NOVT - - 2747: LOG: record with zero length at
5/FA00012C
- 2005-12-28 19:02:49 NOVT - - 2747: LOG: redo is not required
- 2005-12-28 19:02:49 NOVT - - 2747: PANIC: could not access status
of transaction 74678708
- 2005-12-28 19:02:49 NOVT - - 2747: DETAIL: could not read from file
"pg_clog/0047" at offset 57344: Unknown error:
0
- 2005-12-28 19:02:49 NOVT - - 2745: LOG: startup process (PID 2747)
was terminated by signal 6
- 2005-12-28 19:02:49 NOVT - - 2745: LOG: aborting startup due to
startup process failure
- 2005-12-28 19:02:49 NOVT - - 2746: LOG: logger shutting down
Tried to use pg_resetxlog - but it has not effect :(
Is there any tool to recover or smth ?
Maybe to reset transaction log...
--
Vilen Tambovtsev
Plesk QA Engineer
SWsoft, Inc.
E-mail: vtambovtsev@xxxxxxxxxx
ICQ UIN: 4608679
