Re: Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?!

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?!
Date: 2012-06-13 18:32:21
Message-ID: 20120613183221.GC4418@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 07, 2012 at 09:16:49PM +0200, hubert depesz lubaczewski wrote:
> hi
> I just upgraded test copy of database of our customer (~ 600GB of data).
> upgrade went fine, no errors. but vacuumdb -azv ended with an error:
>
> => vacuumdb --all --analyze -p 6665
> vacuumdb: vacuuming database "client_db"
> vacuumdb: vacuuming database "pg_audit"
> vacuumdb: vacuuming database "postgres"
> vacuumdb: vacuuming of database "postgres" failed: ERROR: could not access status of transaction 860626316
> DETAIL: Could not open file "pg_clog/0334": No such file or directory.
>
> I know we had these kind of errors before, but I thought they all got fixed.
>
> What can I do to debug it more?
>
> 8.3 was 8.3.16.
> 8.3.16 is from rpms, 9.1.4 is from source compilation.
>
> both have integer datatimes, and both are for 64bit linux.

I assume 8.3 vacuumdb did not generate these errors. If it was 8.4 I
would suggest it was because we don't copy visibility map files from
pre-9.1 because those were not crash-safe, but 8.3 didn't have
visibility map files (added in PG 8.4), so 8.3 should have been checking
the exact same transaction ids as 9.1.

Basically, I can't think of a cause.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2012-06-13 18:43:23 Re: Problem with pg_upgrade 8.3 to 9.1.4 - clog missing?!
Previous Message Merlin Moncure 2012-06-13 17:41:42 Re: Create view is not accepting the parameter in postgres functions