Re: Hanging queries on dual CPU windows - Mailing list pgsql-performance

From Hakan Kocaman
Subject Re: Hanging queries on dual CPU windows
Date
Msg-id 84AAD313D71B1D4F9EE20E739CC3B6EDE96CE6@ATLANTIK-CL.intern.digame.de
Whole thread Raw
List pgsql-performance
Hi,

> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Tom Lane
> Sent: Thursday, March 09, 2006 9:11 PM
> To: Jan de Visser
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] Hanging queries on dual CPU windows
>
>
> Jan de Visser <jdevisser@digitalfairway.com> writes:
> > Furtermore, it does not happen on Linux machines, both
> single CPU and dual
> > CPU, nor on single CPU windows machines. We can only
> reproduce on a dual CPU
> > windows machine, and if we take one CPU out, it does not happen.
> > ...
> > Which showed me that several transactions where waiting for
> a particular row
> > which was locked by another transaction. This transaction
> had no pending
> > locks (so no deadlock), but just does not complete and hence never
> > relinquishes the lock.
>
> Is the stuck transaction still consuming CPU time, or just stopped?
>
> Is it possible to get a stack trace from the stuck process?  I dunno
> if you've got anything gdb-equivalent under Windows, but that's the
> first thing I'd be interested in ...

Debugging Tools for Windows from Microsoft
http://www.microsoft.com/whdc/devtools/debugging/installx86.mspx

Additinonally you need a symbol-file or you use
"SRV*c:\debug\symbols*http://msdl.microsoft.com/download/symbols"
to load the symbol-file dynamically from the net.

Best regards

>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings




Hakan Kocaman
Software-Development

digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln

Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98
Email: hakan.kocaman@digame.de



pgsql-performance by date:

Previous
From: "Daniel Blaisdell"
Date:
Subject: Re: x206-x225
Next
From: Jan de Visser
Date:
Subject: Re: Hanging queries on dual CPU windows