Subject (Helen) Re: gbk problem on FB/Rc2
Author alex_vnru
--- In ib-support@y..., "mk_delphi" <mk_delphi@y...> wrote:
> So the problem is not in come constrains, but I think in the
> gdb. The old gdb was made on FB/Rc1.
>
> What goes wrong? There is some corruption on old gdb?

Marco, I think it was corruption showing itself as broken constraint
on restore. In my practice I encounter mainly this kind of corruption
- for unknown (for me) reason some table contains one or few records
fully filled with NULLs. We can't see them by Select, but gbak tryes
to move them into new instance of database. In this case I make

gfix -v -f
gfix -m

(having copy of database, of course) and after it such a records
became visible for Select using Natural plan and can be deleted by
Delete using inique combination of null-filled non-indexed attribute
columns in Where clause. After it I make backup/restore and it is
successfull.
It is not RC2 problem, I encountered such corruptions since times of
IB4.

Best regards, Alexander V.Nevsky.