pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Adrien Nayrat <adrien.nayrat@anayrat.info>
To: Oracle People <oraclepeople@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: ERROR could not read block xxx in file, read only 0 of 8192 bytes
Date: Mon, 15 Apr 2024 14:20:36 +0200
Message-ID: <b9b0eaa5-e19a-40b2-a122-41305e01cba7@anayrat.info> (raw)
In-Reply-To: <CAKTviG-qAoQwOumo2Q2woRnjfZhf2uPoiq1AO8wJG04O=84HqA@mail.gmail.com>
References: <CAKTviG-qAoQwOumo2Q2woRnjfZhf2uPoiq1AO8wJG04O=84HqA@mail.gmail.com>

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=93582974315174d544592185d797a2b44696d...


Regards,

-- 
Adrien NAYRAT







view thread (4+ messages)  latest in thread

Message-ID: <b9b0eaa5-e19a-40b2-a122-41305e01cba7@anayrat.info>
Permalink:  ../b9b0eaa5-e19a-40b2-a122-41305e01cba7@anayrat.info/
Also on:    postgresql.org/message-id/b9b0eaa5-e19a-40b2-a122-41305e01cba7@anayrat.info

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: adrien.nayrat@anayrat.info, oraclepeople@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: ERROR could not read block xxx in file, read only 0 of 8192 bytes
  In-Reply-To: <b9b0eaa5-e19a-40b2-a122-41305e01cba7@anayrat.info>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox