In this post, you’ll learn more about the MariaDB Error 1854 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1854 – ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC with the sqlState HY000
Error Description for the MariaDB Error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC
Adding an auto-increment column requires a lock