Error
Error Code:
3060
MySQL Error 3060: Online GIS Index Alteration Not Supported
Description
This error signifies that MySQL does not support performing certain online DDL operations (e.g., ALTER TABLE ... ALGORITHM=INPLACE) on tables that contain a GIS (Spatial) index. It typically arises when you attempt to modify the table structure in a non-blocking manner, which is prohibited for tables with spatial indexes.
Error Message
Do not support online operation on table with GIS index
Known Causes
3 known causesOnline DDL on GIS-indexed Table
You are executing an ALTER TABLE statement with an online algorithm (like ALGORITHM=INPLACE) on a table that already has one or more GIS (Spatial) indexes.
Implicit Online Algorithm
The ALTER TABLE statement you are using defaults to an online algorithm when not explicitly specified, which is incompatible with tables containing GIS indexes.
Incompatible Operation with Spatial Index
The specific DDL operation being performed is inherently not supported as an online operation when a spatial index is present on the table.
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