| Subject | Re: [firebird-support] Deadlock error from firebird during midnight |
|---|---|
| Author | |
| Post date | 2017-12-01T16:32Z |
I got this errors only during midnight. Thereafter it's working fine.
From: LtColRDSChauhan rdsc1964@... [firebird-support]
Sent: Thursday, 30 November, 8:29 PM
Subject: Re: [firebird-support] Deadlock error from firebird during midnight
To: firebird-support@yahoogroups.com
Do you get all the three errors all the time?
In my case long running querry through .NET Provider raised error "error reading data from connection ". The same queries ran fine through flamerobin.
Regards,
Rajiv
On 30 Nov 2017 19:01, "'Joje' joje@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:
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.