[MDEV-28757] S3 tables can hang in SELECT - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 10.5.17
Component/s: Storage Engine - S3
Labels:
None

Description

A user reported that when using a S3 table some queries where hanging forever

Attachments

Activity

Ascending order - Click to sort in descending order

Michael Widenius added a comment - 2022-06-06 12:56

After a lot of testing, I discovered if a read of a S3 block from S3 storage failed, then the page cache didn't signal the waiting tables to abort.
This could cause the reported issue

Michael Widenius added a comment - 2022-06-06 12:56 After a lot of testing, I discovered if a read of a S3 block from S3 storage failed, then the page cache didn't signal the waiting tables to abort. This could cause the reported issue

Michael Widenius added a comment - 2022-06-06 15:04

Fix pushed to 10.5 tree
Addition fixes for better error reporting in cases like this will be pushed to 10.6 shortly.

Michael Widenius added a comment - 2022-06-06 15:04 Fix pushed to 10.5 tree Addition fixes for better error reporting in cases like this will be pushed to 10.6 shortly.

People

Assignee:: Michael Widenius

Reporter:: Michael Widenius

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2022-06-06 12:55

Updated:: 2022-06-10 08:33

Resolved:: 2022-06-06 15:04

Git Integration

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

MariaDB Server