ERROR could not read block xxx in file, read only 0 of 8192 bytes

Поиск
Список
Период
Сортировка
От Oracle People
Тема ERROR could not read block xxx in file, read only 0 of 8192 bytes
Дата
Msg-id CAKTviG-qAoQwOumo2Q2woRnjfZhf2uPoiq1AO8wJG04O=84HqA@mail.gmail.com
обсуждение исходный текст
Ответы Re: ERROR could not read block xxx in file, read only 0 of 8192 bytes  (Adrien Nayrat <adrien.nayrat@anayrat.info>)
Список pgsql-admin
We have a few Postgres 16.2 servers running on VMs (RHEL 9.3) created on VMware vSphere (7.0.3).  3PAR LUNs are used as their storages.

On a couple of the PostgreSQL servers, there are errors such as:

ERROR:  could not read block 1264 in file "base/16520/59258": read only 0 of 8192 bytes

The errors occured when trying to insert rows to the tables.

The blocks belong to tables. For instance,

select relname, relkind from pg_class where relfilenode = '59258';
    relname    | relkind
---------------+---------
 smallgroupset | r`

I can pg_dump the all the rows of the table smallgroupset and there is no data loss.

pg_dump -d tabula -t smallgroupset -f smallgroupset.sql -v > smallgroupset.log 2>&1

I've tried to reindex the table ( and the whole database) but it made no difference.

Can anyone advise the root cause of the errors?

Any help will be much appreciated.

orclp

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

Предыдущее
От: Andreas Wagner
Дата:
Сообщение: Re: From CROSSTAB: One Column data with Two results columns
Следующее
От: Adrien Nayrat
Дата:
Сообщение: Re: ERROR could not read block xxx in file, read only 0 of 8192 bytes