| Subject | RES: [firebird-support] Re: database became broken for any reasons |
|---|---|
| Author | Fabiano - Desenvolvimento SCI |
| Post date | 2014-05-19T17:38:07Z |
We also shutdown our database using gfix. We never have a database corruption because this.
BUT we do not kill any fb_inet_server.exe instance. For us, gfix always be enough to shutdown all active users – even when using IBExpert.
De:
firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Enviada em: segunda-feira, 19 de maio de 2014 14:31
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Re: database became broken for any reasons
During of my database service procedure I check that I can do backup and can restore that backup, so I also know about problems of corrupted bacups and possible reasons of metadata corruption.
For preventing orphan pages or backversions I turn off autosweep. So for the last month I don't see any orphan pages or orphan backversions.
I know that shutdown during sweep can broke database, so I turn off autosweep and do only manual sweep.
My service of database looks like this:
1) try normally close all connections(all my applications get commands for starting of autoclose procedure)
2) kill all terminal instance of my applications
3) shutdown database(my software use non root access, so it's guarantee single user access)
4) killing all processes fb_inet_server.exe
5) Waiting for 10 seconds for restarting windows service of FB
6) sweep
7) Bring database onlin e
How can I close all connections normally if something goes wrong, for example my application can't get command for closing so user still working(or maybe not, for example application is opened but no one working)?
Is there any normal way for single user access without using of shutdown mode?