| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | davi vidal <davividal(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org, Bruce Momjian <bruce(at)momjian(dot)us> |
| Subject: | Re: BUG #12617: DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112: Success. |
| Date: | 2015-01-22 20:39:49 |
| Message-ID: | 20150122203949.GI1663@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
davi vidal wrote:
> On Thu, Jan 22, 2015 at 3:48 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
> wrote:
>
> > davi vidal wrote:
> > > On Thu, Jan 22, 2015 at 1:18 PM, Alvaro Herrera <
> > alvherre(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim | 2015-01-23 18:17:59 | BUG #12644: Planner fails to use available index with anything other than default operator |
| Previous Message | davi vidal | 2015-01-22 18:09:50 | Re: BUG #12617: DETAIL: Could not read from file "pg_subtrans/06F8" at offset 90112: Success. |