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
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 |