From: Tom Lane <tgl@sss.pgh.pa.us>
To: Poul Møller Hansen <freebsd@pbnet.dk>
Cc: pgsql-general@postgresql.org
Subject: Re: Segmentation Fault
Date: Wed, 16 Aug 2006 10:31:34 -0400
Message-ID: <19838.1155738694@sss.pgh.pa.us> (raw)
In-Reply-To: <44E308B2.8030008@pbnet.dk>
References: <44E308B2.8030008@pbnet.dk>
=?ISO-8859-1?Q?Poul_M=F8ller_Hansen?= <freebsd@pbnet.dk> writes:
> Last night one of my databases broke down temporary because of a
> segmentation fault.
> At 00:36:21 this was happening in the pgsql log
> 2006-08-16 00:36:21 CEST - LOG: duration: 14673.110 ms statement:
> EXECUTE <unn
> amed> [PREPARE: select * from app.insert_unitstat($1,$2,$3,$4,$5,$6,$7,
> $8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21) as result]
> ...
> These statements are called in a plpgsql function and the function is
> called via JDBC
Given that you're using duration logging and JDBC, I wonder whether you
didn't trip over this recently-identified bug:
http://archives.postgresql.org/pgsql-hackers/2006-08/msg00815.php
Patch is here:
http://archives.postgresql.org/pgsql-committers/2006-08/msg00278.php
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: tgl@sss.pgh.pa.us, freebsd@pbnet.dk
Subject: Re: Segmentation Fault
In-Reply-To: <19838.1155738694@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox