From: Richard Huxton <dev@archonet.com>
To: soni de <soni.de@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: client crashes in PQfinish
Date: Tue, 31 Oct 2006 11:47:17 +0000
Message-ID: <454737C5.1020106@archonet.com> (raw)
In-Reply-To: <9f2e40a90610302159j7ccda892o8fa812d02c2d8559@mail.gmail.com>
References: <9f2e40a90610270608l204e6db9le434824d2d56cae5@mail.gmail.com>
<9f2e40a90610302159j7ccda892o8fa812d02c2d8559@mail.gmail.com>
soni de wrote:
> Any response?
Couple of points:
1. You're on the wrong list. This is for performance issues. I'd
recommend one of the bugs/hackers/general lists instead.
2. You don't give details of any error message produced during the crash
(or if there is one).
3a. You don't give details of the version of PostgreSQL you're on
b. what O.S.
c. how installed
d. what the database was doing at the time
e. what the client was doing at the time
Now, to my uneducated eye it looks like a linked-list problem when
closing a connection. Presumably a corrupted pointer or freeing
something already released.
To make diagnosis even more interesting, although you say it is the
"server" that is crashed, I think PQfinish is part of the libpq
connection library. That probably means the crash is in the client, not
the server. Or does it?
So - based on the fact that I can't tell what's happening, where it
happens or even if it's in the server or client I'd guess something in
your code is overwriting some of libpq's data structures. Possibly
you're using threads in a non-threading library? Bear in mind that I'm
not a C programmer.
--
Richard Huxton
Archonet Ltd
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-performance@postgresql.org
Cc: dev@archonet.com, soni.de@gmail.com
Subject: Re: client crashes in PQfinish
In-Reply-To: <454737C5.1020106@archonet.com>
* 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