connection shutdown error if connection remains open for more than 110 seconds 
on embedded server
-------------------------------------------------------------------------------------------------

                 Key: DNET-825
                 URL: http://tracker.firebirdsql.org/browse/DNET-825
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.12.1.0
         Environment: Windows 10, .Net 4.5.2
            Reporter: Danie Brink
            Assignee: Jiri Cincura


When using FB 3.0.3.329 as an embedded server it crashes after a connection has 
been in use for 110 seconds in 50-60% of instances. Seems to be similar to an 
issue reported when using 2.5 & 3.0 simultaneously and running backups but 
occurs when just using 3.0 and a prepared command . 

To reproduce the error:
Create a database with 1 table & 2 fields.
Create a connection to the database & then a FbCommand with 1 lookup parameter 
to select a record from the table & call .Prepare() on the FbCommand.
In a loop provide a value for the parameter & call the prepared FbCommand.

In 50-60% of runs firebird crashes after 110 - 115 seconds. Connection Pooling 
& lifetime settings appear to have no effect & once the error occurs the only 
way to establish a new connection to any database is to stop & restart the 
process. This does not happen with Firebird 2.5.8 or any other 2.5.x version 
we've used.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to