[Mono-bugs] [Bug 66852][Nor] New - Memory leak in runtime or in XSP for Windows.

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by stm3@qwest.net.

http://bugzilla.ximian.com/show_bug.cgi?id=66852

--- shadow/66852	2004-09-26 05:14:49.000000000 -0400
+++ shadow/66852.tmp.26909	2004-09-26 05:14:49.000000000 -0400
@@ -0,0 +1,87 @@
+Bug#: 66852
+Product: Mono: Runtime
+Version: unspecified
+OS: 
+OS Details: XP SP1
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: misc
+AssignedTo: mono-bugs@ximian.com                            
+ReportedBy: stm3@qwest.net               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Memory leak in runtime or in XSP for Windows.
+
+Please fill in this template when reporting a bug, unless you know what 
+you are doing.
+Description of Problem:
+Memory leak in ASP portion of runtime or XSP
+
+Steps to reproduce the problem:
+Compile this code (I used MS .NET, which may very well be important) as a 
+webservice:
+		[WebMethod]
+		public string returnRecordset ()
+		{
+			try
+			{
+				System.Data.Odbc.OdbcConnection conn = new 
+System.Data.Odbc.OdbcConnection();
+				conn.ConnectionString = "DSN=NorthWind";
+				conn.Open();
+				System.Data.Odbc.OdbcCommand command = new 
+System.Data.Odbc.OdbcCommand
+					("SELECT * FROM CUSTOMERS", conn);
+				System.Data.Odbc.OdbcDataAdapter da = new 
+System.Data.Odbc.OdbcDataAdapter();
+				da.SelectCommand = command;
+				System.Data.DataSet ds = new DataSet
+("Customers");
+				da.Fill (ds);
+				System.IO.StringWriter tw = new 
+System.IO.StringWriter();
+				ds.WriteXml(tw, 
+System.Data.XmlWriteMode.WriteSchema);
+				conn.Close();
+				return tw.ToString();
+			}
+			catch(System.Exception se)
+			{
+				return se.Message;
+			}
+			
+
+		}
+
+Consume webservice repeatedly using any client.
+
+Update:  The following webservice also leaks about 2 megs per hit:
+[WebMethod]
+public int addTwoNumbers (int iX, int iY)
+  {return iX+iY;}
+
+Actual Results:
+Memory usage climbs about 2 megs per call (sometimes doesn't 
+climb..sometimes jumps 6 megs).  Size of XML'd recordset is 39K.  Shows no 
+signs of stopping at 200 megs of memory usage.  Size of entire NORTHWIND 
+database is 1.4 megs, so I'm guessing the data here isn't the issue.
+
+Expected Results:
+Memory usage should eventually stabilize.  ASP.NET stabilizes at around 30 
+megs of usage on my machine.
+
+How often does this happen? 
+Always
+
+Additional Information:
+
+I tried to compile this using MSC.EXE to provide more info but was unable 
+to find ANY instructions or example code on the web.  I'm also unable to 
+say whether this behavior happens on Linux due to lack of a current Linux 
+box.  :(  Assumed something this straightforward had already been 
+reported, but couldn't find a bug report mentioning memory and 
+windows..Sorry if it's a dup.