It gives me the following error trace: WARNING: could not write block 297776 of 1663/2110743/2110807 DETAIL: Multiple failures --- write error may be permanent. ERROR: xlog flush request 7/7D02338C is not satisfied --- flushed only to 3/2471E324 writing block 297776 of relation 1663/2110743/2110807 xlog flush request 7/7D02338C is not satisfied --- flushed only to 3/2471E324 xlog flush request 7/7D02338C is not satisfied --- flushed only to 3/2471E324\q
i tried using pg_resetxlog but till date, have not been able to solve this problem
Vipul.Gupta@trilogy.com writes: > Can anyone suggest how do i fix this
> xlog flush request 7/7D02338C is not satisfied --- flushed only to > 3/2471E324
This looks like corrupt data to me --- specifically, garbage in the LSN field of a page header. Is that all you get? PG 7.4 and up should tell you the problem page number in a CONTEXT: line.