From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Dave Cramer <pg(at)fastcrypt(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PANIC: could not locate a valid checkpoint record |
Date: | 2005-11-16 22:21:42 |
Message-ID: | 11610.1132179702@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Dave Cramer <pg(at)fastcrypt(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-11-16 22:33:59 | Re: PG_DUMP and table locking in PG7.4 |
Previous Message | Tom Lane | 2005-11-16 22:18:41 | Re: Some array semantics issues |