Aniket Kulkarni <aniket_kulkarni@persistent.co.in> writes:
> Recently I got this error while the database was starting up. :
> FATAL 2: XLogWrite: writerequest is past end of log
> And the database did not startup, and finally I had to do a
> pg_resetxlog. I tried going through the code which gave
> this error but I was unable to comprehend much.
> Could anyone tell me how exactly this error is caused.
XLogWrite? Not XLogFlush? That'd be a new one on me. Too bad you
flushed the broken xlog, I would have liked to look at it.
There is a known failure path (believed fixed in 7.2) whereby garbage
data in pg_log pages can lead to XLogFlush startup failures.
regards, tom lane