Re: checkpoint write errors ( getting worse ) - Mailing list pgsql-general

would a dump/restore correct these issues?



On 10/22/2016 05:59 PM, Tom Lane wrote:
> CS DBA <cs_dba@consistentstate.com> writes:
>> So I ran REINDEX on all the db's and the errors went away for a bit. Now
>> I'm seeing this:
>> Log entries like this:FATAL:  could not read block 0 of relation
>> base/1311892067/2687: read only 0 of 8192 bytes
> You have a problem there, because:
>
> regression=# select 2687::regclass;
>         regclass
> ----------------------
>   pg_opclass_oid_index
> (1 row)
>
> which is a pretty critical index.
>
> You might be able to fix this by starting a single-user backend with -P
> (--ignore-system-indexes) and using it to REINDEX that index.
>
> On the whole, though, it's starting to sound like that system has
> got major problems.  You'd be well advised to focus all your efforts
> on getting a valid dump, not bringing it back into production.
>
>             regards, tom lane