Write errors in postgres log

From: "CAJ CAJ" <pguser(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Write errors in postgres log
Date: 2007-02-19 05:20:35
Message-ID: 467669b30702182120y2d7f18bej9f9d68b6c1ffe734@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We have 2 servers running postgres database 8.0.3 serving a web application.
Recently, we started having problems with the web application and diagnosis
lead to the following errors repeated in the postgres log files on both the
servers.

==========================================
CONTEXT: writing block 754 of relation 1663/17230/17443
WARNING: could not write block 754 of 1663/17230/17443
DETAIL: Multiple failures --- write error may be permanent.
ERROR: xlog flush request 2/66B19020 is not satisfied --- flushed only to
2/5F8F95A2 ...
===========================================

Both the servers are running independently and geographically apart. We
don't think there is anything wrong with the hardware and this error seem to
get worse and worse over time.

Trying to recover from the error,

1. pg_reset_xlog did not work.
2. Recent backups are corrupted as well.

Any advice to recover and pin point the cause of the error will be
appreciated.

Thanks in advance

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2007-02-19 06:06:24 delete from ... where not in
Previous Message Tom Lane 2007-02-19 02:40:05 Re: invalid regular expression: invalid backreference number