Re: 8.0B2 checkpoint error on start up

From: elein <elein(at)varlena(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 8.0B2 checkpoint error on start up
Date: 2004-09-14 23:29:09
Message-ID: 20040914162909.D14937@cookie.varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Quick followup...The 8.0 db was only written to by slon
processes. This problem was replicated by someone else
as well.

The stomp around was to initdb in 8.0b2 and reset up
slony :-(

--elein

On Tue, Sep 14, 2004 at 01:48:54PM -0700, elein wrote:
> Upgrading 8.0b1 to 8.0b2 in place.
> Did I have to do a dump/restore?
> Or is this a known problem?
>
> --elein
>
> $ pg_ctl start -D $PGDATA
> postmaster starting
> /local/pgsql80/data[postgres:cookie]
> $ LOG: database system was shut down at 2004-09-14 13:40:43 PDT
> LOG: invalid magic number D05B in log file 0, segment 34, offset 7495680
> LOG: invalid primary checkpoint record
> LOG: invalid magic number D05B in log file 0, segment 34, offset 7438336
> LOG: invalid secondary checkpoint record
> PANIC: could not locate a valid checkpoint record
> LOG: startup process (PID 4574) was terminated by signal 6
> LOG: aborting startup due to startup process failure
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-09-15 04:31:26 Re: 8.0B2 checkpoint error on start up
Previous Message PostgreSQL Bugs List 2004-09-14 21:19:42 BUG #1254: CIDR check for no host-bit set has off-by-1 error in src/backend/utils/adt/network.c