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

From Michael Paquier
Subject [BUGS] Re: [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”
Date
Msg-id CAB7nPqSE7WA8++eU1wy_Ty4zqm66=ZMdeHxwFaQpX9eNVf=Kvw@mail.gmail.com
Whole thread Raw
In response to [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”  (digoal@126.com)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”
Next
From: lpalmer@unitylink.com
Date:
Subject: [BUGS] BUG #14482: pgAdmin 4 Crash when Download as .CSV