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 batch, I was fetching the records in small batches using something like 'select first BATCH_SIZE skip BATCH_SIZE * BATCH_COUNT from ...' in a loop. (b) dropped some fields to be fetched. 3. After some time I started to get the exception again, and all the time (DMP files + Database URL shared), despite the modifications at Para 2(a) and 2(b) above. 4. Today I executed the stored procedure with settings to get fetch all the records in a single batch and with all the fields, and there are no exception raised. While Execution as per Para 2(a) and (b) still always raises the exception. On Wed, Dec 13, 2017 at 4:39 AM, LtColRDSChauhan <rdsc1...@gmail.com> wrote: > > > On Wed, Dec 13, 2017 at 2:22 AM, LtColRDSChauhan <rdsc1...@gmail.com> > wrote: > >> >> >> On 12 Dec 2017 9:29 pm, "Dimitry Sibiryakov s...@ibphoenix.com >> [firebird-support]" <firebird-support@yahoogroups.com> 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 KB >> > >> > 2. Please let me know how do I share these DMP files. >> >> If your database does not contain secrets, it is better to pack and >> upload them >> somewhere and post the URL into firebird-devel. Otherwise wait while >> someone of developers >> visit this thread and ask for sending them privately. >> >> >> I will have to wait. >> > > Hello Dimitry, > > *1*. I have obfuscated data in my database and again created the DMP > files after the crash. The pack at the URL below contains the DMP files (of > the Firebird server and my .NET front end application) and the database > file: > > https://drive.google.com/file/d/15snhQ-VcJD91Jk0eD- > Fgt6sEqQ8UM9Pv/view?usp=sharing > > *2*. Some information on the DMP files: > (a) Created the DMP files as per https://support.microsoft.com/ > en-in/help/931673/how-to-create-a-user-mode-process-dump-file-in-windows > (b) Set the registry key for Full dump as under, still on opening the DMP > files using Visual Studio I find heading "Minidump File Summary" > > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error > Reporting\LocalDumps > Value Name = DumpType > Value Data = 2 > > (c) Both the DMP files report "Exception code" as "not found" > > *3*. Kindly let me know: > (a) when I can remove the shared file. > (b) how can I please track progress / resolution of the issue. > > Thanks and Regards, > Rajiv > > > >> >> -- >> WBR, SD. >> >> >> ------------------------------------ >> >> ------------------------------------ >> >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> >> Visit http://www.firebirdsql.org and click the Documentation item >> on the main (top) menu. Try FAQ and other links from the left-side menu >> there. >> >> Also search the knowledgebases at http://www.ibphoenix.com/resou >> rces/documents/ >> >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ >> ------------------------------------ >> >> Yahoo Groups Links >> >> >> >> >> >