Subject Deadlock error from firebird during midnight
Author Joje

Hi All,


During midnight my service performs a calculation on firebird database. But I am receiving errors while fetching data from firebird database

1.       “ERR::-2147467259: Deadlock concurrent transaction number is 5744401”

2.       ERR::Error reading data from the connection.; FirebirdSql.Data.FirebirdClient

3.       ERR::Timeout exceeded.; FirebirdSql.Data.FirebirdClient:  

ERR::-2146233079: Connection must be valid and open

   at FirebirdSql.Data.FirebirdClient.FbCommand.CheckCommand()

   at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteScalar()


Interesting part is this error occurs only at midnight from 12 to 2 AM. Thereafter, everything goes smoothly without any error. I tried replicating this on my test machine but no success.


On analysing the pattern I think at midnight some CPU intensive applications like (Machine backup or AV scanning etc.) might be running on server machine.


I would like to know does any CPU intensive application running on FB installed machine can cause above errors while interacting with FB database.