Subject | Re: [firebird-support] Re: Firebird for big projects |
---|---|
Author | Theodore Zafiropoulos |
Post date | 2009-12-11T13:46:15Z |
Hi to all
I did a backup of my FB 2.1.2.18118 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 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 mught 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
returns
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
*END*
Have a nice day!
Theodore
[Non-text portions of this message have been removed]
I did a backup of my FB 2.1.2.18118 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 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 mught 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
returns
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
*END*
Have a nice day!
Theodore
[Non-text portions of this message have been removed]