Subject | RE: Internal Firebird consistency check (cannot find record back version (291) - how to fix and prevent? |
---|---|
Author | |
Post date | 2014-01-29T14:02:43Z |
Thank you for your response.
I hardly belive that this is the problem of RAM or disk, because the same problem (on the same table) happened in two different clients in simmilar time. So, lets rule out problems with hardware and lets rule out problems caused by power outage and we are left with what...? Bug in Firebird?
The table which is causing problems for us has been added lately. Also there is one trigger on different table which is fired on insert/update and it is inserting data to the problematic table. I do not know if this trigger is causing the problems tho.
So I have two clients, the same problem on the same table and I have no idea what is causing this error...
>>The nature of errors is the following - one of record'sbackversions is missing, and Firebird cannot read >>chain of back versions to build actual (yours) version of this record.
>>The reason "wrong transaction management", I think, is notcorrect, and we will change it - usually this >>happens due to hardware problem in RAM or disk.
I hardly belive that this is the problem of RAM or disk, because the same problem (on the same table) happened in two different clients in simmilar time. So, lets rule out problems with hardware and lets rule out problems caused by power outage and we are left with what...? Bug in Firebird?
The table which is causing problems for us has been added lately. Also there is one trigger on different table which is fired on insert/update and it is inserting data to the problematic table. I do not know if this trigger is causing the problems tho.
So I have two clients, the same problem on the same table and I have no idea what is causing this error...
>>tryI've tried id. After mending the database gfix is not raising this error but it hangs on the same table durring record writing. I mean, I see that HD is working all the time but there is no progress in backing up...
>>gfix -mend ...
>>gbak -b -g -v -ig ...