Bug #53239 innodb plugin 1.0.7 crashes on shutdown on windows

• Submitted: 28 Apr 2010 8:49
• Modified: 31 May 2010 15:31
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Duplicate
• Category: MySQL Server: InnoDB Plugin storage engine
• Severity: S1 (Critical)
• Version: 1.0.7
• OS: Windows
• CPU Architecture: Any
• Tags: regression

[28 Apr 2010 8:49] Shane Bester

Description:
Version: '5.1.46-enterprise-gpl-advanced'  socket: ''  port: 3306  MySQL Enterprise Server - Advanced Edition (GPL)
100428 10:39:30 [Note] mysqld: Normal shutdown

100428 10:39:30  InnoDB: Starting shutdown...
100428 10:39:34  InnoDB: Assertion failure in thread 4364 in file .\sync\sync0sync.c line 315
InnoDB: Failing assertion: mutex_get_lock_word(mutex) == 0
InnoDB: We intentionally generate a memory trap.

1800D0CCA    ha_innodb_plugin.dll!mutex_free()[sync0sync.c:315]
1800D1008    ha_innodb_plugin.dll!sync_close()[sync0sync.c:1441]
1800CDFED    ha_innodb_plugin.dll!innobase_shutdown_for_mysql()[srv0start.c:2009]
180091E0F    ha_innodb_plugin.dll!innobase_end()[ha_innodb.cc:2271]
140099074    mysqld.exe!ha_finalize_handlerton()[handler.cc:397]
140032C17    mysqld.exe!plugin_deinitialize()[sql_plugin.cc:828]
140035C3A    mysqld.exe!reap_plugins()[sql_plugin.cc:916]
14003641F    mysqld.exe!plugin_shutdown()[sql_plugin.cc:1544]
14001A2B7    mysqld.exe!clean_up()[mysqld.cc:1299]
14001ACBB    mysqld.exe!unireg_end()[mysqld.cc:1225]
14001CCFE    mysqld.exe!kill_server()[mysqld.cc:1168]
14001CD84    mysqld.exe!handle_shutdown()[mysqld.cc:2984]
14031BB65    mysqld.exe!pthread_start()[my_winthread.c:85]
1402E5C17    mysqld.exe!_callthreadstart()[thread.c:295]
1402E5CE5    mysqld.exe!_threadstart()[thread.c:275]
077D6B6CA    kernel32.dll!BaseThreadStart()

regression was recently introduced in 5.1.46 (plugin 1.0.7).
5.1.45 (plugin 1.0.6) didn't crash.

How to repeat:
extract one of the -no-install windows packages.

mysqld.exe --no-defaults --console --skip-grant-tables --skip-name-resolve --ignore-builtin-innodb --plugin-load=innodb=ha_innodb_plugin.dll

then mysqladmin shutdown -uroot -h127.0.0.1

[28 Apr 2010 16:41] MySQL Verification Team

okay, I find the problem.  install debugging tools for windows.
win "global flags" utility as administrator and enable those extra options, which will find more problems...

[28 Apr 2010 19:42] MySQL Verification Team

maybe related to bug #51001 !!! not sure why it only surfaces more strongly now, but i think it might be related.

[3 May 2010 12:54] MySQL Verification Team

to verifiers:  try debug binary and debug plugin and see if it crashes !

[24 May 2010 18:14] Vasil Dimov

Might be related to Bug#53947 InnoDB: Assertion failure in thread 4224 in file .\sync\sync0sync.c line 324

[31 May 2010 15:31] Calvin Sun

A dup of bug#53947.