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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Andrew Chernow <ac(at)esilo(dot)com>
Cc: Rainer Bauer <usenet(at)munnin(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED
Date: 2008-10-16 18:28:35
Message-ID: 48F787D3.2040106@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Chernow wrote:
> 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.
>

Please review the previous discussion. This whole thing came about
because of major problems in handling Global objects.

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2008-10-16 19:28:30 Re: Memory leak on hashed agg rescan
Previous Message Andrew Chernow 2008-10-16 18:20:27 Re: 8.3 .4 + Vista + MingW + initdb = ACCESS_DENIED