pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedxlog flush request error
4+ messages / 2 participants
[nested] [flat]
* xlog flush request error
@ 2005-11-24 12:24 Vipul.Gupta@trilogy.com
2005-11-24 15:37 ` Re: xlog flush request error Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Vipul.Gupta@trilogy.com @ 2005-11-24 12:24 UTC (permalink / raw)
To: pgsql-performance
Hi ,
i get the following error on doing anything with the database after
starting it.
Can anyone suggest how do i fix this
xlog flush request 7/7D02338C is not satisfied --- flushed only to
3/2471E324
Vipul Gupta
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: xlog flush request error
2005-11-24 12:24 xlog flush request error Vipul.Gupta@trilogy.com
@ 2005-11-24 15:37 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2005-11-24 15:37 UTC (permalink / raw)
To: Vipul.Gupta@trilogy.com; +Cc: pgsql-performance
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.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: xlog flush request error
@ 2005-11-25 04:48 Vipul.Gupta@trilogy.com
2005-11-25 04:59 ` Re: xlog flush request error Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Vipul.Gupta@trilogy.com @ 2005-11-25 04:48 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-performance
Hi tom,
basically when i run any query with database say,
select count(*) from table1;
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
Regards,
Vipul Gupta
Tom Lane <tgl@sss.pgh.pa.us>
11/24/2005 09:07 PM
To: Vipul.Gupta@trilogy.com
cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] xlog flush request error
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.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: xlog flush request error
2005-11-25 04:48 Re: xlog flush request error Vipul.Gupta@trilogy.com
@ 2005-11-25 04:59 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2005-11-25 04:59 UTC (permalink / raw)
To: Vipul.Gupta@trilogy.com; +Cc: pgsql-performance
Vipul.Gupta@trilogy.com writes:
> ERROR: xlog flush request 7/7D02338C is not satisfied --- flushed only to
> 3/2471E324
> writing block 297776 of relation 1663/2110743/2110807
You need to fix or zero out that data block ...
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-11-25 04:59 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-24 12:24 xlog flush request error Vipul.Gupta@trilogy.com
2005-11-24 15:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-11-25 04:48 Re: xlog flush request error Vipul.Gupta@trilogy.com
2005-11-25 04:59 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox