3322
MySQLERRORNotableResource GroupsHIGH confidence

Invalid VCPU range specified for resource group

Production Risk

Low — DDL fails; no group is created or modified.

How to reproduce
trigger — this will error
trigger — this will error
CREATE RESOURCE GROUP rg_bad TYPE = USER VCPU = 4-2;

expected output

ERROR 3322 (HY000): Invalid VCPU range for resource group.

Fix

Swap the range bounds

Swap the range bounds
CREATE RESOURCE GROUP rg_ok TYPE = USER VCPU = 2-4 THREAD_PRIORITY = 0;

Why this works

The lower bound must be specified first in a range expression.

What not to do

Sources
Official documentation ↗

MySQL 8.0 — 3322 ER_INVALID_VCPU_RANGE

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

← All MySQL errors