---- Reported by stm3@qwest.net 2004-09-26 05:14:49 MST ----

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.



---- Additional Comments From gonzalo@ximian.com 2004-09-26 22:25:26 MST ----



*** This bug has been marked as a duplicate of https://bugzilla.novell.com/show_bug.cgi?id=MONO66751 ***


Unknown bug field "cf_op_sys_details" encountered while moving bug
   <cf_op_sys_details>XP SP1</cf_op_sys_details>
Unknown operating system unknown. Setting to default OS "Other".
This bug was marked DUPLICATE in the database it was moved from.
    Changing resolution to "MOVED"