FbCommand locks up after closing and re-opening an interrupted connection
-------------------------------------------------------------------------
Key: DNET-131
URL: http://tracker.firebirdsql.org/browse/DNET-131
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.1.0 RC 2, 2.0.1
Environment: Windows XP, Visual Studio 2005, C#, .net 2.0
Reporter: Edward Winkelman
Assignee: Carlos Guzman Alvarez
While attempting to build some robustness into the backend of our new
application I began simulating network/server interruptions by shutting down
the super server between access calls. I would then perform an action that
would trigger a series of changes in the DataTable and follow that with a call
to FbDataAdapter.Update(). As expected, an exception was thrown (although what
kind wasn't consistent).
I then catch this exception and use it to call Close() on the open FbConnection
to the server and start a background process that periodically tries to Open()
the FbConnection again. As I have dozens of FbDataAdapters using this
connection spread across equally many classes I was hoping that this would
allow normal operations to resume.
Once the connection is re-opened successfully using the FbConnection.Open()
method I am able to create new FbCommands using that connection to retrieve
data (in this case a binary blob of an image). However when I attempt to use
FbDataAdapter.Update() the program locks up in an infinite loop.
I was able to trace this down to XdrStream.cs in the Read(byte[] buffer, int
offset, int count) method. The call to this.innerStream.Read(buffer, offset,
count) never returns.
--
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
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
