[MDEV-22966] Server crashes or hangs with SET ROLE when started with skip-grant-tables - Jira

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
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9
Component/s: Authentication and Privilege System
Labels:
- roles

Description

If the server is started with --skip-grant-tables, then attempting to set a role either results in the server hanging or crashing, depending on affected version.

set role x;

ERROR 2013 (HY000): Lost connection to MySQL server during query

Attachments

Activity

Transition	Time In Source Status	Execution Times

Alice Sherepa made transition - 2020-06-22 09:10

Open

Confirmed

2d 11h 43m

Sergei Golubchik made transition - 2021-01-09 16:00

Confirmed

In Progress

201d 6h 49m

Sergei Golubchik made transition - 2021-01-09 16:00

In Progress

Stalled

Sergei Golubchik made transition - 2021-01-12 09:23

Stalled

Closed

2d 17h 23m

People

Assignee:: Sergei Golubchik

Reporter:: Ian Gilfillan

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2020-06-19 21:26

Updated:: 2021-01-12 09:23

Resolved:: 2021-01-12 09:23

Git Integration

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

MariaDB Server