| From: | Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)info> |
|---|---|
| To: | Oracle People <oraclepeople(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: ERROR could not read block xxx in file, read only 0 of 8192 bytes |
| Date: | 2024-04-15 12:20:36 |
| Message-ID: | b9b0eaa5-e19a-40b2-a122-41305e01cba7@anayrat.info |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 :
Regards,
--
Adrien NAYRAT
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M Sarwar | 2024-04-15 12:25:55 | Re: From CROSSTAB: One Column data with Two results columns |
| Previous Message | Oracle People | 2024-04-15 09:30:04 | ERROR could not read block xxx in file, read only 0 of 8192 bytes |