DB crash after disk full
От | Vilen Tambovtsev |
---|---|
Тема | DB crash after disk full |
Дата | |
Msg-id | 43B28DD4.5060006@swsoft.com обсуждение исходный текст |
Ответы |
Re: DB crash after disk full
Re: DB crash after disk full |
Список | 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
В списке pgsql-general по дате отправления: