Subject Re: [ib-support] --* Please Help*--- Database corruption and cannot backup & restore
Author Paul Reeves
Doug Chamberlin wrote:
> I respectfully think Helen is wrong here. The Interbase server (if it is
> SuperServer) can, indeed, open the GDB file in exclusive mode. All
> connections from clients will share that one open file access via the
> layered architecture within the server process. The only reason I can
> remember that it doesn't do this is that certain Interbase utilities (gfix,
> gstat, gsec?) also read the GDB file DIRECTLY. If the server had exclusive
> access then these utilities would not be able to read the GDB file at the
> same time.

Actually, I am reasonably sure that only gstat reads the file directly.
Opening the database exclusively is an easy fix, on the scale of things.
Ensuring that gstat uses the services api rather than direct access is
less so.

All in all, applying a simple fix requires more than a little work to
make sure that everything else will still work as expected.


Paul Reeves
taking InterBase further