3325
MySQLERRORNotableResource GroupsHIGH confidence
Resource group is busy and cannot be altered or dropped
Production Risk
Low — the group and its threads are unchanged.
How to reproduce
trigger — this will error
trigger — this will error
DROP RESOURCE GROUP rg_active;
expected output
ERROR 3325 (HY000): Resource group 'rg_active' is busy.
Fix
Move threads away first
Move threads away first
SET RESOURCE GROUP USR_default FOR THREAD_ID(<id>); DROP RESOURCE GROUP rg_active;
Why this works
Reassigning threads to another group empties the target group so it can be dropped.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3325 ER_RESOURCE_GROUP_BUSY
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev