3606
MariaDBERRORNotableSpatialHIGH confidence
SRS definition missing mandatory attribute (variant 2)
Production Risk
Low — SRS creation fails; existing spatial data is unaffected.
How to reproduce
trigger — this will error
trigger — this will error
CREATE SPATIAL REFERENCE SYSTEM 99999 NAME 'Incomplete SRS' DEFINITION 'PROJCS["test"]';
expected output
ERROR 3606 (HY000): SRS definition is missing mandatory attribute.
Fix
Use a complete WKT SRS definition
Use a complete WKT SRS definition
SELECT ST_SRS(4326); -- use a built-in SRS
Why this works
Built-in SRID 4326 (WGS 84) is fully defined and safe to use.
What not to do
✕
Version notes
Sources
Official documentation ↗
MySQL 8.0 — 3606 ER_SRS_MISSING_MANDATORY_ATTRIBUTE2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev