Re: BUG #12617: DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112: Success. - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #12617: DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112: Success.
Date
Msg-id 20150122203949.GI1663@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #12617: DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112: Success.  (davi vidal <davividal@gmail.com>)
List pgsql-bugs
davi vidal wrote:
> On Thu, Jan 22, 2015 at 3:48 PM, Alvaro Herrera <alvherre@2ndquadrant.com>
> wrote:
>
> > davi vidal wrote:
> > > On Thu, Jan 22, 2015 at 1:18 PM, Alvaro Herrera <
> > alvherre@2ndquadrant.com>
> > > wrote:
> >
> > > The 9.1 cluster is empty.
> > >
> > >
> > > # ls -a /var/lib/pgsql/9.4/data/pg_subtrans/
> > > .  ..  06F8
> >
> > How big is this file?
> >
> 40 KB
>
> I can't open it using vim.

Yeah, it's a binary file, don't worry about that.

Anyway that's pretty odd.  I assume that your blocksize is 8 kB.  Then
this file is 5 pages long, but the system is asking for data that should
be in page 11.  For some reason 6 page extensions in pg_subtrans were
ignored?  That sounds really odd.

I'm also surprised that the subdir in 9.1 is empty.  The file certainly
should still be there.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: davi vidal
Date:
Subject: Re: BUG #12617: DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112: Success.
Next
From: Jim@mcdee.net
Date:
Subject: BUG #12644: Planner fails to use available index with anything other than default operator