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

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

            regards, tom lane

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Determining weather a query fired a trigger
Следующее
От: Jeff Amiel
Дата:
Сообщение: More SSL crash woes