3618
MySQLERRORNotableResource ManagementHIGH confidence

Resource group not found (variant 3)

Production Risk

Medium — Thread assignment fails; queries run in the default resource group.

How to reproduce
trigger — this will error
trigger — this will error
SET RESOURCE GROUP nonexistent_group;

expected output

ERROR 3618 (HY000): Resource group 'nonexistent_group' not found.

Fix

Create the resource group

Create the resource group
CREATE RESOURCE GROUP my_group TYPE = USER VCPU = 0-3 THREAD_PRIORITY = 10;

Why this works

Creates the resource group before it is referenced.

What not to do

Version notes

Sources
Official documentation ↗

MySQL 8.0 — 3618 ER_RESOURCE_GROUP_NOT_FOUND3

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors