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

On Thu, Dec 14, 2017 at 4:11 PM, Dimitry Sibiryakov sd@... [firebird-support] <> wrote:
14.12.2017 11:34, LtColRDSChauhan rdsc1964@... [firebird-support] wrote:
>   INET/inet_error: read errno = 10054, client host = RajivPC, address =
> <>, user = rdsc1

   If these data match your .NET application, then you have problem with network hardware
or software: cables, routers, antivirus, firewall, etc.

1. Here server and client both are on the same machine, RajivPC. The deployed application has remote server. The exception caught in all cases are identical.
2. Execution of only one stored procedure has started to fail as the number of records to be fetched increased. Rest are still executing fine. Older set of records, lesser in number, are still fetched correctly.
3. On setting pooling to false, the application has stopped to hang after the exception was thrown.
4. To me the issue appears to be:
(a) On executing a long running query the .NET Provider connection gets dropped. The exception caught does not give much insight.
(b) In such a scenario the connection pool holds dropped connections. Further attempt to connect throw unhandled exceptions.

   WBR, SD.

------------------------------ ------

------------------------------ ------

++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++

Visit 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 resources/documents/

++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++ ++++++
------------------------------ ------

Yahoo Groups Links

<*> To visit your group on the web, go to: firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to: firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:

<*> To unsubscribe from this group, send an email to:

<*> Your use of Yahoo Groups is subject to: us/yahoo/utos/terms/