[BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes” - Mailing list pgsql-bugs

From digoal@126.com
Subject [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”
Date
Msg-id 20161230021215.10141.46915@wrigleys.postgresql.org
Whole thread Raw
Responses [BUGS] Re: [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14481
Logged by:          Zhou Digoal
Email address:      digoal@126.com
PostgreSQL version: 9.4.8
Operating system:   CentOS 6.x x64
Description:

when our database upgrade from 9.4.2 to 9.4.8.
there some error when create table .

“could not read block 7 in file "base/16393/12769": read only 0 of 8192
bytes”

# select relname,relkind from pg_class where pg_relation_filepath(oid) ~
'16393/12769';
  relname   | relkind 
------------+---------
 pg_attrdef | r
(1 row)

after vacuum pg_attrdef 

it's no error now.

but i don't known why?  

this database is protect by these parameter :  
datachecksum=on
fsync=on
full page write=on
sync commit =on

best regards
digoal



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Keith Fiske
Date:
Subject: Re: [BUGS] 9.6rc1 Background worker starting multiple times
Next
From: Michael Paquier
Date:
Subject: [BUGS] Re: [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”