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 по дате отправления: