Re: [firebird-support] Deadlock error from firebird during midnight

1. Noticed an intriguing thing. 2. I was believing that the exception "Error reading data from connection" was being raised when the RAM or Processor is highly stressed on executing a query / stored procedure. Hence I modified such executions as under: (a) instead of fetching all records in one b

Re: [firebird-support] Deadlock error from firebird during midnight

On Wed, Dec 13, 2017 at 2:22 AM, LtColRDSChauhan wrote: > > > On 12 Dec 2017 9:29 pm, "Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support]" wrote: > > 12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > 1. I have generated DMP files for : > > (a) The Fireb

Re: [firebird-support] Deadlock error from firebird during midnight

On 12 Dec 2017 9:29 pm, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" wrote: 12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. I have generated DMP files for : > (a) The Firebird server - size 62,028 KB and > (b) My .NET Application - size 2,65,968 K

Re: [firebird-support] Deadlock error from firebird during midnight

12.12.2017 13:28, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > 1. I have generated DMP files for : > (a) The Firebird server - size 62,028 KB and > (b) My .NET Application - size 2,65,968 KB > > 2. Please let me know how do I share these DMP files. If your database does not c

Re: [firebird-support] Deadlock error from firebird during midnight

On Tue, Dec 12, 2017 at 4:18 PM, LtColRDSChauhan wrote: > > > On 12 Dec 2017 16:02, "Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support]" wrote: > > 12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] > wrote: > > “Error reading data from the connection” has again surfa

Re: [firebird-support] Deadlock error from firebird during midnight

On 12 Dec 2017 16:02, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" wrote: 12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > “Error reading data from the connection” has again surfaced This is a server crash. This instruction may be useful for you to

Re: [firebird-support] Deadlock error from firebird during midnight

12.12.2017 7:32, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > “Error reading data from the connection” has again surfaced This is a server crash. This instruction may be useful for you to help developers fix it: http://ibphoenix.com/resources/documents/development/doc_35 -

Re: [firebird-support] Deadlock error from firebird during midnight

Hello, “Error reading data from the connection” has again surfaced despite of using FbTransaction tx = con.BeginTransaction( new FbTransactionOptions() {TransactionBehavior = FbTransactionBehavior.Concurrency | FbTransactionBehavior.NoWait}); Please help ! Regards, Rajiv On Sun, Dec 3,

RE: [firebird-support] Deadlock error from firebird during midnight

procedures work fine during day time without any issues. Thank you. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 03 December 2017 06:08 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Deadlock error from firebird during midnight

Re: [firebird-support] Deadlock error from firebird during midnight

On Sun, Dec 3, 2017 at 5:04 PM, DougC d...@moosemail.net [firebird-support] wrote: > > > Please, let us know what the cause ended up being and how you resolved the > problem! > > Alright, I will explain the issue in detail. 1. I have a .NET application of mine deployed since about last 7 yrs wit

Re: [firebird-support] Deadlock error from firebird during midnight

Please, let us know what the cause ended up being and how you resolved the problem! On Sat, 02 Dec 2017 23:08:49 -0500 LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote Thanks a lot, Dimitry ! This issue of mine, for which I had p

Re: [firebird-support] Deadlock error from firebird during midnight

Thanks a lot, Dimitry ! This issue of mine, for which I had posted for help on the firebird-net-provider group, is now resolved. On Fri, Dec 1, 2017 at 10:06 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 01.12.2017 17:32, j...@codework-solutions.com [firebird-support] wro

Re: [firebird-support] Deadlock error from firebird during midnight

01.12.2017 17:32, j...@codework-solutions.com [firebird-support] wrote: > I got this errors only during midnight. Thereafter it's working fine. It may pretend to work fine, but using default transaction isolation level in .NET provider is just a disaster waiting to happen. It is the reason of

Re: [firebird-support] Deadlock error from firebird during midnight

I got this errors only during midnight. Thereafter it's working fine. Get Outlook for Android From: LtColRDSChauhan rdsc1...@gmail.com [firebird-support] Sent: Thursday, 30 November, 8:29 PM Subject: Re: [firebird-support] Deadlock error from firebird during midnight To: fir

Re: [firebird-support] Deadlock error from firebird during midnight

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' j...@codework-solutions.com [firebird-support]" wrote:

Re: [firebird-support] Deadlock error from firebird during midnight

30.11.2017 14:31, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > 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

[firebird-support] Deadlock error from firebird during midnight

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.; FirebirdS