9.2.4 specified item offset is too large, now what?

From: Tory M Blue <tmblue(at)gmail(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: 9.2.4 specified item offset is too large, now what?
Date: 2014-02-26 15:17:12
Message-ID: CAEaSS0afNB6YKSB-W-GNhVWpOFTTONs25ibzoaXBoNwh3pW8sw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

So I recently had some corruption, that forced a rebuild. At that time i
upgraded to my current release of 9.2.4 (stable in production for a time
and I know it's not the latest greatest).

So reloaded data, started loading more, things were good, several reboots
etc no issues.

This morning the system crashed again (so there may be some hardware
issues). But for now I need again ask if there is something in code I can
do vs a complete rebuild again.

014-02-26 07:09:16 PST LOG: database system was interrupted while in
recovery at 2014-02-26 07:05:09 PST
2014-02-26 07:09:16 PST HINT: This probably means that some data is
corrupted and you will have to use the last backup for recovery.
2014-02-26 07:09:16 PST LOG: database system was not properly shut
down; automatic recovery in progress
2014-02-26 07:09:16 PST LOG: redo starts at 9A/89505268
*2014-02-26 07:09:16 PST WARNING: specified item offset is too large*
2014-02-26 07:09:16 PST CONTEXT: xlog redo insert: rel
16398/16384/12765884; tid 9943/137
2014-02-26 07:09:16 PST PANIC: btree_insert_redo: failed to add item
2014-02-26 07:09:16 PST CONTEXT: xlog redo insert: rel
16398/16384/12765884; tid 9943/137
2014-02-26 07:09:16 PST LOG: startup process (PID 2391) was terminated
by signal 6: Aborted
2014-02-26 07:09:16 PST LOG: aborting startup due to startup process
failure
thanks again
Tory

Browse pgsql-performance by date

  From Date Subject
Next Message acanada 2014-02-26 15:41:31 Query taking long time
Previous Message Бородин Владимир 2014-02-26 06:32:32 Re: Problem with ExclusiveLock on inserts