[Mono-bugs] [Bug 81856][Nor] Changed - Dead Lock with mysql

[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-07-04 12:14:09.000000000 -0400
+++ shadow/81856.tmp.24637	2007-07-05 05:15:01.000000000 -0400
@@ -83,6 +83,55 @@
 }
 
 ------- Additional Comments From lupus at ximian.com  2007-07-04 12:14 -------
 What kind of box are you using? x86 smp?
 If you could also include a sample db that can be used to reproduce
 with this program it would be great.
+
+------- Additional Comments From james at stev.org  2007-07-05 05:15 -------
+
+The table i am querying looks like this
+
+CREATE TABLE `alias` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `userid` int(10) unsigned NOT NULL,
+  `gametypeid` int(11) NOT NULL,
+  `centerid` int(11) NOT NULL,
+  `name` varchar(128) NOT NULL,
+  `count` int(10) unsigned NOT NULL,
+  `lastseen` datetime NOT NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `userid` (`userid`,`gametypeid`,`name`,`centerid`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+The machine is
+
+processor       : 0
+vendor_id       : AuthenticAMD
+cpu family      : 6
+model           : 8
+model name      : AMD Athlon(tm) XP 2600+
+stepping        : 1
+cpu MHz         : 2088.059
+cache size      : 256 KB
+fdiv_bug        : no
+hlt_bug         : no
+f00f_bug        : no
+coma_bug        : no
+fpu             : yes
+fpu_exception   : yes
+cpuid level     : 1
+wp              : yes
+flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
+mca cmov pat pse36 mmx fxsr sse syscall mmxext 3dnowext 3dnow ts
+bogomips        : 4179.16
+
+Single Processor
+The same bug does not happen when running on MS .Net 2.0 in windows
+using the database remotely to the linux machine nor on its local
+machine running a database. When running on either a local or a remote
+database the problem will occur when running in mono. I cannot get the
+bug to occur with tracing enabled on mono which would suggest to me
+its going to be hard to reproduce on a different system and is
+possibly some kind of race.
+
+