From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: [Win32] Problem with rename() |
Date: | 2006-04-18 11:12:06 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCEA352AA@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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?
It would be interesting to see which processes have handle(s) open to
either of these two names. "handle -a" shuold give that, I assume?
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-04-18 12:39:52 | Re: [martin@bugs.unl.edu.ar: BUG in logs] |
Previous Message | Dave Page | 2006-04-18 07:28:13 | Re: BUG #2399: Postgis DLL corrupted |