[MDEV-25048] semaphore has too many locks - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Incomplete
Affects Version/s: 10.3.27
Fix Version/s: N/A
Component/s: Storage Engine - InnoDB
Labels:
Environment:
Debian 9.13
10.3.27-MariaDB

Description

The server is performing a heavy migration task and the task of recalculating data, parallel and in unrelated tables. Every 30 min we have problems with semaphores.
DML (update/delete/insert) queries accumulate in queue
In the attachment, a fragment of the log.
If you need something else we provide.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

long wait semaphore.txt
2021-03-04 10:45
102 kB
Streltsov
master202103071443.log
2021-03-09 15:48
199 kB
Streltsov

Issue Links

relates to

MDEV-24294 MariaDB - Cluster freezes if node hangs

Closed

MDEV-29809 MariaDB: node crash and recovery - Semaphore wait has lasted > 600 seconds. We intentionally crash....

Closed

Activity

People

Assignee:: Unassigned

Reporter:: Streltsov

Votes:: 2 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2021-03-04 10:46

Updated:: 2022-10-17 05:58

Resolved:: 2021-04-20 22:30

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.