Re: server resetting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Geoffrey <esoteric(at)3times25(dot)net>
Cc: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: server resetting
Date: 2006-09-18 20:28:29
Message-ID: 3868.1158611309@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alberto Molteni 2006-09-18 20:37:56 Re: Restore data from old installation
Previous Message timasmith 2006-09-18 20:06:09 Upgrading schemas