Thread: ERROR: XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to AF/50F15ABC

Dear All,

I am using postgres 7.3 version on RHEL 4.0.
My database has been restored.
All tables all working fine i.e select , update but on a particular table
its showing error

ERROR:  XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to
AF/50F15ABC

I have searched other threads, it shows the problem may be due to garbage in
the LSN field of a page header.
Now what is the solution to this problem.

Utsav Turray
--
View this message in context:
http://www.nabble.com/ERROR%3A--XLogFlush%3A-request-AF-5703EDC8-is-not-satisfied-----flushed-only-to-AF-50F15ABC-tp24895088p24895088.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

utsav.turray wrote:
> Dear All,
>
> I am using postgres 7.3 version on RHEL 4.0.
> My database has been restored.
> All tables all working fine i.e select , update but on a particular table
> its showing error
>
> ERROR:  XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only to
> AF/50F15ABC
>
> I have searched other threads, it shows the problem may be due to garbage in
> the LSN field of a page header.
> Now what is the solution to this problem.

1. Dump the database immediately so you have a backup.
2. Check that you can restore from that backup.
3. Make sure you are running the latest release of 7.3 - 7.3.21
available from ftp://ftp-archives.postgresql.org/
4. Upgrade as soon as is practical 7.4 was released in 2003 and we are
currently on 8.4
5. Test your hardware - disk errors might have caused this.

If you are having problems dumping the database you might need to
identify which table and set of records is giving you problems and
exclude those.

--
   Richard Huxton
   Archonet Ltd

Dear Richard,

I can't exclude the table because it is important table.
Is there any way , i could get the data back.

Utsav


Richard Huxton wrote:
>
> utsav.turray wrote:
>> Dear All,
>>
>> I am using postgres 7.3 version on RHEL 4.0.
>> My database has been restored.
>> All tables all working fine i.e select , update but on a particular table
>> its showing error
>>
>> ERROR:  XLogFlush: request AF/5703EDC8 is not satisfied --- flushed only
>> to
>> AF/50F15ABC
>>
>> I have searched other threads, it shows the problem may be due to garbage
>> in
>> the LSN field of a page header.
>> Now what is the solution to this problem.
>
> 1. Dump the database immediately so you have a backup.
> 2. Check that you can restore from that backup.
> 3. Make sure you are running the latest release of 7.3 - 7.3.21
> available from ftp://ftp-archives.postgresql.org/
> 4. Upgrade as soon as is practical 7.4 was released in 2003 and we are
> currently on 8.4
> 5. Test your hardware - disk errors might have caused this.
>
> If you are having problems dumping the database you might need to
> identify which table and set of records is giving you problems and
> exclude those.
>
> --
>    Richard Huxton
>    Archonet Ltd
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

--
View this message in context:
http://www.nabble.com/ERROR%3A--XLogFlush%3A-request-AF-5703EDC8-is-not-satisfied-----flushed-only-to-AF-50F15ABC-tp24895088p25004248.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

utsav.turray wrote:
>
> Dear Richard,
>
> I can't exclude the table because it is important table.
> Is there any way , i could get the data back.

Dump it and restore the dump.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.