[MDEV-12413] semaphore wait has lasted > 600 seconds,innodb server is crashed Created: 2017-03-31 Updated: 2020-09-06 Resolved: 2020-09-06 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.0.28 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Jiafu Wang | Assignee: | Marko Mäkelä |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | innodb, need_feedback | ||
| Environment: |
CentOS release 6.6 X64 |
||
| Attachments: |
|
| Description |
|
The Mysql server is crashed and auto restart. |
| Comments |
| Comment by Marko Mäkelä [ 2017-04-04 ] | ||||||
|
Does this occur only with XtraDB, or also with InnoDB? There seem to be conflicting requests on at least two buffer block rw-locks: a B-tree page and an undo log page. Does innochecksum report any errors for any InnoDB data files? | ||||||
| Comment by Jiafu Wang [ 2017-04-05 ] | ||||||
|
Sorry,I don't confirm this error occur with innodb,but it occur with xtradb definitely。 | ||||||
| Comment by sysdljr [ 2017-04-05 ] | ||||||
|
HI, @Jiafu Wang reference link, wish to help | ||||||
| Comment by Marko Mäkelä [ 2017-04-05 ] | ||||||
|
sysdljr, thanks for the link! So, it looks like the Linux kernel in CentOS 6.6 has a bug with futexes that can cause hangs. | ||||||
| Comment by Marko Mäkelä [ 2017-04-05 ] | ||||||
|
Jiafu, by the way, It would greatly help if you could produce a core dump for the hang. You do not need to upload it (after all, it contains the buffer pool, which could be sensitive data), but you should back it up along with the mysqld executable and all *.so files listed by "ldd mysqld". At first, I would only want to see the stack traces of all threads. You can get that as follows:
You can also use the gdb "attach" command to attach to the running mysqld process before the server is aborted. | ||||||
| Comment by Jiafu Wang [ 2017-04-05 ] | ||||||
|
@Marko Mäkelä thanks for your suggestion,and I would dump the core if I could dump it.Actually the mysqld thread would restart automaticly before,so it couldn't be dumped at all. @sysdljr My environments are also Haswell-based Servers with cpu of E5-2630 and I would plan to upgrade my kernel as soon as possible.thanks a lot. | ||||||
| Comment by Marko Mäkelä [ 2020-08-07 ] | ||||||
|
Based on the version number, this cannot be a duplicate of I remember that there were problems with the multi-threaded flushing code in the XtraDB storage engine of MariaDB Server 10.1, but that code is not present in the 10.0 series. The MariaDB Server 10.0 has already reached its end of life, and the 10.1 series will follow soon. Is this hang still reproducible in any version of MariaDB Server? |