[MDEV-10067] Replication thread sporadically hanging on 'Table lock' state Created: 2016-05-14 Updated: 2022-11-10 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Locking, Replication |
| Affects Version/s: | 10.0.22 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major |
| Reporter: | Michaël de groot | Assignee: | Angelique Sklavounos (Inactive) |
| Resolution: | Unresolved | Votes: | 4 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Sprint: | 10.2.1-3, 10.2.1-4, 10.2.1-5, 10.0.26 | ||||||||||||||||
| Description |
|
From support issue. A customer sporadically experiences an issue where the replication thread gets in state 'Table lock'. Other threads trying to access this table will get into the 'Waiting for table level lock' or 'Waiting for table lock' state. This lock seams to last indefinitely. The setup is quite complicated, the same setup as described in the related issues: Master A < - > Master B < - > Master C The table lock issue occured on master B. Master A receives most write traffic. The SHOW OPEN TABLES command shows there is 1 table open: Database: customer_project The processlist shows the SQL thread in 'Table lock' state: Sometimes the thread state is 'Waiting for table level lock' or it could be that the thread state changes from 'Waiting for table level lock' to 'Table lock' after it has been killed. All tables are InnoDB. If a thread is waiting for a MDL the thread state is different. Hopefully the next time we can generate a coredump. Adding the issue for now in case other people experience it as well. I don't expect this (for now) to give you enough information to work on the issue. This issue occurs independently or possible before the related issues |
| Comments |
| Comment by Matt Neth [ 2017-06-22 ] |
|
I uploaded MDEV10067-6-22-tablelock-M3.tar.gz to the askmonty FTP private directory. This issue usually happens for us around the same time as |