Re: [firebird-support] object is in use
To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br HEhmcfs Hello. HEhmcfs IBExpert shows the message: HEhmcfs lock conflict on no wait transaction HEhmcfs unsuccessful metada update HEhmcfs object MY_PROCEDURE is in use HEhmcfs How can I see 'who' is using the procedure?
Re: [firebird-support] object is in use
Hi Carlos. Where do I chage it? Hugo Em 18/08/2014 15:06, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] escreveu: To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br HEhmcfs Hello. HEhmcfs IBExpert shows the message: HEhmcfs lock conflict on no wait transaction HEhmcfs unsuccessful metada update HEhmcfs object MY_PROCEDURE is in use HEhmcfs How can I see 'who' is using the procedure? -- Atenciosamente, Hugo Eyng
RE: [firebird-support] object is in use
To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. While this would avoid the error, you will not know when/if your change will be applied. A connection can hold an object in use for an indeterminant period of time. For me, I want to know that the change will apply/has been made, if not, I will track down the source of the problem... and then re-run. Sean
Re: [firebird-support] object is in use
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). For the other cases, there is possibility to determine a timeout value in the ddl transaction. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br
Re: [firebird-support] object is in use
Re: [firebird-support] object is in use
I agree Em 18/08/2014 16:29, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] escreveu: To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. While this would avoid the error, you will not know when/if your change will be applied. A connection can hold an object in use for an indeterminant period of time. For me, I want to know that the change will apply/has been made, if not, I will track down the source of the problem... and then re-run. Sean -- Atenciosamente, Hugo Eyng
Re: [firebird-support] object is in use
Hello Carlos. Thanks. I am using IBExpert to run an 'CREATE OR ALTER PROCEDURE MY_PROCEDURE. That´s why I am not understending what can avoid to execute this. This PROCEDURE just returns a value from a table. I should be able to drop and insert a PROCEDURE at anytime into the DB. Should not I? Em 18/08/2014 16:40, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] escreveu: When you start a transaction you determine the wait mode. Where you set this depends on the component/access technology you are using. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br Hi Carlos. Where do I chage it? Hugo Em 18/08/2014 15:06, 'Carlos H. Cantu' lis...@warmboot.com.br mailto:lis...@warmboot.com.br[firebird-support] escreveu: To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br HEhmcfs Hello. HEhmcfs IBExpert shows the message: HEhmcfs lock conflict on no wait transaction HEhmcfs unsuccessful metada update HEhmcfs object MY_PROCEDURE is in use HEhmcfs How can I see 'who' is using the procedure? -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] object is in use
Re: [firebird-support] object is in use
Doesn´t work. The only way I found to alter a stored procedure in FB 2.5.2 , windows 64, SuperClassic is closing all conections and restarting the FB service. Hugo Em 18/08/2014 16:55, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] escreveu: Try to set the DDL transaction mode in Expert to WAIT instead of NO WAIT and see what happens. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br Hello Carlos. Thanks. I am using IBExpert to run an 'CREATE OR ALTER PROCEDURE MY_PROCEDURE. That´s why I am not understending what can avoid to execute this. This PROCEDURE just returns a value from a table. I should be able to drop and insert a PROCEDURE at anytime into the DB. Should not I? Em 18/08/2014 16:40, 'Carlos H. Cantu' lis...@warmboot.com.br mailto:lis...@warmboot.com.br[firebird-support] escreveu: When you start a transaction you determine the wait mode. Where you set this depends on the component/access technology you are using. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br Hi Carlos. Where do I chage it? Hugo Em 18/08/2014 15:06, 'Carlos H. Cantu' lis...@warmboot.com.br mailto:lis...@warmboot.com.br[firebird-support] escreveu: To avoid such error, try to change the DDL transaction parameter to WAIT instead of NO WAIT. Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org http://www.firebirdnews.org- www.FireBase.com.br http://www.FireBase.com.br HEhmcfs Hello. HEhmcfs IBExpert shows the message: HEhmcfs lock conflict on no wait transaction HEhmcfs unsuccessful metada update HEhmcfs object MY_PROCEDURE is in use HEhmcfs How can I see 'who' is using the procedure? -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng -- Atenciosamente, Hugo Eyng
Re: [firebird-support] object is in use
sometimes when I need to change the database object - view/procedure - this error is raised. Can I detect which user/transaction causing this problem? Possibly via the Trace API, but I haven't tried. What can I do to not have this error? Can be tricky in a database being in use. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
RE: [firebird-support] object is in use
sometimes when I need to change the database object - view/procedure - this error is raised. Can I detect which user/transaction causing this problem? Maybe something like: select distinct a.mon$user from mon$statements s join mon$attachments a on s.mon$attachment_id = s.mon$attachment_id where s.mon$sql_text containing view/procedure name and s.mon$transaction_id current_transaction could give you an indication as to who could be using the object? HTH, Set
