3400
MariaDBERRORNotableInnoDB / TablespacesHIGH confidence
Cannot change tablespace access mode
Production Risk
Medium — DDL fails; tablespace access mode is unchanged.
How to reproduce
trigger — this will error
trigger — this will error
ALTER TABLESPACE ts1 ACCESS MODE READ ONLY;
expected output
ERROR 3400 (HY000): Cannot change tablespace access mode.
Fix
Ensure no active transactions before access mode change
Ensure no active transactions before access mode change
SELECT * FROM information_schema.INNODB_TRX; ALTER TABLESPACE ts1 ACCESS MODE READ ONLY;
Why this works
Waiting for transactions to complete avoids access mode change conflicts.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3400 ER_CANNOT_CHANGE_TABLESPACE_ACCESS
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev