Subject Re: [firebird-support] Object is in use?
Author Kjell Rilbe
New: reproducible test case below.

Kjell Rilbe wrote:

> When trying to drop a table I now and then get "Object XXX is in use"
> when trying to commit. This is with FB WI-V2.1.0.17798.
> The only way I've found to resolve it is to disconnect and try again.
> Any other ways to resolve it, without disconnecting?
> Is this a bug? What's the tracker ID?

In FlameRobin Unicode for Win32 I just tried this on a UTF8
database with ODS 11.1 and no other connections:

<connect - OK>

create table A (B int);
<execute - OK>
<commit - OK>

select * from A;
<execute - OK>
<commit - OK>

drop table A;
<execute - OK>
<commit - error>

*** IBPP::SQLException ***
Context: Transaction::Commit

SQL Message : -607
This operation is not defined for system tables.

Engine Code : 335544351
Engine Message :
unsuccessful metadata update
object A is in use

<disconnect - OK>
<connect - OK>
drop table A;
<execute - OK>
<commit - OK>

So, can anyone explain if this is 1) a bug or 2) as designed and if it's
as deigned 3) why and 4) how to avoid it or solve it without a disconnect?

I guess the "problem" (if it *is* a problem) can come from FB, IBPP or FR.

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64