Subject | AW: [firebird-support] Problem Firebird 2.5 |
---|---|
Author | Checkmail |
Post date | 2016-02-17T15:34:46Z |
Thanks Paul, I have found the issue J
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