Subject Re: [ib-support] Re: Unsuccessful metatdata update: Index is in use
Author Claudio Valderrama C.
""ibrahim Bulut"" <ibrahim@...> wrote in message
> Hi Claudio and everybody
> I got this error message 10 days ago.
> And there is an interesting problem.
> I was trying to create a foreign key between two tables.
> There wasn't any wrong sql statement.
> But I got the same message.

There's a difference between

Statement failed, SQLCODE = -607
unsuccessful metadata update
-object T2 is in use

and INDEX IN USE. The first message says you should have only one attachment
to create a FK. This is a limitation by design. The second message says an
index was blocked by another operation. Disconnect all attachments, then
reconnect and retry with one connection. If it still fails with only one
attachment, something's wrong with the db. If it succeeds, then it was
normal limitation. There are a couple of operations that may mark an index
as being used. The problem is that you can't unprepare triggers directly,
for example. If a trigger was loaded and it requires an index in a table it
touches, then game over; better disconnect anything from that db if you get
a message the index is in use.

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing