Issue Details (XML | Word | Printable)

Key: DNET-825
Type: Bug Bug
Status: Closed Closed
Resolution: Cannot Reproduce
Priority: Major Major
Assignee: Jiri Cincura
Reporter: Danie Brink
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
.NET Data provider

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

Created: 07/Jun/18 01:01 PM   Updated: 22/Jan/19 10:09 AM
Component/s: ADO.NET Provider
Affects Version/s:
Fix Version/s: None

Environment: Windows 10, .Net 4.5.2

 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Descending order - Click to sort in ascending order
Jiri Cincura added a comment - 22/Jan/19 10:09 AM
Sadly, with the information provided I can't reproduce the issue on my side. If you want to reopen this, post a code that shows the issue.