From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Chris Angelico <rosuav(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgres process is crashing continously in 9.1.1 |
Date: | 2012-05-22 13:01:53 |
Message-ID: | CAHyXU0xBhjFfL9k89YZri0aYYf+ofTNEa6rek=4jD+g7pLJsdw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 22, 2012 at 5:41 AM, Chris Angelico <rosuav(at)gmail(dot)com> wrote:
>
> On Tue, May 22, 2012 at 8:23 PM, Jayashankar K B
> <Jayashankar(dot)KB(at)lnties(dot)com> wrote:
> > But here, the crash is happening right at the insert statement. That is
> > insert itself is failing.
> > Unless the insert is successful, stored procedure is not triggered.
>
> Hmm. I wonder is it possible that going past ID 999 and into a
> four-digit number is causing stack damage that crashes the server a
> few iterations later... many things are possible. I'd look at the code
> of the procedure and see if there's any possible memory/stack issues.
Hm, on linux you check stack size with ulimit -s? If stack is set too
low, a lower setting of max_stack_depth should prevent the crash.
It's pretty hard to hit that unless you have extraordinarily complex
and/or recursive functions though.
Any chance of seeing the function source?
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2012-05-22 13:26:23 | Re: how to for loop with distinct values? |
Previous Message | Dmitriy Igrishin | 2012-05-22 11:03:38 | Re: how to for loop with distinct values? |