问题描述
我的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:
我该如何解决?
推荐答案
您的数据库(文件而非服务器)已关闭,因此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-数据库文件关闭错误消息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!