Bug #43671 InnoDB hang on rseg->mutex in trx0trx.c:1846 and trx0roll.c:934
Submitted: 16 Mar 10:56 Modified: 20 Aug 19:14
Reporter: Axel Schwenke
Status: Open
Category:Server: InnoDB Severity:S2 (Serious)
Version:5.0.56sp1 OS:Linux (x86_64)
Assigned to: Target Version:
Tags: Semaphore

[16 Mar 10:56] Axel Schwenke 
Description:
InnoDB crashes the server after a long semaphore wait. The mutex is rseg->mutex. There
are 3 treads waiting:

1x COMMIT at trx0trx.c line 1846
2x ROLLBACK at trx0roll.c line 934

There are several other active transactions, both select and insert.

Might be related to bug #29560, bug #19081, bug #20358.

How to repeat:
Not repeated. Its the first report for InnoDB hanging on this mutex. Reporting this as
bug anyway, maybe somebody else gets the same.
[17 Mar 10:09] Sveta Smirnova 
From error log:

InnoDB: ###### Diagnostic info printed to the standard error stream
InnoDB: Error: semaphore wait has lasted > 600 seconds
InnoDB: We intentionally crash the server, because it appears to be hung.
090313  7:51:08InnoDB: Assertion failure in thread 1147169120 in file srv0srv.c line 2095
[31 Mar 15:49] Miguel Solorzano 
Bug: http://bugs.mysql.com/bug.php?id=34459 has similar error log output.