Re: rmtree() failure on Windows - Mailing list pgsql-hackers

From Reini Urban
Subject Re: rmtree() failure on Windows
Date
Msg-id 417ECAB3.6070004@x-ray.at
Whole thread Raw
In response to Re: rmtree() failure on Windows  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: rmtree() failure on Windows
List pgsql-hackers
Andrew Dunstan schrieb:
> Here is some more info. Below is a trace from dropdb. There is a loop 
> around the rmdir() calls which I have set to time out at 600 seconds. 
> The call eventually succeeds after around 300 seconds (I've seen this 
> several times). It looks like we are the victim of some caching - the 
> directory still thinks it has some of the files it has told us we have 
> deleted successfully.

300 secs (!) fs timeout is really broken.
Looks more like a locking or network timeout issue.

What error codes does unlink(3) return?

Why don't you use DeletFileA() instead of unlink()?

Or even better, why don't you use this delete on close snippet instead:

HANDLE h;
h = CreateFile (win32_name, 0, FILE_SHARE_READ, &sec_none_nih,      OPEN_EXISTING, FILE_FLAG_DELETE_ON_CLOSE, 0);
if (h != INVALID_HANDLE_VALUE)
{(void) SetFileAttributes (win32_name, (DWORD) win32_name);BOOL res = CloseHandle (h);//syscall_printf ("%d =
CloseHandle(%p)", res, h);if (GetFileAttributes (win32_name) == INVALID_FILE_ATTRIBUTES)    {      //syscall_printf
("CreateFile(FILE_FLAG_DELETE_ON_CLOSE) 
 
succeeded");      goto ok;    }  else    {      //syscall_printf ("CreateFile (FILE_FLAG_DELETE_ON_CLOSE) failed");
SetFileAttributes (win32_name, (DWORD) win32_name & 
 
~(FILE_ATTRIBUTE_READONLY | FILE_ATTRIBUTE_SYSTEM));    }}    }
  /* Try a delete with attributes reset */  if (DeleteFile (win32_name))    {      syscall_printf ("DeleteFile after
CreateFile/CloseHandlesucceeded");      goto ok;    }
 

It should only happen a ERROR_SHARING_VIOLATION on NT systems with such 
a long timeout. This is then a concurrency problem. win95 will not 
return ERROR_SHARING_VIOLATION, only ERROR_ACCESS_DENIED

...
> 2004-10-26 10:31:09 [2496] WARNING:  rmtree: rmdir took 274 secs/loops
> 2004-10-26 10:31:09 [2496] LOG:  disconnection: session time: 0:04:34.11 
> user=pgrunner database=template1 host=127.0.0.1 port=1918

-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Unixware 714 pthreads
Next
From: Tom Lane
Date:
Subject: Should bgwriter log checkpoint start/end?