Thread: [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”
[BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”
From
digoal@126.com
Date:
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
[BUGS] Re: [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”
From
Michael Paquier
Date:
On Fri, Dec 30, 2016 at 11:12 AM, <digoal@126.com> wrote: > when our database upgrade from 9.4.2 to 9.4.8. > there some error when create table . You may want to use the latest 9.4.10, many bugs have been fixed since 9.4.8, including one that has the pattern you saw. > “could not read block 7 in file "base/16393/12769": read only 0 of 8192 > bytes” Have a look at the first item listed here: https://www.postgresql.org/docs/9.6/static/release-9-4-10.html "Fix WAL-logging of truncation of relation free space maps and visibility maps" -- Michael -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs