Re: unexpected and reproducable crash in pl/pgsql function

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: unexpected and reproducable crash in pl/pgsql function
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A7637@Herge.rcsinc.local
обсуждение исходный текст
Ответ на unexpected and reproducable crash in pl/pgsql function  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Ответы Re: unexpected and reproducable crash in pl/pgsql function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I wrote:
> Ok, I have a fairly nasty situation.  I am having a production server
> that is crashing upon execution of a pl/pgsql function...on code that
> has been working flawlessly for weeks.  My production server is
running
> 8.0 on win32 and I was able to 'sort-of' reproduce the behavior on my
> development machine here at the office.

Ok, problem was due to recursive pl/pgsql function and a recursion loop
in the data.  I traced this problem to the data: somebody disabled the
recursion check constraint.

I've never had this actually happen before.  It totally nuked the
server.

Merlin

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: logging as inserts
Следующее
От: Tom Lane
Дата:
Сообщение: Re: logging as inserts