We have had the same experience.

It seems to arise because you have declarations of old external functions (MOD, ABS etc) which used to be available only in the UDF, and now exist under the same name (MOD, ABS etc) as internal database functions.

It can be solved by removing the declarations and running the backup again.

If you need to restore from a backup, I guess the only solution is to re-install an older FB version, and then restore, hoping there are no ODS incompatibilities.

Maybe the backup process should trap this error, as there is currently no indication that the backup is not restorable.

Roger Vellacott
Passfield Data Systems.

--- In firebird-support@yahoogroups.com, "Theodore Zafiropoulos" <theodorez@...> wrote:
>
> 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]
>