Subject | Firebird 2.1 Database Lockout |
---|---|
Author | dr_john_mp |
Post date | 2008-05-21T14:45:12Z |
Server Version: LI-V2.1.0.17798 Firebird 2.1
Have solved a speed problem on 2.1 by setting forced writes off on
each of our databases.
However we have had 2 ocurances of the databases 'freezing'.
In short IBExpert, etc. can see and query the server, but the
databases themselves are not accessible, as if they don't exist of are
off-line (even to SYSDBA). Other files on the server are accessible.
Also its not possible to take a backup.
This never happened until we upgraded to 2.1 (from 2.0) and we have
deliberately not upgraded our programs at the same time. Running as
classic.
Following a reboot of the server all OK and database can backup and
restore.
Have solved a speed problem on 2.1 by setting forced writes off on
each of our databases.
However we have had 2 ocurances of the databases 'freezing'.
In short IBExpert, etc. can see and query the server, but the
databases themselves are not accessible, as if they don't exist of are
off-line (even to SYSDBA). Other files on the server are accessible.
Also its not possible to take a backup.
This never happened until we upgraded to 2.1 (from 2.0) and we have
deliberately not upgraded our programs at the same time. Running as
classic.
Following a reboot of the server all OK and database can backup and
restore.