From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Андрей Репко <repko(at)sart(dot)must-ipra(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Server process exited with unexpected status 128. |
Date: | 2005-09-26 14:44:33 |
Message-ID: | 24486.1127745873@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
=?Windows-1251?Q?=C0=ED=E4=F0=E5=E9_=D0=E5=EF=EA=EE?= <repko(at)sart(dot)must-ipra(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-26 14:47:20 | Re: Server process exited with unexpected status 128. |
Previous Message | Dennis Bjorklund | 2005-09-26 14:40:03 | Re: roundoff problem in time datatype |