Skip site navigation (1) Skip section navigation (2)

Re: Win32 deadlock detection not working for Postgres8beta1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Steve McWilliams" <smcwilliams(at)EmprisaNetworks(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Win32 deadlock detection not working for Postgres8beta1
Date: 2004-09-02 15:55:30
Message-ID: 29909.1094140530@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers-win32
"Steve McWilliams" <smcwilliams(at)EmprisaNetworks(dot)com> writes:
> I am just starting to test out Postgres8 beta1 and notice that the
> deadlock detection mechanism is not working (under windows XP pro with
> service pack 1).  I am using the version of Postgres built by the
> PGFoundry project, and have it installed as a service.

> To produce the bug I simply launch 2 separate psql windows, begin a
> transaction in each, then do staggered 'SELECT ... FOR UPDATE' calls on 2
> different rows in each of the psql windows, in reverse order.  The two
> processes will hang indefinitely.

> The deadlock detection for 8beta1 seems to work fine under linux btw.  I
> have not tried this using a version of 8beta1 built using cygwin, but I
> have run versin 7.4 under cygwin before without this problem.

A reasonable theory about this would be that the timer interrupt isn't
firing.  Does "statement_timeout" work either?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Gaetano MendolaDate: 2004-09-02 16:05:53
Subject: Re: Sugestion
Previous:From: Steve McWilliamsDate: 2004-09-02 15:25:55
Subject: Win32 deadlock detection not working for Postgres8beta1

pgsql-hackers-win32 by date

Next:From: Steve McWilliamsDate: 2004-09-02 16:12:23
Subject: Re: Win32 deadlock detection not working for Postgres8beta1
Previous:From: Tom LaneDate: 2004-09-02 15:46:00
Subject: Re: Compiling beta2 with openssl on XP Pro

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group