Re: Server process exited with unexpected status 128.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Server process exited with unexpected status 128.
Дата
Msg-id 24486.1127745873@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Server process exited with unexpected status 128.  (Андрей Репко<repko@sart.must-ipra.com>)
Список pgsql-hackers
Андрей Репко <repko@sart.must-ipra.com> writes:
> When I try to execute the next SQL statement, sever was crashed:

>  DELETE FROM ma_data WHERE id in (-1,212803,..... );
>  ... - is 500k text like id separated by ",". Its about 100000 values.

I wouldn't be too surprised that that ran the server out of memory.  The
recovery ought to be a little more graceful though :-( ... and it is, on
my machine:

ERROR:  stack depth limit exceeded
HINT:  Increase the configuration parameter "max_stack_depth".
CONTEXT:  SQL statement "DELETE FROM ma_data WHERE id in (1,2,3,4,5,6,7,8,
... much omitted ...
99990,99991,99992,99993,99994,99995,99996,99997,99998,99999,100000,0);"PL/pgSQL function "blowup" line 7 at execute
statement

I'm guessing something wrong with the stack depth check on Windows.
It's passing the regression test though, so maybe the issue is specific
to your machine?  What variant of Windows have you got exactly?
        regards, tom lane


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

Предыдущее
От: Dennis Bjorklund
Дата:
Сообщение: Re: roundoff problem in time datatype
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Server process exited with unexpected status 128.