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 Email Updates:
Status: Closed Impact on me:
None 
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:alexander.nozdrin@oracle.com-20101222212842-y0t3ibtd32wd9qaw) (version source revid:alexander.nozdrin@oracle.com-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:vasil.dimov@oracle.com-20110108150508-gpanhz48z8069qot) (version source revid:vasil.dimov@oracle.com-20110108150048-b1y9m8xe72hay0ch) (merge vers: 5.5.9) (pib:24)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.066 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.