Subject | Database corruption if server is not properly shutdown |
---|---|
Author | Federico Tello Gentile |
Post date | 2005-09-02T14:22:32Z |
I'm developing a web application and I'm starting FB manually. Sometimes
I restart my workstation (Linux) but I forget to shutdown the FB
service. Is this the reason why my DB has been currupted 2 times in a week?
By corrupted I mean bogus erros when doing perfectly ok queries, and
alowing me to violate referentail integrity. Recreating all the dabatase
from scratch (dropping and re creating) did not fix anything so I had to
create a new database with the same name.
I think the FB server gets the termination signal from the OS when
shuting down the system, but I guess it does not shut itself down.
I restart my workstation (Linux) but I forget to shutdown the FB
service. Is this the reason why my DB has been currupted 2 times in a week?
By corrupted I mean bogus erros when doing perfectly ok queries, and
alowing me to violate referentail integrity. Recreating all the dabatase
from scratch (dropping and re creating) did not fix anything so I had to
create a new database with the same name.
I think the FB server gets the termination signal from the OS when
shuting down the system, but I guess it does not shut itself down.