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

Re: toast error after pg_upgrade 9.0.4 -> 9.1rc1

From: Lou Picciano <loupicciano(at)comcast(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: toast error after pg_upgrade 9.0.4 -> 9.1rc1
Date: 2011-09-01 03:00:55
Message-ID: 380511541.722458.1314846055794.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers

----- Original Message -----
From: "Bruce Momjian" <bruce(at)momjian(dot)us> 
To: "Lou Picciano" <loupicciano(at)comcast(dot)net> 
Cc: pgsql-hackers(at)postgresql(dot)org 
Sent: Wednesday, August 31, 2011 10:38:01 PM 
Subject: Re: [HACKERS] toast error after pg_upgrade 9.0.4 -> 9.1rc1 

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

Bruce, many thanks. I've done the recent git pull; yes, will build head from there and send you the new mileage report. 

(Glad your weekend with Irene is finally over - we had a few crises down here in New York; my fish were swimming in the back yard, lots of flooding, a few trees down - one of which only prevented from falling on the house by the 16K volt primary line. Great! But we were luckier than many. ) 

Lou Picciano 

In response to

pgsql-hackers by date

Next:From: hubert depesz lubaczewskiDate: 2011-09-01 06:05:51
Subject: Re: [GENERAL] pg_upgrade problem
Previous:From: Bruce MomjianDate: 2011-09-01 02:43:05
Subject: Re: toast error after pg_upgrade 9.0.4 -> 9.1rc1

pgsql-general by date

Next:From: David JohnstonDate: 2011-09-01 04:20:25
Subject: Re: function on trigger
Previous:From: Bruce MomjianDate: 2011-09-01 02:43:05
Subject: Re: toast error after pg_upgrade 9.0.4 -> 9.1rc1

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