Subject My restore fails with ERROR:attempt to store duplicate value (visible ... etc
Author theodorezafiropoulos
I accidently sent this email in another thread so, here it is in a new one ...

Hi to all

I did a backup of my FB database using

gbak -v -t -user SYSDBA -password "masterkey" DBNAME.FDB DBNAME.FBK

That appeared to process OK, then I tried to restore using

gbak -c -v -p 8192 -user SYSDBA -password "masterkey" DBNAME.FBK DBNAME2.FDB

however this failed with the message

gbak:restoring function @1
gbak: ERROR:attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_9"
gbak:Exiting before completion due to errors

The OS is WIN XP Pro.

Any idea why this should happen? Obviously it sounds like some index duplication error.

I successfully used these backup/restore commands about 3 weeks ago, so thought I might as well do it again. Presto! Erro appears.

Some help please? Do you guys require further info?

Thanking you in advance ...

gstat -h DBNAME.FDB


Flags 0
Checksum 12345
Generation 49318614
Page size 8192
ODS Version 11.1
Oldest transaction 49318603
Oldest active 49318604
Oldest snapshot 49318604
Next transaction 49318605
Bumped transaction 1
Sequence number 0
Nesxt attachment ID 2135
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialed 3
Creation date Nov 20, 2009 23:46:17
attibutes force write

Variable header data:
sweep interval: 20000

Have a nice day!