Re: C function fails afeter create extension but ok after reconnect - Mailing list pgsql-general

From Tom Lane
Subject Re: C function fails afeter create extension but ok after reconnect
Date
Msg-id 12140.1369013813@sss.pgh.pa.us
Whole thread Raw
In response to C function fails afeter create extension but ok after reconnect  (Stephen Woodbridge <imaptools@gmail.com>)
List pgsql-general
Stephen Woodbridge <imaptools@gmail.com> writes:
> I have a C function that works fine in all cases except if I try to run
> it after create extension without reconnecting to the database.

There's not nearly enough info here to diagnose the problem, but
if I had to bet I'd bet on a memory-management bug that just
accidentally fails to fail in the freshly-reconnected case.

The first thing you should do, if you didn't already, is to build
the backend with --enable-cassert to turn on assorted memory allocation
checks.  That might make the bug happen consistently, which would be
a good thing.  After that, I'd try capturing a stack trace from the
point of the error report, in hopes of narrowing down what code is
causing the problem.

            regards, tom lane


pgsql-general by date:

Previous
From: Toby Corkindale
Date:
Subject: Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Next
From: David Boreham
Date:
Subject: Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID