[MDEV-26059] Query in the range optimizer doesn't react to KILL - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
Fix Version/s: 10.4.19, 10.5.10
Component/s: Admin statements
Labels:
None

Description

Customer has been affected by the inability to stop a run away query that was application generated without causing an outage to restart the server when KILL is ineffective. Even hard kill is not always reliable to stop a query/connection in all situations. An option that kills a query in any state that is not writing a DML or DDL would help immensely.

Attachments

Issue Links

is duplicated by

MDEV-23634 Select query hanged the server and leads to OOM in MariaDB 10.4.14

Closed

mentioned in: Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

(33 mentioned in)

Activity

People

Assignee:: Sergei Petrunia

Reporter:: Kyle Joiner (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2021-06-30 21:28

Updated:: 2024-09-05 20:03

Resolved:: 2021-12-06 10:46

Git Integration

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