ERROR: XX001: could not read block 2354 of relation…

Поиск
Список
Период
Сортировка
От Patrick Desjardins
Тема ERROR: XX001: could not read block 2354 of relation…
Дата
Msg-id aaff70a90903311310u429e8722y420540da40d36312@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation…  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation…  (Emanuel Calvo Franco <postgres.arg@gmail.com>)
Список pgsql-general
Hi,

I have the error ERROR: XX001: could not read block 2354 of relation 1663/17633/17925: read only 0 of 8192 bytes, but only sometime, when trying to Insert data into a table. I would say that 99% of Insert works and 100% of read works. This is only happenning since few weeks. I have done Vaccum Analyze without any success (the vaccum take 65 minutes but nothing is fixed, still have the ERROR XXX001). I have this error in the backend application and when I do some Insert Query in the PgAdmin tool.

What can I do to fix that problem?

Thank you,

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Server Performance
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Space for pg_dump