postgres PANIC : heap_insert_redo: failed to add tuple
От | Alex Aseev |
---|---|
Тема | postgres PANIC : heap_insert_redo: failed to add tuple |
Дата | |
Msg-id | CANbzriT3h1kf2EaKEBcDqwu4AYwUjCuKcrDkjdxJ0CTjNeGnFQ@mail.gmail.com обсуждение исходный текст |
Список | pgsql-general |
Gents,
after restart service is not coming up, seems like something is corrupted.
can i get recover data somehow?
2012-12-14 17:49:28 EET LOG: could not create IPv6 socket: Address family not supported by protocol
2012-12-14 17:49:28 EET LOG: database system was interrupted while in recovery at 2012-12-14 17:10:01 EET
2012-12-14 17:49:28 EET HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2012-12-14 17:49:28 EET LOG: database system was not properly shut down; automatic recovery in progress
2012-12-14 17:49:28 EET LOG: incomplete startup packet
2012-12-14 17:49:28 EET LOG: redo starts at 8/EB84892C
2012-12-14 17:49:29 EET FATAL: the database system is starting up
2012-12-14 17:49:29 EET FATAL: the database system is starting up
2012-12-14 17:49:30 EET FATAL: the database system is starting up
2012-12-14 17:49:30 EET FATAL: the database system is starting up
2012-12-14 17:49:30 EET WARNING: will not overwrite a used ItemId
2012-12-14 17:49:30 EET CONTEXT: xlog redo insert: rel 1663/1629517/12496; tid 23/20
2012-12-14 17:49:30 EET PANIC: heap_insert_redo: failed to add tuple
2012-12-14 17:49:30 EET CONTEXT: xlog redo insert: rel 1663/1629517/12496; tid 23/20
2012-12-14 17:49:30 EET LOG: startup process (PID 25814) was terminated by signal 6: Aborted
2012-12-14 17:49:30 EET LOG: aborting startup due to startup process failure
2012-12-14 17:49:28 EET LOG: database system was interrupted while in recovery at 2012-12-14 17:10:01 EET
2012-12-14 17:49:28 EET HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2012-12-14 17:49:28 EET LOG: database system was not properly shut down; automatic recovery in progress
2012-12-14 17:49:28 EET LOG: incomplete startup packet
2012-12-14 17:49:28 EET LOG: redo starts at 8/EB84892C
2012-12-14 17:49:29 EET FATAL: the database system is starting up
2012-12-14 17:49:29 EET FATAL: the database system is starting up
2012-12-14 17:49:30 EET FATAL: the database system is starting up
2012-12-14 17:49:30 EET FATAL: the database system is starting up
2012-12-14 17:49:30 EET WARNING: will not overwrite a used ItemId
2012-12-14 17:49:30 EET CONTEXT: xlog redo insert: rel 1663/1629517/12496; tid 23/20
2012-12-14 17:49:30 EET PANIC: heap_insert_redo: failed to add tuple
2012-12-14 17:49:30 EET CONTEXT: xlog redo insert: rel 1663/1629517/12496; tid 23/20
2012-12-14 17:49:30 EET LOG: startup process (PID 25814) was terminated by signal 6: Aborted
2012-12-14 17:49:30 EET LOG: aborting startup due to startup process failure
Вложения
В списке pgsql-general по дате отправления: