Bug #55581 shutdown with innodb-use-sys-malloc=0: assert mutex->magic_n == MUTEX_MAGIC_N
Submitted: 27 Jul 2010 11:50 Modified: 26 Oct 2010 1:25
Reporter: Mikhail Izioumtchenko Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB Plugin storage engine Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: Jimmy Yang CPU Architecture:Any

[27 Jul 2010 11:50] Mikhail Izioumtchenko
Description:
shutdown with innodb-use-sys-malloc=0: assert mutex->magic_n == MUTEX_MAGIC_N,
when compiled with UNIV_SYNC_DEBUG. 
Likely a duplicate of something fixed in 5.5.

 #5  0x0000003acbc31d10 in abort () from /lib64/libc.so.6
 #6  0x00002aaaabcb3452 in mutex_validate (mutex=0x1904d318)
     at sync/sync0sync.c:404
 #7  0x00002aaaabcb2bc9 in mutex_enter_func (mutex=0x1904d318,
     file_name=0x2aaaabceddb0 "mem/mem0pool.c", line=570)
     at ./include/sync0sync.ic:205
 #8  0x00002aaaabc4f901 in mem_area_free (ptr=0x2aaaac5cb048, pool=0x1904d300)
     at mem/mem0pool.c:570
 #9  0x00002aaaabc4e572 in mem_heap_block_free (heap=0x2aaaac5cb048,
     block=0x2aaaac5cb048) at mem/mem0mem.c:511
 #10 0x00002aaaabc4bdf9 in mem_heap_free_func (heap=0x2aaaac5cb048,
     file_name=0x2aaaabd00b0d "srv/srv0srv.c", line=1009)
     at ./include/mem0mem.ic:504
 #11 0x00002aaaabc4bf39 in mem_free_func (ptr=0x2aaaac5cb0d0,
     file_name=0x2aaaabd00b0d "srv/srv0srv.c", line=1009)
     at ./include/mem0mem.ic:571
 #12 0x00002aaaabca8bd0 in srv_free () at srv/srv0srv.c:1009
 #13 0x00002aaaabcaf0e4 in innobase_shutdown_for_mysql ()
     at srv/srv0start.c:2009
 #14 0x00002aaaabc2027f in innobase_end (hton=0x1904c9d0, type=HA_PANIC_CLOSE)
     at handler/ha_innodb.cc:2306
 #15 0x00000000006fea9c in ha_finalize_handlerton (plugin=0x19040aa0)
     at handler.cc:395
 #16 0x000000000079c557 in plugin_deinitialize (plugin=0x19040aa0,
     ref_check=true) at sql_plugin.cc:828
 #17 0x000000000079c8fc in reap_plugins () at sql_plugin.cc:916
 #18 0x000000000079e935 in plugin_shutdown () at sql_plugin.cc:1551
 #19 0x00000000005dfca3 in clean_up (print_message=true) at mysqld.cc:1298
 #20 0x00000000005e02c6 in unireg_end () at mysqld.cc:1224
 #21 0x00000000005e3be3 in kill_server (sig_ptr=0x0) at mysqld.cc:1159
 #22 0x00000000005e3c07 in kill_server_thread (arg=0x40704118) at mysqld.cc:1187
 #23 0x0000003acc80673d in start_thread () from /lib64/libpthread.so.0
 #24 0x0000003acbcd3d1d in clone () from /lib64/libc.so.6

How to repeat:
innodb-use-system-malloc=0 -> workload -> shutdown, 
not 100% repeatable but happens often.
[28 Jul 2010 3:21] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/114492

3541 Jimmy Yang	2010-07-27
      Fix bug #55581 by backporting fix of #52546 to 5.1 plugin.
[29 Jul 2010 21:04] Mikhail Izioumtchenko
the fix has been pushed and tested, everything is OK.
[4 Aug 2010 8:05] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804080001-bny5271e65xo34ig) (version source revid:alik@sun.com-20100731075120-qz9z8c25zum2wgmm) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 8:21] Bugs System
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@ibmvm-20100804081533-c1d3rbipo9e8rt1s) (version source revid:alik@sun.com-20100731075120-qz9z8c25zum2wgmm) (merge vers: 5.6.99-m4) (pib:18)
[4 Aug 2010 9:02] Bugs System
Pushed into mysql-next-mr (revid:alik@ibmvm-20100804081630-ntapn8bf9pko9vj3) (version source revid:alik@sun.com-20100731075120-qz9z8c25zum2wgmm) (pib:20)
[17 Aug 2010 19:12] John Russell
Added to change log:

The server could crash on shutdown, if started with --innodb-use-system-malloc=0.
[19 Aug 2010 15:42] Bugs System
Pushed into mysql-5.1 5.1.51 (revid:build@mysql.com-20100819151858-muaaor6jojb5ouzj) (version source revid:build@mysql.com-20100819151858-muaaor6jojb5ouzj) (merge vers: 5.1.51) (pib:20)
[14 Oct 2010 8:29] Bugs System
Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.20 (revid:martin.skold@mysql.com-20101014082627-jrmy9xbfbtrebw3c) (version source revid:martin.skold@mysql.com-20101014082627-jrmy9xbfbtrebw3c) (merge vers: 5.1.51-ndb-7.0.20) (pib:21)
[14 Oct 2010 8:45] Bugs System
Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.39 (revid:martin.skold@mysql.com-20101014083757-5qo48b86d69zjvzj) (version source revid:martin.skold@mysql.com-20101014083757-5qo48b86d69zjvzj) (merge vers: 5.1.51-ndb-6.3.39) (pib:21)
[14 Oct 2010 8:59] Bugs System
Pushed into mysql-5.1-telco-6.2 5.1.51-ndb-6.2.19 (revid:martin.skold@mysql.com-20101014084420-y54ecj85j5we27oa) (version source revid:martin.skold@mysql.com-20101014084420-y54ecj85j5we27oa) (merge vers: 5.1.51-ndb-6.2.19) (pib:21)