Error
Error Code:
1801
MariaDB Error 1801: Unknown ALTER LOCK Type
Description
This error indicates that an `ALTER TABLE` statement attempted to use a `LOCK` type that MariaDB does not recognize or support. It typically occurs when specifying concurrency control for DDL operations with an incorrect, misspelled, or unsupported keyword in the `LOCK` clause.
Error Message
Unknown LOCK type '%s'
Known Causes
3 known causesTypographical Error in LOCK Clause
A simple misspelling of a valid `LOCK` keyword (e.g., 'SHARDED' instead of 'SHARED') will cause MariaDB to not recognize the type.
Using an Invalid or Unsupported LOCK Type
Attempting to use a `LOCK` type keyword that is not recognized by your specific MariaDB version or is derived from another database system's syntax.
Incorrect Understanding of LOCK Syntax
Applying a non-existent or custom `LOCK` type, based on a misunderstanding of MariaDB's `ALTER TABLE` concurrency control options.
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