[firebird-support] Firebird database seems to influence multi user ability
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) 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). 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: (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.) Specifically the last one makes me suspicious. How come that local access works then? I thought even local access always goes through the server? Any hints anybody? I know this is hard to determine as we do not know much about the program itself, but it seems the guys from the software shop have trouble to understand firebird... Regards, Benny Schaich Ex-Borland...
Re: [firebird-support] Firebird database seems to influence multi user ability
On 08.12.2014 14:28, Benny Schaich-Lebek bscha...@gmx.de [firebird-support] wrote: > > > 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) > > 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). > > 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: > (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.) > > Specifically the last one makes me suspicious. How come that local > access works then? I thought even local access always goes through the > server? Hej, some questions: - by local connections you're talking about \path\to\fdb? Or 127.0.0.1:., which would be a network connection, regardless of which host the connection comes from. - which version of Firebird? - which user? SYSDBA is allowed to connect an 'offline' database. He has to, else a database would only become a big jumbled piece of bits'n'bytes if one pulls the trigger gfix -shut ... Do you have the output of gstat -h ? What does the row Attributes say? marcus > > Any hints anybody? I know this is hard to determine as we do not know > much about the program itself, but it seems the guys from the software > shop have trouble to understand firebird... > > Regards, > Benny Schaich > Ex-Borland... > > [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird database seems to influence multi user ability
On 8-12-2014 14:28, Benny Schaich-Lebek bscha...@gmx.de [firebird-support] wrote: > 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) > > 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). > > 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: > (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.) > > Specifically the last one makes me suspicious. How come that local > access works then? I thought even local access always goes through the > server? The error is with restoring the backup. It indicates there is a record which has a foreign key that is pointing to a non-existent entry. This usually indicates that the original database has a corrupt index, and therefor didn't detect this entry when deleting the target record. The fact the backup doesn't restore doesn't mean that the original database isn't workign. You either need to remove the duplicate entry from the original database and backup and restore to fix it, or restore with inactive indexes and rebuild them later. Mark -- Mark Rotteveel
Re: [firebird-support] Firebird database seems to influence multi user ability
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 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) 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). 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: (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.)