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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: digoal(at)126(dot)com
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [BUGS] BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”
Date: 2016-12-30 04:58:24
Message-ID: CAB7nPqSE7WA8++eU1wy_Ty4zqm66=ZMdeHxwFaQpX9eNVf=Kvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Dec 30, 2016 at 11:12 AM, <digoal(at)126(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message lpalmer 2016-12-30 12:42:13 BUG #14482: pgAdmin 4 Crash when Download as .CSV
Previous Message digoal 2016-12-30 02:12:15 BUG #14481: “could not read block 7 in file "base/16393/12769": read only 0 of 8192 bytes”