Subject | (Helen) Re: gbk problem on FB/Rc2 |
---|---|
Author | alex_vnru |
Post date | 2002-01-29T14:39:42Z |
--- In ib-support@y..., "mk_delphi" <mk_delphi@y...> wrote:
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.
> So the problem is not in come constrains, but I think in theMarco, I think it was corruption showing itself as broken constraint
> gdb. The old gdb was made on FB/Rc1.
>
> What goes wrong? There is some corruption on old gdb?
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.