Bug #64265 MySQL crashing itself on long semaphore wait
Submitted: 8 Feb 2012 13:56 Modified: 28 Dec 2017 15:31
Reporter: Evan Schmidt Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:5.1.48, 5.1.62 OS:Linux (CentOS release 5.4 (Final))
Assigned to: CPU Architecture:Any
Tags: Crash; Error: semaphore wait has lasted > 600 seconds

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[8 Feb 2012 16:27] Evan Schmidt
error log showing activity preceding the crash

Attachment: prod-asap-db1.err.just-before-crash (text/plain), 64.47 KiB.

[8 Feb 2012 16:29] Evan Schmidt
error log with details of activity not including the last INNODB MONITOR OUTPUT

Attachment: prod-asap-db1.err.early-info.gz (application/x-gzip-compressed, text), 215.55 KiB.