mariuz / flamerobin

FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software
http://flamerobin.org
MIT License
211 stars 64 forks source link

Lock on embedded database file not achieved when database connected. #379

Open brianliedtke opened 3 weeks ago

brianliedtke commented 3 weeks ago

Running version 0.9.10 This also occurred running version 0.9.3

I am running against an embedded database. I have a backup database file to reset the database to a beginning state when testing code that modifies the database. I have the database connected in the main FlameRobin window.

Without disconnecting the database, I accidently copied the reset file over the database file. This was allowed. When I attempted to browse the data on a table, the message: "Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements internal Firebird consistency check (can't continue after bugcheck)"

Expected that FlameRobin would put a lock on the embedded database file to prevent Windows from copying over the file when the database is connected.