Hello.

Sorry, but I didn´t, yet,  understand why I can´t exceute an ALTER PROCEDURE without closing all conections and restarting the FB service.

I guess that the problem could be related to my application leaving some transaction, that uses the SP, without commit/rollback or something so. But I am not sure.

Win 2008 R2 enterprise 64bits
Dell PowerEdge R620
32gb RAM
FB 2.5.2
SuperClassic

I notice that i am not the only one facing this trouble: http://tracker.firebirdsql.org/browse/CORE-3108

Using and WAIT or NO WAIT Transaction, in my opinion, is not the answer, or at least no the best answer.

I tried to find 'who' or 'what' is using the STORED PROCEDURE while I am trying to excecute the ALTER, but I was
not able to do it.

Hugo

18.08.2014 23:39, 'Carlos H. Cantu' wrote:

LSSBcfs> While this would avoid the error, you will not know when/if your change will be applied.
LSSBcfs> A connection can hold an object in use for an indeterminant period of time.

Dmitry said to me sometime ago that procedures changes will be
executed immediately and not get held. I tested and seems to be true
(ie: "wait" behavior is different for such case).

It's not about when your DDL is applied but about the cached procedure 
BLR that is used by others. The changed (new) procedure BLR will be used 
by newly compiled statements immediately after your DDL has been 
executed. However, all already compiled statements will keep using the 
old procedure BLR until these statements are released.

So Sean is correct except that "holding an object" applies to particular 
statements, not a connection as a whole.


Dmitry




------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com 
    firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/

-- 


Atenciosamente,

Hugo Eyng