| From: | CS DBA <cs_dba(at)consistentstate(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | checkpoint write errors |
| Date: | 2016-10-21 15:49:11 |
| Message-ID: | ea6993d1-3d09-e238-88a1-0a0a6edd5405@consistentstate.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all;
we're seeing the below errors over and over in the logs of one of our
postgres databases. Version 8.4.22
Anyone have any thoughts on correcting/debugging it?
Maybe I need to run a REINDEX on whatever table equates to
"base/1029860192/1029863651"? If so how do I determine the db and table
for "base/1029860192/1029863651"?
LOG: checkpoint starting: time
ERROR: xlog flush request 2571/9C141530 is not satisfied --- flushed
only to 2570/DE61C290
CONTEXT: writing block 4874 of relation base/1029860192/1029863651
WARNING: could not write block 4874 of base/1029860192/1029863651
DETAIL: Multiple failures --- write error might be permanent.
Thanks in advance
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-10-21 16:48:50 | Re: Doubts about replication from many servers |
| Previous Message | Cachique | 2016-10-21 15:30:37 | Re: Doubts about replication from many servers |