--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 05:11 AM 4/02/2010, Stefan Sinne wrote:
> >I'm trying to shut down a database with still one open connection, using
> >gfix -shut -attach 5 ....
> >This naturally fails with message 'database shutdown unsuccessful'.
> >
> >After this I can not connect anymore to the database, even not as
> >sysdba, I always get the message 'shutdown in progress'.
> >
> >I tried to bring the database online, but this failed as well ('Target
> >shutdown mode is invalid').
> >
> >The only solution is to close the open connection to the database (the
> >one that made the shutdown fail)
> >or to force a shutdown and bring it online again. After this new
> >connections are allowed again.
> >
> >Is this the normal behaviour or am I missing something?
>
> It is not the normal behaviour: Congratulations - you have discovered a genuine, silver-plated regression bug. Dmitry Y is fixing it now.
>
> BTW, I can also confirm that the syntax pattern documented for the new shutdown options in the v.2.0 and 2.1 release note is also wrong. The whole item in fact is badly edited. Shoot the editor!
>
> >Tested with Firebird SS 2.0.5 and 2.1.3 on linux x86-64.
>
> All will be put right for the v.2.0.6 and 2.1.4 sub-releases. All going well, you will be able to test it in tomorrow's snapshots.
>
> ./heLen
>

Helen, thanks for the fast answer (that's why I *never* would shoot the editor ;-) )

I was wondering why I haven't stumbled over this problem before and therefore made some additional tests. It seems that on CS, which is the mayority of our instalations, the shutdown works as expected (tested again with version 2.1.3).

Thanks again,

Stefan