[MDEV-28741] Disable query cache on Spider tables to avoid cache inconsistency - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Won't Do
Affects Version/s: None
Fix Version/s: N/A
Component/s: Storage Engine - Spider
Labels:
None

Description

If there are multiple (writable) Spider nodes, the content of the query cache of each node would be inconsistent. We simply disable the query cache on Spider tables to avoid inconsistency.

Setting thd->query_cache_is_applicable= 0 in ha_spider::register_query_cache_table() would fix the problem. To see how the function is used, check Query_cache::ask_handler_allowance().

Attachments

Activity

People

Assignee:: Nayuta Yanagisawa (Inactive)

Reporter:: Nayuta Yanagisawa (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2022-06-03 04:50

Updated:: 2022-06-05 07:52

Resolved:: 2022-06-05 07:51

Git Integration

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