Re: [firebird-support] Strange problem - 'cannot update erased record'

2012-09-05 Thread Helen Borrie
At 05:14 PM 5/09/2012, you wrote: Hi I have a process that is intermittently throwing the following error... ISC ERROR CODE:335544382 ISC ERROR MESSAGE: cannot update erased record That's not a Firebird-defined error message. ISC code 335544382 has the gdscode random and the associated

[firebird-support] Re: Strange problem - 'cannot update erased record'

2012-09-05 Thread Dmitry Yemanov
05.09.2012 12:07, Helen Borrie пишет: That's not a Firebird-defined error message. Actually, it is, despite being thrown via isc_random. This error is raised when the record being updated has been deleted by some concurrent transaction which has been committed after the UPDATE statement has

[firebird-support] Restore not recreating some foreign keys

2012-09-05 Thread Tupy . . . nambá
Dear sirs,     These days, when restoring a backup of us, I noted that some foreign keys have not been recreated at a new copy of a DB.   I don´t know exactly when this happens = if the backup itself is generated without these faulting FK´s or if the fail happens at the DB recreation process.