Conflit FIREBIRD Lock Error

Question

I’m new to the subject of database, so I hope you understand my doubt and lack of knowledge:

We use Firebird as SGDB and Ibexpert as a tool for database administration and configuration. Because the application in question is used simultaneously by several users (performing UPDATE, DELETE and INSERT operations in the same table practically) there are Conflict lock errors. I had read that while waiting a few minutes the transaction solidifies (or stopping the Database Service and starting again) and there is also the option to run the command below.

gfix -commit all

However, my question is: Is there any command that can be executed in Ibexpert for example, and that confirms these transactions at the time of execution, since the connection to the Database would be remotely, and not on the Server machine to be able to run the command mentioned above?

Thank you for your attention!

Answer 1

Ibexpert has no access to bank transactions. To commit, it will depend on the application that is using the same bank.

It is possible to solve the lock Conflict giving shutdown at the base and making to online again or by restarting Firebird. In both cases, the connections are dropped and consequently the transactions.

But it is a risky procedure, since you are terminating the connection with the bank. And if at the moment someone is making any changes, there is possibility of corrupting.

As far as I know. Wait a little longer to see if anyone has a better answer.