|Subject||Re: How to shutdown Firebird server ?|
> Not really. Let's try to figure out what you mean.Maybe my English is not good but I never thought that it was that
> 1. I have a server running Firebird in application mode (-aswitch).
>Firebird is running on. Yes or No?
> -- here you use the word "server" to refer to "machine that
>Yes for me the server is the machine and the Firebird server is the
application. Or should I say Firebird deamon or Firebird SQL Server ?
> 2. During the night some maintenance need to be done on thatserver.
>*machine* that is unrelated to Firebird? Yes or No?
> -- "maintenance...on that server" - some kind of work on that
>Yes, maintenance on the server, the machine. Not related to Firebird.
> 3. Before the maintenance start I need to close the Firebirdserver and restart it at the end.
>Yes, Firebird server again mean Firebird for me.
> -- here "server" means "the Firebird server process". Yes or No.
>to corrupt my databases, I want to close it cleanly.
> 4. I don't want to kill the Firebird process because I don't want
>process" mean exactly the same thing to me. What do they mean to
> a) "close the Firebird server [process]" and "kill the Firebird
>Not exactly. For me closing the Firebird (or applications) is not
the same thing as killing the process. Killing a process in Windows
can produce bad results if the application doesn't close by itself.
> b) Why do you think that killing/closing/terminating the Firebird[server] process would corrupt databases?
>Because I don't know if all the requested actions have been done by
Firebird. So killing the process while Firebird is working is not a
> 5. I know there is already a way to shutdown the database onlybut how to do with fbserver.exe ?
>Sorry I wrote this because I saw nothing like this with gfix so I
> -- You don't do it with fbserver.exe, you do it with gfix.
thought it could be with fbserver.exe like when I started the
Firebird with the -a.
Exactly how you do it depends
> (a) on what version of Firebird you are running, which we don't
> anddon't know this, either.
> (b) what users/applications are doing at the time of shutdown. We
>Nobody should be working on the Firebird at that time but I don't
want to take the chance.
> 6. ( BTW I forgot to mention I am running Windows version).given that you said before that you can't run Firebird as a service,
> --- fbserver.exe doesn't actually run on anything else. ;-) But,
do we assume therefore that
>No the host machines are running Windows 2003, Windows 2000 and in
> a) the host machine is running Windows 98?
the worst case, Windows XP. They are also going to Vista :-(
> andaccessing a web application?
> b) the users are 2-tier client/server clients, not browsers
>The users are 3-tier.
> 7. Because you have to ask this question at all, must we assumethat you have users connected and working on databases at the time
you want to kill the Firebird server process? Yes or No?
>Should not but we never know. Sometime people work late.
> a) you said "during the night" .... "some maintenance..."down their applications, and gone home for the night, you don't have
> b) you are worried about corrupting databases
> 8. If, in reality, the users have all finished their work, shut
to worry about shutting down the *databases*. We don't know,
because you haven't told us what's expecting to be happening at that
>I already analyzed all that but to be safe I thought it would be
easy to shutdown the Firebird. If I would have installed it as
service I would have just stopped it. But per what I see this look
very complicated. Why ?
> -- you can test whether anyone is logged in to a database byattempting to rename the database file. If it works, then nobody is
logged in and the database is *already* shut down. You can just go
to Task Manager and stop the Firebird process.
>That mean all the Firebird jobs have been done ?
> -- if you can't rename the database file then at least one user islogged in. If it is you, then just log out of whatever application
you are using and try again. If it is not you, and you are the only
human there, then you can perform a database shutdown using gfix.
>That could explain why I can an error message when the users
shutdown their Windows. A message say that there is still users
connected to Firebird and don't want to close.
> All the unknowns mentioned here are what I was referring to when Irequested that you start again and try to make us understand what
you really want to do...
>So I did now... ;-)