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

Re: [Win32] Problem with rename()

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Brant <Peter(dot)Brant(at)wicourts(dot)gov>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bugs for PostgreSQL <pgsql-bugs(at)postgreSQL(dot)org>, PostgreSQL-patches <pgsql-patches(at)postgreSQL(dot)org>
Subject: Re: [Win32] Problem with rename()
Date: 2006-06-16 21:21:21
Message-ID: 200606162121.k5GLLLw13054@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
Peter Brant wrote:
> Really?  If there was a patch, I missed it.
> 
> My recollection is that there was general agreement about this
> particular problem (see, for example,
> http://archives.postgresql.org/pgsql-bugs/2006-04/msg00189.php ), but
> things kind of trailed off after that without a resolution.

Yea.  Where you using WAL archiving?  We will have a fix in 8.1.5 to
prevent multiple archivers from starting.  Perhaps that was a cause.

> As far as the complete list of Win32 problems which affected us:
>   - The stats collector crashing should indeed be fixed in 8.1.4
>   - Missing stats caused by Windows PID recycling is fixed in 8.2
>   - Various semaphore problems are probably all fixed with the new
> Win32 semaphore implementation in 8.2
>   - The stuck log rename problem mentioned above is still an issue

Yep.  What has me baffled is why no one else is seeing the problem.
We had a rash of reports, and now all is quiet.

>   - The "permission denied on fsync" (or something like that) problem
> is still an issue.  Unfortunately, IIRC, we could never really nail down
> the underlying problem.

Yes, I just reread that thread.  I also am confused where to go from
here.

> None of these problems affect us any more: the production servers now
> run Linux.  Great to have options! (and we were moving that direction
> anyway)

Were you the only one use Win32 in heavy usage?  You were on Win2003. 
Were there some bugs in the OS that got fixed later.

Yea, stumped.  Guess we will have to wait for more reports.  I don't
even see how to document this as a TODO.

-- 
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-06-17 03:54:30
Subject: Re: BUG #2483: Wrong error report about missing entry in from clause
Previous:From: Peter BrantDate: 2006-06-16 20:45:37
Subject: Re: [Win32] Problem with rename()

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-06-16 21:36:58
Subject: Re: pg_dump -Ft failed on Windows XP
Previous:From: Peter BrantDate: 2006-06-16 20:45:37
Subject: Re: [Win32] Problem with rename()

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