[Win32] Problem with rename()
Peter Brant <peter.brant@wicourts.gov>
From: "Peter Brant" <Peter.Brant@wicourts.gov>
To: <pgsql-bugs@postgresql.org>
Date: 2006-04-17T23:53:56Z
Lists: pgsql-bugs
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? Pete