Subject Re: [firebird-support] Deadlock error from firebird during midnight
Author LtColRDSChauhan
Post date 2017-12-13T03:50:07Z

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 <rdsc1964@...> wrote:


On Wed, Dec 13, 2017 at 2:22 AM, LtColRDSChauhan <rdsc1964@...> wrote:


On 12 Dec 2017 9:29 pm, "Dimitry Sibiryakov sd@... [firebird-support]" <firebird-support@yahoogroups. com> wrote:
12.12.2017 13:28, LtColRDSChauhan rdsc1964@... [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:


2. Some information on the DMP files:
(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

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/ firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoog roups.com
    firebird-support-fullfeatured@ yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@y ahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/u s/yahoo/utos/terms/