object xxxx is in use

[DANIEL JUNGES]

Hi dears developers,

Sometimes we need to make changes to our procedures in the database.

Since I updated Firebird from version 2.1 to 4.0, now when I want to change a procedure I get the follow error message, if any user is still logged on the database:

object ... is in use --> FirebirdSql.Data.FirebirdClient.FbException: lock conflict on no wait transaction

This is causing us problems with automatic updates. 

Is there any way to be able to update a procedure, even with a user connected?

many thanks for every response

regards

Daniel Junges

[Jiří Činčura]

> Is there any way to be able to update a procedure, even with a user connected?

Not reliably. Best to disconnect all users, do maintenance and then continue working.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/