I have a problem with my Firebird database. The primary key of one of the tables is referenced by another table that was actually dropped earlier. So this reference from a non-existent table was causing errors when I try to make any changes in the table data.
So I did a backup and restore and the bad reference was gone but now when I try to connect to my database more than once at the same time I get the following error:
database [file path] shutdown
How can I solve this?
Your database (file, not server) has been shutdown, so Firebird does not accept connections for this database until it has been brought online again using gfix.
The command is:
gfix -online <path-to-your-database>
See Database Startup and Shutdown in the Firebird Database Housekeeping Utility manual
use online
gfix -user "SYSDBA" -password "masterkey" -online DATA.FDB
after database is used retry
gfix -user "SYSDBA" -password "masterkey" -shut -force 0 DATA.FDB
