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
Em 19/08/2014 06:03, Dmitry Yemanov [email protected]
[firebird-support] escreveu:
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
--
Atenciosamente,
Hugo Eyng
