Re: Postgres process is crashing continously in 9.1.1 - Mailing list pgsql-general

From Chris Angelico
Subject Re: Postgres process is crashing continously in 9.1.1
Date
Msg-id CAPTjJmoLUt9SNszE8gqWPimpc7gLXpiTuJeom17ftTKRWeS4zQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgres process is crashing continously in 9.1.1  (Jayashankar K B <Jayashankar.KB@lnties.com>)
Responses Re: Postgres process is crashing continously in 9.1.1
List pgsql-general
On Tue, May 22, 2012 at 8:23 PM, Jayashankar K B
<Jayashankar.KB@lnties.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

pgsql-general by date:

Previous
From: Jayashankar K B
Date:
Subject: Re: Postgres process is crashing continously in 9.1.1
Next
From: Dmitriy Igrishin
Date:
Subject: Re: how to for loop with distinct values?