Firebird-数据库文件关闭错误消息 [英] Firebird - database file shutdown error message

问题描述

我的Firebird数据库有问题.其中一个表的主键由之前实际删除的另一个表引用.因此，当我尝试对表数据进行任何更改时，来自不存在的表的引用导致错误.

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

我该如何解决?

推荐答案

您的数据库(文件而非服务器)已关闭，因此Firebird在使用gfix重新使其联机之前，不接受该数据库的连接.

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.

命令是:

gfix -online <path-to-your-database>

请参见中的数据库启动和关闭 Firebird数据库管家实用程序手册

这篇关于Firebird-数据库文件关闭错误消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！