postgres PANIC : heap_insert_redo: failed to add tuple

From: Alex Aseev <theleksey(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres PANIC : heap_insert_redo: failed to add tuple
Date: 2012-12-14 18:04:18
Message-ID: CANbzriT3h1kf2EaKEBcDqwu4AYwUjCuKcrDkjdxJ0CTjNeGnFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-12-14 18:28:52 Re: initdb error
Previous Message James B. Byrne 2012-12-14 17:54:16 Re: Problem starting PG-9.2 on non-default port