Re: PANIC: block 463 unfound during REDO after out of

Btw -"unfound"?? I think the English there might need to be improved :)

Chris

On 1/11/07, Richard Huxton <dev@archonet.com> wrote:
> Warren Guy wrote:
> > Hi everyone
> >
> > Was running a VACUUM on a database on a partition which was running out
> > of disk space. During VACUUM the server process died and failed to restart.
> >
> > Running PostgreSQL 8.1.4
>
> ...
> > Jan 11 15:02:39 marshall postgres[73909]: [5-1] FATAL:  the database
> > system is starting up
> > Jan 11 15:02:40 marshall postgres[73888]: [12-1] PANIC:  block 463 unfound
> > Jan 11 15:02:41 marshall postgres[67977]: [5-1] LOG:  startup process
> > (PID 73888) was terminated by signal 6
> > Jan 11 15:02:41 marshall postgres[67977]: [6-1] LOG:  aborting startup
> > due to startup process failure
>
> You say "was running out of disk space" - does that mean it did run out
> of disk space? I don't see the error that caused this, just the results.
> That would suggest to me that something unusual caused this (or you
> clipped the log fragment too far down :-)
>
> In any case, the first thing I'd try is to make your on-disk backups and
> set it up as though it's PITR recovery you're doing. That way you can
> stop the recovery before block 463 causes the failure. Oh, assuming
> you've got the space you need on your partition of course.
>
> HTH
> --
>    Richard Huxton
>    Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>


-- 
Chris Kings-Lynne
Director
KKL Pty. Ltd.

Biz: +61 8 9328 4780
Mob: +61 (0)409 294078
Web: www.kkl.com.au