From: | "Christopher Kings-Lynne" <chris(at)kkl(dot)com(dot)au> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com> |
Cc: | "Warren Guy" <warren(dot)guy(at)calorieking(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PANIC: block 463 unfound during REDO after out of |
Date: | 2007-01-12 02:07:38 |
Message-ID: | 1acfe1a40701111807k40441c78neaa8ad49ff5ef430@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Btw -"unfound"?? I think the English there might need to be improved :)
Chris
On 1/11/07, Richard Huxton <dev(at)archonet(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2007-01-12 02:19:06 | Re: share info between backends |
Previous Message | Neil Conway | 2007-01-12 02:04:12 | NaN behavior |