| Subject | FireBird data integrity issues |
|---|---|
| Author | william_yuwei |
| Post date | 2010-09-03T17:23:14Z |
HI, All
I'm using Firebird 2.1.3, for last 2 years, I had the few Firebird data integrity issue for our clinics, not as many as you thought, but fews. I had several databases on hand that can prove the issues. Just want to see if anyone can help me out:
For example:
1) One of the clinic database I had took a look at today, has 2 DUPLICATED PRIMARY KEY records, we found the issue only when doing backup and restore. One actually is stored in the table, the another one is visible in 'active transaction'.
2) Some of the clinics' data have the detail records that their master records were gone. Even all the foreign key constraints were there. Again, we found this problem when doing backup and restore.
Regards,
William
I'm using Firebird 2.1.3, for last 2 years, I had the few Firebird data integrity issue for our clinics, not as many as you thought, but fews. I had several databases on hand that can prove the issues. Just want to see if anyone can help me out:
For example:
1) One of the clinic database I had took a look at today, has 2 DUPLICATED PRIMARY KEY records, we found the issue only when doing backup and restore. One actually is stored in the table, the another one is visible in 'active transaction'.
2) Some of the clinics' data have the detail records that their master records were gone. Even all the foreign key constraints were there. Again, we found this problem when doing backup and restore.
Regards,
William