Re: Server process exited with unexpected status 128.

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

In response to

Browse pgsql-hackers by date

  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