toast error after pg_upgrade 9.0.4 -> 9.1rc1
От | Lou Picciano |
---|---|
Тема | toast error after pg_upgrade 9.0.4 -> 9.1rc1 |
Дата | |
Msg-id | 239726088.702769.1314821475533.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net обсуждение исходный текст |
Ответ на | Re: [GENERAL] pg_upgrade problem (Bruce Momjian <bruce@momjian.us>) |
Ответы |
Re: toast error after pg_upgrade 9.0.4 -> 9.1rc1
|
Список | pgsql-hackers |
<div style="font-family: Verdana; font-size: 12pt; color: #000000">After running an essentially uneventful* pg_upgrade from9.0.4 -> 9.1rc1, we are seeing some toast errors logged on the new cluster:<br /><br />All are of this pattern: ERROR: missing chunk number 0 for toast value 130087 in pg_toast_34735<br /><br />Have seen the same pattern for a few ofthe databases in the 9.1rc1 cluster, and all as a result of a select on a usr table (the offending SELECT happens to bethe first one any of these DBs sees, as it's the first step in a user authentication process). SELECT count(*) does notproduce an error.<br /><br />*almost uneventful: We also saw messages that the destination cluster did not have one ofour schema - (of course it didn't!) - I didn't realize pg_upgrade doesn't 'do' schema?<br /><br />Lou Picciano<br /></div>
В списке pgsql-hackers по дате отправления: