Lock Conflit Error FIREBIRD

0

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

We use Firebird as SGDB and IBExpert as a database administration and configuration tool. Because the application in question is used simultaneously by multiple users (performing UPDATE, DELETE and INSERT operations on the same table practically) lock conflict errors occur. I have read that by 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, not on the Server machine to can I run the command above?

Thanks in advance for your attention!

    
asked by anonymous 12.09.2018 / 04:50

1 answer

0

IBExpert does not have access to transactions made at the bank. To commit, it will depend on the application that is using the same bank.

You can resolve lock conflict by giving shutdown on the base and making it to online again or restarting Firebird. In both cases, the connections are dropped and consequently the transactions.

However, it is a risky procedure since you are terminating the connection with the bank. And if someone is currently making changes to some data, there is a possibility of corrupting.

At least as far as I know. Please wait for a while to see if anyone has a better answer.

    
03.12.2018 / 17:38