Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED

Rainer Bauer wrote:
> "Matthew T. O'Connor" wrote:
> 
>> Tom Lane wrote:
>>> ROTFL ... so to translate: "If your program crashes, please release
>>> locks before crashing."
>> Obviously that wasn't the intent of the above, but I guess it is the net 
>> effect.  Either way, I don't think it's a huge problem, it just means 
>> that PG may not be able to restart for a few seconds until the OS has 
>> time to clean-up the locks.
> 
> I don't think so. I am using DevStudio 2005 here and from time to time the
> debugger crashes so that I have to kill the program via the task manager.
> Afterwards it's not possible to load the crashed project again in a newly
> started DevStudio session, because some project files are still locked
> exclusively. The only action that helps is rebooting windows.
> 
> Now, I don't know whether DevStudio is using LockFileEx() but somehow this
> sounds familiar.
> 
> Rainer
> 

Has anyone considered not using a file lock on windows?  CreateMutex 
might do the trick if provided a mutex name, making it global rather 
than process bound.  OpenMutex can be used to test if the mutex exists 
or if it is currently locked.  I guess it would stay locked.  If there 
is a crash, it is automatically closed by the os.

The docs state the system closes the handle (mutex) when the process 
terminates and makes no mention of this being a lingering action like 
LockFileEx.  It sounds like the mutex is closed ASAP when the process 
terminates, just like file handles.

-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/