Subject | RE: [firebird-support] My restore fails with ERROR:attempt to store duplicate value (visible ... etc |
---|---|
Author | Maya Opperman |
Post date | 2009-12-14T05:47:33Z |
>>gbak:restoring function @1I get these @1 error when using a FB 1.5 FBClient.dll with a FB2.1
server. Try using the FB 2 FBClient DLL and see if the problem goes
away. If the error doesn't go away, at least your error message will be
better.
>>gbak: ERROR:attempt to store duplicate value (visible to activetransactions) in unique index "RDB$INDEX_9"
I have had databases that somehow get duplicate primary keys in them
somehow, and then fail to restore. I have fixed them by deleting the
duplicated record, and then re-doing the backup-restore. I found the
duplicate by seeing at what point the restore failed, and then
investigating those tables.
Maya