Subject Re: Corrupt GDB - Re Restore Crisis
Author Alexander V.Nevsky
--- In ib-support@y..., "rodbracher" <rod@m...> wrote:
> When I tried to activate the index in IBConsole I got the above same
> error. There were no key duplicates in the orig GDB

Rod, of course they were, but query you used to find them used the
index which was broken. This is the reason why I recommended to make
this after dropping constraint/index. Or at least use explicit plan

Select key_field, count(key_field) from table
group by key_field
having count(*) > 1

> The corruption was caused by a transfer of the GDB from 1 server to
> another - not good.

There were active server process which accessed gdb file in time of
the copying. Server should be stopped before file copy (shutdown
is'nt enough, it does'nt break connections, just stop them from
making new queries), and we should'nt just ussue command and go, we
should make shure server process really stops and don't makes garbage

Best regards, Alexander V.Nevsky.