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. Thanks.
