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
] 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 PR
FB
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Enviada em: segunda-feira, 18 de agosto de 2014 16:47
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] object is in use
Hello Carlos.
Thanks.
I am using IBExpert to run an
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
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 c
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 an
> 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
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.firebirddevelope
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
ft join mon$record_stats r on (st.mon$stat_id = r.mon$stat_id)
left join mon$io_stats io on (st.mon$stat_id = io.mon$stat_id)
where st.mon$state=1
order by st.mon$timestamp
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Enviada em: segunda-feira, 18 de agosto
Hello.
IBExpert shows the message:
lock conflict on no wait transaction
unsuccessful metada update
object MY_PROCEDURE is in use
How can I see 'who' is using the procedure?
--
Atenciosamente,
Hugo Eyng
> 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_i
> 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.
--
Hi,
sometimes when I need to change the database object - view/procedure - this
error is raised.
Can I detect which user/transaction causing this problem?
What can I do to not have this error?
Thank you in advance.
Tom
16 matches
Mail list logo