Bug #37795 main.innodb_mysql crashes randomly

• Submitted: 2 Jul 2008 9:32
• Modified: 2 May 2009 13:37
• Reporter: Alexander Nozdrin
• Status: No Feedback
• Category: Tests: Engine
• Severity: S3 (Non-critical)
• Version: 5.1, 6.0
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any
• Tags: crash, pushbuild, sporadic, test failure

[2 Jul 2008 9:32] Alexander Nozdrin

Description:
Symptoms w/o valgrind (no crash):
---------------------------------------------------------------
@@ -1571,8 +1571,6 @@
 2	init+con1
 # Switch to connection con2
 SELECT * FROM t1;
-a	b
-2	init+con1
 DROP PROCEDURE p1;
 DROP TABLE t1, t2;
 CREATE TABLE t1 (a INT NOT NULL, b INT NOT NULL, PRIMARY KEY (a,b)) engine=innodb;
---------------------------------------------------------------

Symptoms with valgrind (crash)
---------------------------------------------------------------
@@ -1571,8 +1571,7 @@
 2	init+con1
 # Switch to connection con2
 SELECT * FROM t1;
-a	b
-2	init+con1
+ERROR HY000: Lost connection to MySQL server during query
 DROP PROCEDURE p1;
 DROP TABLE t1, t2;
 CREATE TABLE t1 (a INT NOT NULL, b INT NOT NULL, PRIMARY KEY (a,b)) engine=innodb;
---------------------------------------------------------------

See also Bug#32724.

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.innodb_mysql

[21 Oct 2008 8:21] Alexander Nozdrin

See also Bug#38741 -- another innodb_mysql failure.

[21 Oct 2008 15:52] Mikhail Izioumtchenko

hardly a duplicate, sorry, got confused by textual similarity of the bug texts.  http://bugs.mysql.com/bug.php?id=38741 does look like MySQL bug, and this one isn't necessarily so. What are your expectations of InnoDB's team regarding this bug? One thing is that as far as I understand we can't access your intranet sites,
such as https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.innodb_mysql that this bug refers to

[2 Dec 2008 19:46] Sven Sandberg

Updating version: this happens in 5.1 too.

Here is a better xref (shows only this failure): http://tinyurl.com/5ejw6r

[2 Apr 2009 13:37] Alexander Nozdrin

It seems that this bug should be fixed by the patch
for Bug#38741.

Putting it to 'Need Feedack' -- if it appears again,
please put it back to 'Verified'.

[2 May 2009 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[16 May 2009 8:41] Bugs System

Pushed into 6.0.12-alpha (revid:[e-mail]-20090516083402-0avycdy7w6dnn0tv) (version source revid:[e-mail]-20090512164111-jz224w5781lhe7wd) (merge vers: 6.0.12-alpha) (pib:6)