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
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? |