Error
Error Code:
3073
MySQL Error 3073: Coordinate Dimension Mismatch
Description
This error occurs when a spatial function or operation in MySQL receives a geometry object with an unexpected number of coordinate dimensions. For example, a function might expect 2D (X, Y) data but receives 3D (X, Y, Z) or 4D (X, Y, Z, M) data, or vice-versa. It indicates an inconsistency between the provided spatial data's dimensionality and the requirement of the specific spatial function being used.
Error Message
Unsupported number of coordinate dimensions in function %s: Found %u, expected %u
Known Causes
3 known causesIncorrect Spatial Function Usage
A spatial function was called with a geometry object that has a different number of dimensions (e.g., 2D, 3D, 4D) than the function expects.
Geometry Column Dimension Mismatch
Attempting to insert or update spatial data into a geometry column defined for a specific dimensionality (e.g., GEOMETRY(POINT, 2D)) with data of a different dimensionality.
Data Generation or Conversion Error
Spatial data generated by an an external application or converted from another format may have an unexpected number of dimensions when used in MySQL.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service