Thank you !!! Mark !!
Resolved!
One procedure referenced the Index;
The procedure uses "Plan Sort(Hachu Index(FKHACHUTOPARTS))"
in Select SQL.
I create other Index HachuP on Hachu(partsid).
And I alter the procedure ,not to use plan the FKHACHUTOPARTS
to use plan with new Index HachuP.
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
<>
Usually caused (AFAIK) by a
<>
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
Oh shit, thank our so much! There was an old gbak in the system32 directory
which were the task planer has make a backup.
-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 17. Februar 2016 15:25
An:
17.02.2016 15:14, 'Checkmail' check_m...@satron.de [firebird-support] wrote:
> .it is not the gbak from firebird 2.1
The error shows that the backup was created with gbak 2.1 but from server
2.5. Nothing
you can do but create database from scratch and pump data.
> Now, gfix shows me „single
.it is not the gbak from firebird 2.1 and I'm using the -user sysdba -pas
masterkey switches. What can I do?
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Mittwoch, 17. Februar 2016 14:32
An: firebird-support@yahoogroups.com
Betreff: [firebird-support]
Hello @ll,
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"
On 16-2-2016 22:05, watan...@yahoo.com [firebird-support] wrote:
> I am using FireBird 2.5.3
> and a Database is updated from 2.2, and the database was updated from 1.5.
>
> The database have about 150 tables and just one foreign key.
>
> The Foreign key is from "hachu"Table to "parts"Table
>
>