[Mono-bugs] [Bug 556835] New: SqlClient multiple result sets not gives error

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Thu Nov 19 04:36:41 EST 2009 

http://bugzilla.novell.com/show_bug.cgi?id=556835

http://bugzilla.novell.com/show_bug.cgi?id=556835#c0


           Summary: SqlClient multiple result sets not gives error
    Classification: Mono
           Product: Mono: Class Libraries
           Version: 1.2.0
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: P5 - None
         Component: Sys.Data.SqlClient
        AssignedTo: mono-bugs at lists.ximian.com
        ReportedBy: maarten at bakkerspees.nl
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---
           Blocker: ---


Created an attachment (id=328397)
 --> (http://bugzilla.novell.com/attachment.cgi?id=328397)
minimal example for sqlclient/multiple result sets problem

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5)
Gecko/20091102 Firefox/3.5.5

SqlClient seems to allow only a single result set. When a second reader is
executed you get the 'There is already an open DataReader associated with this
Connection which must be closed first.' error.
'MultipleActiveResultSets=true' is set in the connectionstring.
This only happens on Linux. Mono on Windows works fine, as does Windows native.

Reproducible: Always

Steps to Reproduce:
1. run attached code example.

Actual Results:  
== mono/linux ==
Module test, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null loaded.
Module System.Data, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 loaded.
Module System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 loaded.

Module Mono.Data.Tds, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=0738eb9f132ed756 loaded.
Module System.Xml, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 loaded.

Module System.Transactions, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 loaded.

Module System.Configuration, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a loaded.
Thread 4 created.

Thread 5 created.

Module Mono.Security, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=0738eb9f132ed756 loaded.
Thread 5 exited.
-  <- this is the output from Console.WriteLine()

Unhandled Exception: System.InvalidOperationException: There is already an open
DataReader associated with this Connection which must be closed first.
  at System.Data.SqlClient.SqlCommand.ValidateCommand (System.String method,
Boolean async) [0x00000] 
  at System.Data.SqlClient.SqlCommand.ExecuteReader (CommandBehavior behavior)
[0x00000] 
  at (wrapper remoting-invoke-with-check)
System.Data.SqlClient.SqlCommand:ExecuteReader (System.Data.CommandBehavior)
  at test.MainClass.Main (System.String[] args) [0x00053] in
/home/maarten/work/test/visiback_working_copy/test/Main.cs:22 

Thread 2 exited.

Thread 4 exited.

Thread 3 exited.

Thread 1 exited.

Process 1 exited.

Target exited.

== mono/windows ==
Loaded Module
'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll'Started
Thread 2268Loaded Module
'C:\work\visiback_working_copy\test\bin\Debug\test.exe'
Loaded Module
'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll'Loaded
Module
'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll'Loaded
Module
'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll'Loaded
Module
'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll'Started
Thread 2348Loaded Module
'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll'Loaded
Module
'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll'Loaded
Module
'C:\WINDOWS\assembly\GAC_MSIL\mscorlib.resources\2.0.0.0_nl_b77a5c561934e089\mscorlib.resources.dll'

== windows native ==
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.HostingProcess.Utilities\9.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.HostingProcess.Utilities.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.HostingProcess.Utilities.Sync\9.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.HostingProcess.Utilities.Sync.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.Debugger.Runtime\9.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Debugger.Runtime.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'c:\work\visiback_working_copy\BSVisiOleDb\bin\Debug\BSVisiWindows.vshost.exe',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Core\3.5.0.0__b77a5c561934e089\System.Core.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'BSVisiWindows.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.HostingProcess.Utilities\9.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.HostingProcess.Utilities.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Windows.Forms\2.0.0.0__b77a5c561934e089\System.Windows.Forms.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.HostingProcess.Utilities.Sync\9.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.HostingProcess.Utilities.Sync.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.Debugger.Runtime\9.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Debugger.Runtime.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\mscorlib.resources\2.0.0.0_nl_b77a5c561934e089\mscorlib.resources.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'c:\work\visiback_working_copy\test\bin\Debug\test.vshost.exe', Skipped loading
symbols. Module is optimized and the debugger option 'Just My Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'c:\work\visiback_working_copy\test\bin\Debug\test.exe', Symbols loaded.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
'test.vshost.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just My
Code' is enabled.
The thread '<No Name>' (0xba8) has exited with code 0 (0x0).
The thread 0xbe0 has exited with code 0 (0x0).
The program '[2460] test.vshost.exe: Managed' has exited with code 0 (0x0).
The program '[2632] BSVisiWindows.vshost.exe: Managed' has exited with code 0
(0x0).

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

More information about the mono-bugs mailing list