Обсуждение: recover from this error
On Fri, Apr 8, 2016 at 11:44 AM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
Alright, check kernel version, but what else, dump & restore?
ERROR: unexpected data beyond EOF in block 1 of relation base/16388/35954
HINT: This has been seen to occur with buggy kernels; consider updating your system.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> 16388/35954 = DB/object
1.Get the object that is causing the problem:
SELECT datname FROM pg_database WHERE oid = 16388;
SELECT relname,
CASE
WHEN relkind = 'r' THEN 'TABLE'
WHEN relkind = 'i' THEN 'INDEX'
WHEN relkind = 'S' THEN 'SEQUENCE'
WHEN relkind = 'v' THEN 'VIEW'
WHEN relkind = 'c' THEN 'VIEW'
WHEN relkind = 'f' THEN 'Foreign Table'
ELSE 'Unknown'
END
FROM pg_class
WHERE relfilenode = 35954;
Make sure you have a good backup then:
2. DROP the bad object.
3. RESTORE the object.
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.