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

                 Key: DNET-825
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions:
         Environment: Windows 10, .Net 4.5.2
            Reporter: Danie Brink
            Assignee: Jiri Cincura

When using FB 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:
For more information on JIRA, see:


Check out the vibrant tech community on one of the world's most
engaging tech sites,!
Firebird-net-provider mailing list

Reply via email to