pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
client crashes in PQfinish
3+ messages / 2 participants
[nested] [flat]

* client crashes in PQfinish
@ 2006-10-27 13:08 soni de <soni.de@gmail.com>
  2006-10-31 05:59 ` Re: client crashes in PQfinish soni de <soni.de@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: soni de @ 2006-10-27 13:08 UTC (permalink / raw)
  To: pgsql-performance

Hello,

My Server is crashed in PQfinish. Below is the core file details:

=>[1] DLRemHead(0x2b7780, 0xfb6bc008, 0x319670, 0xfb6bc008, 0x21c40,
0x3106f8), at 0xfded10e4
  [2] DLFreeList(0x2b7780, 0x0, 0x417b48, 0xfdec5aa4, 0x21c18, 0x0), at
0xfded0c64
  [3] freePGconn(0x371ea0, 0x0, 0x289f48, 0xfbfb61b8, 0x21c18, 0x0), at
0xfdec5ac0
  [4] PQfinish(0x371ea0, 0x289ce8, 0x289ce8, 0xf9a0b65c, 0x20fa0,
0xfb0718dc), at 0xfdec5cc4
  [5] abc(0x289ce0, 0xfafec000, 0xfb5b1d88, 0x0, 0xf9a0ba8c, 0x7), at
0xfb071aec

Server is crashed at "DLRemHead". This crash is not easily reproducible.

Can anybody please tell me whether above problem is related to postgres or
not?

Thanks,
Sonal

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: client crashes in PQfinish
  2006-10-27 13:08 client crashes in PQfinish soni de <soni.de@gmail.com>
@ 2006-10-31 05:59 ` soni de <soni.de@gmail.com>
  2006-10-31 11:47   ` Re: client crashes in PQfinish Richard Huxton <dev@archonet.com>
  0 siblings, 1 reply; 3+ messages in thread

From: soni de @ 2006-10-31 05:59 UTC (permalink / raw)
  To: pgsql-performance

Any response?


On 10/27/06, soni de <soni.de@gmail.com> wrote:
>
> Hello,
>
> My Server is crashed in PQfinish. Below is the core file details:
>
> =>[1] DLRemHead(0x2b7780, 0xfb6bc008, 0x319670, 0xfb6bc008, 0x21c40,
> 0x3106f8), at 0xfded10e4
>   [2] DLFreeList(0x2b7780, 0x0, 0x417b48, 0xfdec5aa4, 0x21c18, 0x0), at
> 0xfded0c64
>   [3] freePGconn(0x371ea0, 0x0, 0x289f48, 0xfbfb61b8, 0x21c18, 0x0), at
> 0xfdec5ac0
>   [4] PQfinish(0x371ea0, 0x289ce8, 0x289ce8, 0xf9a0b65c, 0x20fa0,
> 0xfb0718dc), at 0xfdec5cc4
>   [5] abc(0x289ce0, 0xfafec000, 0xfb5b1d88, 0x0, 0xf9a0ba8c, 0x7), at
> 0xfb071aec
>
> Server is crashed at "DLRemHead". This crash is not easily reproducible.
>
> Can anybody please tell me whether above problem is related to postgres or
> not?
>
> Thanks,
> Sonal
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: client crashes in PQfinish
  2006-10-27 13:08 client crashes in PQfinish soni de <soni.de@gmail.com>
  2006-10-31 05:59 ` Re: client crashes in PQfinish soni de <soni.de@gmail.com>
@ 2006-10-31 11:47   ` Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Richard Huxton @ 2006-10-31 11:47 UTC (permalink / raw)
  To: soni de <soni.de@gmail.com>; +Cc: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-10-31 11:47 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-27 13:08 client crashes in PQfinish soni de <soni.de@gmail.com>
2006-10-31 05:59 ` soni de <soni.de@gmail.com>
2006-10-31 11:47   ` Richard Huxton <dev@archonet.com>

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