Re: server resetting

From: Geoffrey <esoteric(at)3times25(dot)net>
To: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: server resetting
Date: 2006-09-18 20:46:15
Message-ID: 450F0597.6050800@3times25.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Geoffrey <esoteric(at)3times25(dot)net> writes:
>> Problem is, we seem to be having a problem with this reset issue and I
>> don't see a correlation in the backtraces. Most of them are in fact
>> related to inserts, but there are at least three different tables
>> involved. There are also some where an INSERT is not involved. I've
>> attached three more backtraces from different core files to provide
>> further data and hopefully pinpoint this issue.
>
> Well, these make it clear that you've got some pretty big chunks of
> nonstandard code in the backend, so my first thought is that there's a
> memory-clobber bug somewhere in that. It might be worth trying to run
> the code with a debugging malloc library (ElectricFence or some such)
> to try to locate the culprit.

I'm not sure what you mean by 'nonstandard code,' could you expand on
that? All the trigger code is written in plpgsql. Are you suggesting
we're stomping on our own memory within the trigger code we've written?

--
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message vtaquette 2006-09-18 22:47:25 duplicate key violates unique constraint
Previous Message Alberto Molteni 2006-09-18 20:37:56 Re: Restore data from old installation