[MDEV-16865] InnoDB fts_query() ignores KILL - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
Fix Version/s: 10.0.37, 10.1.36, 10.2.17, 10.3.9
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Labels:
- fulltext
- kill

Description

The functions fts_ast_visit() and fts_query() inside InnoDB FULLTEXT INDEX query processing are not checking for THD::killed (trx_is_interrupted()), like anything that potentially takes a long time should do.

We should backport Bug #27155294 MAX_EXECUTION_TIME NOT INTERUPTED WITH FULLTEXT SEARCH USING MECAB PROBLEM from MySQL 5.7.23 to address this.

Attachments

Issue Links

blocks

MDEV-16850 Merge new release of InnoDB 5.7.23 to 10.2

Closed

Activity

Marko Mäkelä added a comment - 2018-08-03 10:47

The fix from upstream contained an error, which slipped into the 10.0.37 release, but will be fixed in MariaDB Server 10.0.38. A wrong pointer was tested for NULL in a clean-up code path, potentially leading to a SIGSEGV if a FULLTEXT INDEX query is killed (or the client disconnects before completion).

Marko Mäkelä added a comment - 2018-08-03 10:47 The fix from upstream contained an error, which slipped into the 10.0.37 release, but will be fixed in MariaDB Server 10.0.38. A wrong pointer was tested for NULL in a clean-up code path, potentially leading to a SIGSEGV if a FULLTEXT INDEX query is killed (or the client disconnects before completion).

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2018-07-31 13:32

Updated:: 2018-08-03 10:48

Resolved:: 2018-08-01 12:19

Git Integration

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