[Mono-bugs] [Bug 381151] DataAdapter returns 0 rows after an SQL timeout occured

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=381151

User vvaradhan at novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=381151#c18





--- Comment #18 from Veerapuram Varadhan <vvaradhan at novell.com>  2008-04-25 05:43:47 MST ---
(In reply to comment #14 from Gert Driesen)
> I've now updated another repro that forces a lock, similar to what Mark
> described, and which shows that the connection is no longer usable after the
> timeout.
> 
Your updated repro works both with svn trunk and Mark's assembly as well.

I get the following output when I run the updated repro.

work at vvaradhan:~/svn/mono/patches/381151> mono --debug 381151-regression-1.exe
mono --debug 381151-regression-1.exe
Record read: True

Unhandled Exception: System.Data.SqlClient.SqlException: Server closed the
connection. ---> Mono.Data.Tds.Prot\
ocol.TdsInternalException: Server closed the connection. --->
System.IO.IOException: Write failure ---> System\
Net.Sockets.SocketException: The socket has been shut down
  at System.Net.Sockets.Socket.Send (System.Byte[] buf, Int32 offset, Int32
size, SocketFlags flags) [0x0008b]\
 in /home/work/svn/mono/mcs/class/System/System.Net.Sockets/Socket.cs:2937
  at System.Net.Sockets.NetworkStream.Write (System.Byte[] buffer, Int32
offset, Int32 size) [0x00056] in /hom\
e/work/svn/mono/mcs/class/System/System.Net.Sockets/NetworkStream.cs:399 ---
End of inner exception stack trac\
e ---

  at System.Net.Sockets.NetworkStream.Write (System.Byte[] buffer, Int32
offset, Int32 size) [0x0007b] in /hom\
e/work/svn/mono/mcs/class/System/System.Net.Sockets/NetworkStream.cs:402
  at Mono.Data.Tds.Protocol.TdsComm.SendPhysicalPacket (Boolean isLastSegment)
[0x00081] in /home/work/svn/mon\
o/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/TdsComm.cs:565
  at Mono.Data.Tds.Protocol.TdsComm.SendPacket () [0x00000] in
/home/work/svn/mono/mcs/class/Mono.Data.Tds/Mon\
o.Data.Tds.Protocol/TdsComm.cs:548
  at Mono.Data.Tds.Protocol.Tds.ExecuteQuery (System.String sql, Int32 timeout,
Boolean wantResults) [0x0001e]\
 in
/home/work/svn/mono/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds.cs:482
--- End of inner exception s\
tack trace ---

  at Mono.Data.Tds.Protocol.Tds.ExecuteQuery (System.String sql, Int32 timeout,
Boolean wantResults) [0x00049]\
 in
/home/work/svn/mono/mcs/class/Mono.Data.Tds/Mono.Data.Tds.Protocol/Tds.cs:488
  at Mono.Data.Tds.Protocol.Tds70.Execute (System.String commandText,
Mono.Data.Tds.TdsMetaParameterCollection\
 parameters, Int32 timeout, Boolean wantResults) [0x00034] in
/home/work/svn/mono/mcs/class/Mono.Data.Tds/Mono\
Data.Tds.Protocol/Tds70.cs:516
  at System.Data.SqlClient.SqlCommand.Execute (CommandBehavior behavior,
Boolean wantResults) [0x001f4] in /ho\
me/work/svn/mono/mcs/class/System.Data/System.Data.SqlClient/SqlCommand.cs:456
--- End of inner exception stac\
k trace ---

  at System.Data.SqlClient.SqlCommand.Execute (CommandBehavior behavior,
Boolean wantResults) [0x0022f] in /ho\
me/work/svn/mono/mcs/class/System.Data/System.Data.SqlClient/SqlCommand.cs:461
  at System.Data.SqlClient.SqlCommand.ExecuteReader (CommandBehavior behavior)
[0x00027] in /home/work/svn/mon\
o/mcs/class/System.Data/System.Data.SqlClient/SqlCommand.cs:512


So, that leaves with one possibility that I need to update my SQL Server, which
I have started now. 


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.