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
