Bug #24207 Crash + InnoDB recovery memory overrun during sql-bench
Submitted: 11 Nov 2006 1:18 Modified: 30 Nov 2006 14:21
Reporter: [ name withheld ]
Status: Duplicate
Category:Server: InnoDB Severity:S2 (Serious)
Version:5.1.12-beta OS:Microsoft Windows (Windows Server 2003 R2 x64 Editi)
Assigned to: Heikki Tuuri Target Version:
Tags: windows, x64, crash, overrun

[11 Nov 2006 1:18] [ name withheld ] 
Description:
MySQL server crashes and on restart innodb can't recover, with the reocvery failign due
to a possible memory overrun / failed assertion.  Full details are attached in
localhost.err (mysql log) and in the nohup.out (output of run-all-tests) and in insert
test log.

The crash doesn't occur with MyISAM tables.

How to repeat:
1.) Install mysql-5.1.12-beta for windows x64.
2.) Install preresiquites for sql-bench 
3.) Launch run-all-tests with the following options:
 --connect-options=mysql_read_default_file=[path to my.cnf] --tcpip
--create-options=type=InnoDB
4.) Observe that the test will fail during the 'insert' test due to a lost connection. 
Further, the mysql server has crashed.
5.) Attempt to restart mysql server
[11 Nov 2006 1:26] [ name withheld ] 
mysql error log

Attachment: localhost.err (application/octet-stream, text), 5.55 KiB.
[11 Nov 2006 1:27] [ name withheld ] 
output of run-all-tests

Attachment: nohup.out (application/octet-stream, text), 4.03 KiB.
[11 Nov 2006 1:28] [ name withheld ] 
the output of the insert test

Attachment: insert-mysql-CYGWIN_NT_5.2_WOW64_1.5.21(0.156_4_2)_i686 (application/octet-stream, text), 3.86 KiB.
[11 Nov 2006 14:19] Valeriy Kravchuk 
Thank you for a bug report. How much RAM do you have on that machine? What exact command
did you use to run sql-bench?
[11 Nov 2006 14:20] Valeriy Kravchuk 
Sorry, missed other commented. Please, answer to question about RAM only.
[11 Nov 2006 17:01] [ name withheld ] 
The machine has 8GB of RAM.
[13 Nov 2006 13:21] Heikki Tuuri 
This is probably a duplicate of http://bugs.mysql.com/bug.php?id=19424, a suspected
compiler bug in the 64-bit Windows.
[13 Nov 2006 13:22] Heikki Tuuri 
Can you repeat this with mysqld-debug.exe? It does not contain compiler optimizations.

Regards,

Heikki
[13 Nov 2006 17:04] [ name withheld ] 
I tried to reproduce with mysqld-debug.exe from 5.1.12, but bug
http://bugs.mysql.com/bug.php?id=24267 blocks me from doing so.