In this blog post, let’s learn about the error message “289 Cannot lock table table-name in requested mode.” in Hydra and the description of the error.
Error Message
289 Cannot lock table table-name in requested mode.
Error Details
You cannot add a column of SERIAL data type to an existing table. Such columns may not contain null values, but when you add a column, the database server must put null values in all existing rows. You can add a serial column in three steps. First, add the column with an INTEGER data type. Then update the table with nonnull, unique values in each row of the new column. Finally, use ALTER TABLE MODIFY to change the data type of the column to SERIAL.