| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Matt <matthew(at)zeut(dot)net> |
| Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: FATAL Error |
| Date: | 2006-08-08 01:46:57 |
| Message-ID: | 24365.1155001617@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Matt <matthew(at)zeut(dot)net> writes:
> I'm getting the following error on PGSQL 8.0.8 server that I admin. I
> don't think this is a hardware problem but I'm not sure. Anyway in the
> logfile I'm constantly getting this:
> ERROR: xlog flush request 2/13CEA8AC is not satisfied --- flushed only
> to 2/13634EE4
> CONTEXT: writing block 3421 of relation 1663/9533957/9534098
This indicates that the LSN word of that block contains 2/13CEA8AC,
which is impossibly large if WAL currently extends only to 2/13634EE4.
Have you had any crashes or other odd behavior recently?
What files do you see in $PGDATA/pg_xlog/? Can you grab a copy of
pg_filedump and look at what the block contains on-disk?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-08-08 01:57:37 | Re: DROP TABLESPACE fails |
| Previous Message | Berend Tober | 2006-08-08 00:38:25 | Re: Disabling and enabling constraints and triggers to |