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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux