| Subject | Re: [firebird-support] Firebird database seems to influence multi user ability |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2014-12-08T19:56:25Z |
Hi Benny,
Look here
http://ib-aid.com/en/articles/cannot-commit-index-or-how-to-pump-data-from-partially-restored-inconsistent-database/
I suggest to insert fake record with "ORDERID" = 4127, and then try to activate index.
Regards,
Alexey Kovyazin
IBSurgeon
Look here
http://ib-aid.com/en/articles/cannot-commit-index-or-how-to-pump-data-from-partially-restored-inconsistent-database/
I suggest to insert fake record with "ORDERID" = 4127, and then try to activate index.
Regards,
Alexey Kovyazin
IBSurgeon
The weird thing is that the software does not connect to the server from a client if there is a specific .fdb file loaded (local access works). I now asked them to run a backup and that had a couple of messages:Now I ran across a problem with firebird and tried to solve it. unfortunately half of the stuff is in the dark because the original software running here is an accounting product (BUHL/Deltra office Software/Germany if you have heard about it).Hi,I have been an interbase guy about fifteen years ago and loved to see it go open source. I used to work with Paul Beach (Hello, if you're here,Paul)
(gbak:cannot commit index MOV_CALITEMS_ORDERID
gbak: ERROR:violation of FOREIGN KEY constraint "MOV_CALITEMS_ORDERID" on table "MOV_CALENDARITEMS"
gbak: ERROR: Foreign key reference target does not exist
gbak: ERROR: Problematic key value is ("ORDERID" = 4127)
gbak:Database is not online due to failure to activate one or more indices.
gbak:Run gfix -online to bring database online without active indices.)