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

[Win32] Problem with rename()

From: "Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: [Win32] Problem with rename()
Date: 2006-04-17 23:53:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-patches
Hi all,

In the last couple of days, we've been bitten (a couple of times, on
different servers) by an apparent glitch or bad interaction in the
Windows implementation of rename().

The relevant log message is:

[2006-04-17 16:49:22.583 ] 2252 LOG:  could not rename file
"pg_xlog/000000010000010A000000BD" to
"pg_xlog/000000010000010A000000D7", continuing to try

It apparently just keeps on looping indefinitely.  The "completed
rename" message from port/dirmod.c never shows up.

Shortly thereafter, Postgres becomes unresponsive.  Attempts to make a
new connection just block.  Autovacuums block.  A "pg_ctl ... stop -m
fast" doesn't work.  Only "pg_ctl ... stop -m immediate" does.

With the last occurrence, I saved off the output of "handle -a" and
"pslist -x" in case that's helpful.  

Any thoughts on what might be going wrong?  If it happens again, what
other clues should I be looking for?



pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-04-18 00:52:30
Subject: Re: [ BUG in logs]
Previous:From: Peter BrantDate: 2006-04-17 23:35:39
Subject: Re: Permission denied on fsync / Win32 (was right

pgsql-patches by date

Next:From: Peter EisentrautDate: 2006-04-18 00:12:00
Subject: Re: pg_ctl options checking
Previous:From: Simon RiggsDate: 2006-04-17 22:13:07
Subject: Re: pg_ctl options checking

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