Firebird 2.1: gfix -online returns "database shutdown"

Posted by darvids0n on Server Fault See other posts from Server Fault or by darvids0n
Published on 2010-04-29T03:40:36Z Indexed on 2010/04/29 3:48 UTC
Read the original article Hit count: 910

Filed under:
|
|
|

Hey all. Googling this one hasn't made a bit of difference, unfortunately, as most results specify the syntax for onlining a database after using gfix -shut -force 30 (or any other number of seconds) as gfix -online dbname, and I have run gfix -online dbname with and without login credentials for the DB in question.

The message that I get is:

database dbname shutdown

Which is fine, except that I want to bring it online now. It's out of the question to close fbserver.exe (running on a Windows box, afaik it's Classic Server 2.1.1 but it may be Super) since we have other databases running off of that which need almost 24/7 uptime. The message from doing another gfix -shut -force or -attach or -tran is invalid shutdown mode for dbname which appears to match with the documentation of what happens if the database is already fully shut down.

Ideas and input greatly appreciated, especially since at the moment time is a factor for me. Thanks!

EDIT: The whole reason I shut down the DB is to clear out "active" transactions which were linked to a specific IP address, and that computer is my dev terminal (actually a virtual machine where I develop frontends for the database software) but I had no processes connecting to the database at the time. They looked like orphaned transactions to me, and they weren't in limbo afaik. Running a manual sweep didn't clear them out, deleting the rows from MON$STATEMENTS didn't work even though Firebird 2.1 supposedly supports cancelling queries that way. My last resort was to "restart" the database, hence the above issue.

© Server Fault or respective owner

Related posts about firebird

Related posts about database