[Mono-bugs] [Bug 81856][Nor] New - Dead Lock

[bugzilla-daemon at 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 james at stev.org.

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

--- shadow/81856	2007-06-11 11:25:40.000000000 -0400
+++ shadow/81856.tmp.22542	2007-06-11 11:25:40.000000000 -0400
@@ -0,0 +1,83 @@
+Bug#: 81856
+Product: Mono: Runtime
+Version: 1.2
+OS: GNU/Linux [Other]
+OS Details: Etch with mono 1.2.4 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: misc
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: james at stev.org               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Summary: Dead Lock 
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+
+
+Steps to reproduce the problem:
+1. Run The Code Below
+
+Actual Results:
+This locks up somewhere in the mysql libs and never returns from strace i
+beleave it was happening on either the creation or the destruction of a
+thread. It does not occur in MS .NET on windows with the same mysql server
+and driver.
+
+Expected Results:
+To run Indefinatly
+
+
+How often does this happen? 
+Randomly but within 5 - 10 minutes for me
+
+Additional Information:
+
+Code
+
+using System;
+using System.Collections.Generic;
+using System.Text;
+using MySql.Data.MySqlClient;
+
+namespace Test {
+	class Program {
+		static void Main(string[] args) {
+			try {
+				MySqlConnection mysql;
+				mysql = new MySqlConnection("host=etc,,,");
+				int i = 0;
+
+				mysql.Open();
+
+				while (true) {
+					MySqlCommand sql = new MySqlCommand("select id from alias where userid
+= ?userid and gametypeid = ?gametypeid and centerid = ?centerid and name =
+?name");
+					MySqlDataReader rec;
+
+					sql.Parameters.AddWithValue("?userid", 1409);
+					sql.Parameters.AddWithValue("?gametypeid", 1);
+					sql.Parameters.AddWithValue("?centerid", 1);
+					sql.Parameters.AddWithValue("?name", "jcjfdjal");
+
+					sql.Connection = mysql;
+					//sql.Prepare();
+					rec = sql.ExecuteReader();
+					rec.Close();
+
+					Console.WriteLine(" Count = " + i);
+					i++;
+				}
+			} catch (Exception e) {
+				Console.WriteLine(e.Message);
+				Console.WriteLine(e.StackTrace);
+			}
+		}
+	}
+}