Thanks Paul, I have found the issue :)

 

Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Mittwoch, 17. Februar 2016 15:38
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] Problem Firebird 2.5

 

  


<<during a restore of a firebird gbk on a fres installed system with the
same firebird 2.5 cs server like the original server, I get
this error:
attemp to store duplicate value (visible to active transactions) inn unique
index "RDB$Index_39" Problematic key value is
("RDB$ROLE_NAME" = ,RDB$ADMIN')>>

Usually caused (AFAIK) by a restore done with Firebird 2.1 or an earlier
gbak, or if a Firebird 2.5 backup was
restored to Firebird 2.1, backed up and then restored on Firebird 2.5

On the original database you can do

DROP ROLE RDB$ADMIN;
COMMIT;

When you restore, gbak.exe should recreate the RDB$ADMIN role.

Paul



  • [firebird-support... 'Checkmail' check_m...@satron.de [firebird-support]
    • AW: [firebir... 'Checkmail' check_m...@satron.de [firebird-support]
      • Re: [fir... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
        • AW: ... 'Checkmail' check_m...@satron.de [firebird-support]
    • [firebird-su... 'Paul Beach' pabe...@waitrose.com [firebird-support]
      • AW: [fir... 'Checkmail' check_m...@satron.de [firebird-support]

Reply via email to