From: | "Hakan Kocaman" <Hakan(dot)Kocaman(at)digame(dot)de> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jan de Visser" <jdevisser(at)digitalfairway(dot)com> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Hanging queries on dual CPU windows |
Date: | 2006-03-10 14:32:19 |
Message-ID: | 84AAD313D71B1D4F9EE20E739CC3B6EDE96CE6@ATLANTIK-CL.intern.digame.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
> Sent: Thursday, March 09, 2006 9:11 PM
> To: Jan de Visser
> Cc: pgsql-performance(at)postgresql(dot)org
> Subject: Re: [PERFORM] Hanging queries on dual CPU windows
>
>
> Jan de Visser <jdevisser(at)digitalfairway(dot)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(dot)kocaman(at)digame(dot)de
From | Date | Subject | |
---|---|---|---|
Next Message | Jan de Visser | 2006-03-10 14:32:59 | Re: Hanging queries on dual CPU windows |
Previous Message | Daniel Blaisdell | 2006-03-10 14:27:48 | Re: x206-x225 |