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

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