org.postgresql.util.PSQLException: ERROR: invalid page header in block 5869177 of relation base/17291/17420

Поиск

Список

Период

Сортировка

От	Marcel Ruff
Тема	org.postgresql.util.PSQLException: ERROR: invalid page header in block 5869177 of relation base/17291/17420
Дата	18 марта 2013 г. 11:11:59
Msg-id	5146F675.7030700@marcelruff.info обсуждение
Ответы	Re: org.postgresql.util.PSQLException: ERROR: invalid page header in block 5869177 of relation base/17291/17420
Список	pgsql-novice

Дерево обсуждения

Hi,

I use
psql (PostgreSQL) 9.2.2
postgresql-9.2-1002.jdbc4.jar
java version "1.7.0_17" 64-Bit Server VM

on
Linux 3.4.28-2.20-default

with SSD
Intel 520 Series SSDs
smartctl -a /dev/sdc1 does not show me errors (afaik)

and get this error:
org.postgresql.util.PSQLException: ERROR: invalid page header in block 5869177 of relation base/17291/17420

I believe it is a kernel or HD problem and
my idea was to dump the data and install it on another HD:

pg_dump custdb > custdb-2013-03-18.dump
      pg_dump: Dumping the contents of table "location" failed: PQgetResult() failed.
      pg_dump: Error message from server: ERROR: invalid page header in block 5869177 of relation base/17291/17420
      pg_dump: The command was: COPY public.location (xxx) TO stdout;

I looks like that the dump stops.
What can I do to convince the dump to continue?
After migrating to another HD I could try to reimport lost data from log files etc.

What is the reason for this error?
What options do I have?

Thank you
Marcel

В списке pgsql-novice по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

org.postgresql.util.PSQLException: ERROR: invalid page header in block 5869177 of relation base/17291/17420