Re: "too many trigger records found for relation xyz"

Поиск
Список
Период
Сортировка
От Mikko Partio
Тема Re: "too many trigger records found for relation xyz"
Дата
Msg-id 2ca799770804081137l2f1c8620o948659f203d1d14c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: "too many trigger records found for relation xyz"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general


On Tue, Apr 8, 2008 at 9:30 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Mikko Partio" <mpartio@gmail.com> writes:
> On Tue, Apr 8, 2008 at 6:38 PM, Zdenek Kotala <Zdenek.Kotala@sun.com> wrote:
>> It is really strange. It would be nice to have reproduce scenario. Can you
>> run same DDL command which invoke a catalog corruption on test database
>> cluster?

> I tried it on a fresh instance but it went through with no errors  :(

Is it possible that anything was doing a VACUUM FULL on pg_class
concurrently with your schema changes on these tables?  The behavior
looks suspiciously like some problems we've seen before wherein rows
ended up with the wrong commit-bit markings...

I may have had a VACUUM FULL on some of my own tables but definitely not on any system tables. There was also a bunch (maybe 10) autovacuum processes working at that time.

Regards

Mikko

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Amiel
Дата:
Сообщение: More SSL crash woes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: More SSL crash woes