Re: [firebird-support] Re: Which connection causes object in use - is there a way to find that out?

[rgilland1...@gmail.com [firebird-support]]

This is something I asked several years ago, with no answer that I was happy 
with or could use. At least the exception should contain the connection IDs, 
holding the procedure in use.

Re: [firebird-support] Re: Which connection causes object in use - is there a way to find that out?

[Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]]

On 25.10.2016 o 10:20, hv...@users.sourceforge.net [firebird-support] wrote:
>> From time to time, when I try to alter a stored procedure in a
>> production database, I get "object in use" error.

>   Run DDL statement in wait transaction. Better to set some timeout to not 
> wait too much, but not no-wait mode
[...]
>   No, sorry (one can use lock manager but it is not trivial)

Thanks Vlad. I'll play a bit with wait transactions and see if it helps 
at least in some cases. At least I know there's no easy way which my 
ignorance prevents me from seeing ;)

regards
Tomasz

[firebird-support] Re: Which connection causes object in use - is there a way to find that out?

[hv...@users.sourceforge.net [firebird-support]]

---In firebird-support@yahoogroups.com,  wrote :
 
 > From time to time, when I try to alter a stored procedure in a 
> production database, I get "object in use" error. 

  Run DDL statement in wait transaction. Better to set some timeout to not wait 
too much, but not no-wait mode

> I was wandering, is 
 > there a way to find the connections (users) that prevent a particular 
> procedure from being altered?

  No, sorry (one can use lock manager but it is not trivial)

Regards,
Vlad