postgres PANIC : heap_insert_redo: failed to add tuple - Mailing list pgsql-general

From Alex Aseev
Subject postgres PANIC : heap_insert_redo: failed to add tuple
Date
Msg-id CANbzriT3h1kf2EaKEBcDqwu4AYwUjCuKcrDkjdxJ0CTjNeGnFQ@mail.gmail.com
Whole thread Raw
List 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
Attachment

pgsql-general by date:

Previous
From: "James B. Byrne"
Date:
Subject: Re: Problem starting PG-9.2 on non-default port
Next
From: Tom Lane
Date:
Subject: Re: initdb error