On 8 April 2011 00:16, Alvaro Herrera <alvherre@commandprompt.com> wrote:
> Excerpts from Brendan Jurd's message of jue abr 07 03:07:32 -0300 2011:
>> I am running a 9.0.3 Hot Standy + Streaming Replication slave which
>> occasionally segfaults (every 1-2 days). I rebuilt Postgres with
>> --enable-cassert and --enable-debug, switched on core dumping and
>> waited for some results.
>
> What's the platform, and what's the query? Are there funny datatypes
> involved?
Ubuntu 10.04 x64 on:
HP DL380R05
1x Quad Core Xeon E5440
10GB PC 5400 DDR ECC
2x HP 146GB 15krpm SAS drives in RAID 1+0
The tomcat instance repeatedly runs a series of some 9 queries, I'm
not sure which of the queries is the culprit or even whether it is the
same one each time. However, they are all straightforward SELECTs.
The one with the most complicated plan joins a whole six tables. I do
keep the transaction open until I have executed all the SELECTs in the
series, then commit and start over again with a fresh transaction.
That's just to make sure all of the queries are pulling data from the
same snapshot.
As for datatypes, I do have one type that I have defined which is used
in one of the queries. It's just an RGB colour value, defined as a
composite type:
CREATE DOMAIN colour_channel AS smallint CHECK (VALUE >= 0 AND VALUE < 256);
CREATE TYPE rgb AS ( red colour_channel, green colour_channel, blue colour_channel
);
All of the user-defined functions I have written for this db are
either SQL or PL/pgSQL, and all of the functions called by these
queries are either STABLE or IMMUTABLE.
Cheers,
BJ