Bug #58459 assert slot->in_use == FALSE while starting purge thread

• Submitted: 24 Nov 2010 14:03
• Modified: 11 Jan 2011 0:52
• Reporter: Mikhail Izioumtchenko
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.5
• OS: Any
• Assigned to: Sunny Bains
• CPU Architecture: Any

[24 Nov 2010 14:03] Mikhail Izioumtchenko

Description:
while starting the purge thread:

101124  1:46:01  InnoDB: Assertion failure in thread 1310099776 in file ......./storage/innobase/srv/srv0srv.c line 843
InnoDB: Failing assertion: slot->in_use == FALSE
101124  1:46:01 - mysqld got signal 6 ;

How to repeat:
start mysqld with innodb-purge-threads=1, but the reproducibility is very low.

Suggested fix:
invoke srv_table_reserve_slot() under the protection of the kernel mutex maybe

[22 Dec 2010 21:30] Bugs System

Pushed into mysql-trunk 5.6.1 (revid:[e-mail]-20101222212842-y0t3ibtd32wd9qaw) (version source revid:[e-mail]-20101222212842-y0t3ibtd32wd9qaw) (merge vers: 5.6.1) (pib:24)

[8 Jan 2011 15:10] Bugs System

Pushed into mysql-5.5 5.5.9 (revid:[e-mail]-20110108150508-gpanhz48z8069qot) (version source revid:[e-mail]-20110108150048-b1y9m8xe72hay0ch) (merge vers: 5.5.9) (pib:24)