Bug #96042 | metadata lock waiting | ||
---|---|---|---|
Submitted: | 1 Jul 2019 8:00 | Modified: | 1 Jul 2019 13:07 |
Reporter: | chunyang xu | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.7.18 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | Metadata lock, rollback |
[1 Jul 2019 8:00]
chunyang xu
[1 Jul 2019 13:07]
MySQL Verification Team
Hi Mr. Xu, Thank you for your bug report. However, this is not a bug. This is exactly why MDL were invented and implemented in the SQL layer. Those were invented so that DDL operations would prevent InnoDB SE from changing data, while DDL is in progress. The only thing that you can do is to make 100 % sure that lock_wait_timeout (which refers to MDL) is much larger then innodb_lock_wait_timeout (which is InnoDB SE specific), That is all that you can do. This is all fully described in our Reference Manual.