Re: Postgres process is crashing continously in 9.1.1

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres process is crashing continously in 9.1.1
Date: 2012-05-22 10:41:36
Message-ID: CAPTjJmoLUt9SNszE8gqWPimpc7gLXpiTuJeom17ftTKRWeS4zQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

ChrisA

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2012-05-22 11:03:38 Re: how to for loop with distinct values?
Previous Message Jayashankar K B 2012-05-22 10:23:14 Re: Postgres process is crashing continously in 9.1.1