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

Поиск
Список
Период
Сортировка
От Adrien Nayrat
Тема Re: ERROR could not read block xxx in file, read only 0 of 8192 bytes
Дата
Msg-id b9b0eaa5-e19a-40b2-a122-41305e01cba7@anayrat.info
обсуждение исходный текст
Ответ на ERROR could not read block xxx in file, read only 0 of 8192 bytes  (Oracle People <oraclepeople@gmail.com>)
Ответы Re: ERROR could not read block xxx in file, read only 0 of 8192 bytes
Список pgsql-admin
Дерево обсуждения 
Hello,

On 4/15/24 11:30 AM, Oracle People wrote:
> 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.

It looks like the same bug as 
https://www.postgresql.org/message-id/flat/1878547.tdWV9SEqCh%40aivenlaptop

Maybe you can try to rebuild FSM : 
https://wiki.postgresql.org/wiki/Free_Space_Map_Problems#Cleanup_of_broken_FSM_files

FYI, a fix has been committed :

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=93582974315174d544592185d797a2b44696d1e5


Regards,

-- 
Adrien NAYRAT

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

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