DB crash after disk full

From: Vilen Tambovtsev <vtambovtsev(at)swsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: DB crash after disk full
Date: 2005-12-28 13:06:28
Message-ID: 43B28DD4.5060006@swsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Panov 2005-12-28 13:06:58 Re: WAL logs multiplexing?
Previous Message Martijn van Oosterhout 2005-12-28 12:38:21 Re: WAL logs multiplexing?