firebird-automations

Commented by: @hvlad Are you sure you have no stuck OST ?

Commented by: Grzegorz Skoczylas (gskoczylas) I have no idea what does it means "stuck OST"\. I'm sorry\. I have Firebird 2\.5 RC2 SuperServer \(standard installation\)\. Both Firebird and client application...

Commented by: @hvlad Reproduced and investigating

Modified by: @hvlad assignee: Vlad Khorsun \[ hvlad \]

Commented by: @dyemanov Does the same happen when you restore the same backup on v1\.5? If not, can you attach a metadata\-only backup for further investigation?

Commented by: Anderson Farias (afarias) Hi\. No, the same "problem" does \*not\* happen when restoring with FB 1\.5\. I'm attaching a metadata only backyp from FB 1\.5 as requested so...

Modified by: Anderson Farias (afarias) Attachment: SIG\_FB15\.7z \[ 11750 \]

Commented by: @dyemanov These triggers are automagically created by the engine to support the cascade referential integrity\. And they do exist in the ODS10 database restored by Firebird 1\.5 from...

Commented by: Anderson Farias (afarias) Hi Dmitry\. Yes, querying rdb$triggers on fb 1\.5 I can notice the trigger with rdb$system\_flag = 0\. But what I don't understand is: WHY \(and...

Commented by: @dyemanov You're right, the problem is exactly in ISQL\. Priorly, it checked for both RDB$SYSTEM\_FLAG 1 and the trigger being \*not\* referenced by RDB$CHECK\_CONSTRAINTS\. In v2\.5, the former...