Re: PANIC: could not locate a valid checkpoint record - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PANIC: could not locate a valid checkpoint record
Date
Msg-id 11610.1132179702@sss.pgh.pa.us
Whole thread Raw
In response to PANIC: could not locate a valid checkpoint record  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: PANIC: could not locate a valid checkpoint record  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-hackers
Dave Cramer <pg@fastcrypt.com> writes:
> Nov 16 18:03:32 dx1-ptr postgres[23410]: [4-1] LOG:  shutting down
> Nov 16 18:03:35 dx1-ptr postgres[23410]: [5-1] LOG:  database system  
> is shut down
> Nov 16 18:21:18 dx1-ptr postgres[10884]: [1-1] LOG:  could not create  
> IPv6 socket: Address family not supported by protocol
> Nov 16 18:21:18 dx1-ptr postgres[10960]: [2-1] LOG:  database system  
> was shut down at 2005-11-16 18:03:35 GMT
> Nov 16 18:21:18 dx1-ptr postgres[10960]: [3-1] LOG:  could not open  
> file "/data/db/pgdata/pg_xlog/00000082000000E2" (log file 130, segm
> ent 226): No such file or directory
> Nov 16 18:21:18 dx1-ptr postgres[10960]: [4-1] LOG:  invalid primary  
> checkpoint record
> Nov 16 18:21:18 dx1-ptr postgres[10960]: [5-1] LOG:  could not open  
> file "/data/db/pgdata/pg_xlog/00000082000000E2" (log file 130, segm
> ent 226): No such file or directory
> Nov 16 18:21:18 dx1-ptr postgres[10960]: [6-1] LOG:  invalid  
> secondary checkpoint record
> Nov 16 18:21:18 dx1-ptr postgres[10960]: [7-1] PANIC:  could not  
> locate a valid checkpoint record

So what happened between 18:03 and 18:21 exactly?  If you don't have 
00000082000000E2, what files *do* you have in pg_xlog?  What does
pg_controldata print?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Some array semantics issues
Next
From: Martijn van Oosterhout
Date:
Subject: Re: MERGE vs REPLACE