Skip site navigation (1) Skip section navigation (2)

Re: toast error after pg_upgrade 9.0.4 -> 9.1rc1

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Lou Picciano <loupicciano(at)comcast(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: toast error after pg_upgrade 9.0.4 -> 9.1rc1
Date: 2011-09-01 02:38:01
Message-ID: 201109010238.p812c1p27084@momjian.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Lou Picciano wrote:
> After running an essentially uneventful* pg_upgrade from 9.0.4 ->
> 9.1rc1, we are seeing some toast errors logged on the new cluster:
> 
> All are of this pattern: ERROR: missing chunk number 0 for toast value
> 130087 in pg_toast_34735
> 
> Have seen the same pattern for a few of the databases in the 9.1rc1
> cluster, and all as a result of a select on a usr table (the offending
> SELECT happens to be the first one any of these DBs sees, as it's the
> first step in a user authentication process). SELECT count(*) does not
> produce an error.
> 
> *almost uneventful: We also saw messages that the destination cluster
> did not have one of our schema - (of course it didn't!) - I didn't
> realize pg_upgrade doesn't 'do' schema?

I have fixed two errors in pg_upgrade since 9.1rc1 was released.  Can
you use git 9.1 head or wait for 9.1rc2 or 9.1 final?  I can email you
patches if you prefer.

--
  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

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2011-09-01 02:43:05
Subject: Re: toast error after pg_upgrade 9.0.4 -> 9.1rc1
Previous:From: Bruce MomjianDate: 2011-09-01 01:56:59
Subject: Re: [GENERAL] pg_upgrade problem

pgsql-general by date

Next:From: Bruce MomjianDate: 2011-09-01 02:43:05
Subject: Re: toast error after pg_upgrade 9.0.4 -> 9.1rc1
Previous:From: Bruce MomjianDate: 2011-09-01 01:56:59
Subject: Re: [GENERAL] pg_upgrade problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group