Search Postgresql Archives

Re: checkpoint write errors ( getting worse )

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



would a dump/restore correct these issues?



On 10/22/2016 05:59 PM, Tom Lane wrote:
CS DBA <cs_dba@xxxxxxxxxxxxxxxxxxx> 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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux