Обсуждение: failure on database drop

Had a failure dropping a database follow a crashed connection (crash was
due to application error).  Test was on win32 port d/l and compiled
fresh this morning.

Here is the psql log (immediately after the crash):
data3=# \ctemplate1
You are now connected to database "template1".
template1=# drop database data3;
WARNING:  could not remove database directory
"c:\postgres\data/base/17293"
DETAIL:  Failing system command was: rmdir /s /q
"c:\postgres\data/base/17293"
HINT:  Look in the postmaster's stderr log for more information.
DROP DATABASE

Here is the postmaster log:
LOG:  could not receive data from client: No connection could be made
because the target machine act
ively refused it.
        LOG:  could not receive data from client: No connection could be
made because the target mac
hine actively refused it.

LOG:  unexpected EOF on client connection

LOG:  unexpected EOF on client connection
The directory is not empty.
WARNING:  could not remove database directory
"c:\postgres\data/base/17293"
DETAIL:  Failing system command was: rmdir /s /q
"c:\postgres\data/base/17293"
HINT:  Look in the postmaster's stderr log for more information.

Merlin Moncure wrote:

>Had a failure dropping a database follow a crashed connection (crash was
>due to application error).  Test was on win32 port d/l and compiled
>fresh this morning.
>
>Here is the psql log (immediately after the crash):
>data3=# \ctemplate1
>You are now connected to database "template1".
>template1=# drop database data3;
>WARNING:  could not remove database directory
>"c:\postgres\data/base/17293"
>DETAIL:  Failing system command was: rmdir /s /q
>"c:\postgres\data/base/17293"
>HINT:  Look in the postmaster's stderr log for more information.
>DROP DATABASE
>
>Here is the postmaster log:
>LOG:  could not receive data from client: No connection could be made
>because the target machine act
>ively refused it.
>        LOG:  could not receive data from client: No connection could be
>made because the target mac
>hine actively refused it.
>
>LOG:  unexpected EOF on client connection
>
>LOG:  unexpected EOF on client connection
>The directory is not empty.
>WARNING:  could not remove database directory
>"c:\postgres\data/base/17293"
>DETAIL:  Failing system command was: rmdir /s /q
>"c:\postgres\data/base/17293"
>HINT:  Look in the postmaster's stderr log for more information.
>
>
>

The first thing I see is that the path has not been canonicalised ....
probably not the problem, but it needs to be fixed, I think.

cheers

andrew

Andrew Dunstan wrote:
> >DETAIL:  Failing system command was: rmdir /s /q
> >"c:\postgres\data/base/17293"
> >HINT:  Look in the postmaster's stderr log for more information.
>
> The first thing I see is that the path has not been canonicalised ....
> probably not the problem, but it needs to be fixed, I think.

Perhaps the problem is due to the rename/unlink issue. This is no longer
listed on the status page...does the anonymous cvs server have this
capability yet?

I think I have a pretty good shot at being able to reproduce the
problem.

Merlin

Merlin Moncure wrote:
>
> Andrew Dunstan wrote:
> > >DETAIL:  Failing system command was: rmdir /s /q
> > >"c:\postgres\data/base/17293"
> > >HINT:  Look in the postmaster's stderr log for more information.
> >
> > The first thing I see is that the path has not been canonicalised ....
> > probably not the problem, but it needs to be fixed, I think.
>
> Perhaps the problem is due to the rename/unlink issue. This is no longer
> listed on the status page...does the anonymous cvs server have this
> capability yet?
>
> I think I have a pretty good shot at being able to reproduce the
> problem.

Yes, those fixes are all in the source you have.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073