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  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_restore --no-post-data and --post-data-only
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Ensure that contrib/pgstattuple functions respond to cancel