What to do when you get errno: 121 "Duplicate key on write or update in liquibase intellij spring project
when getting :
liquibase.exception.DatabaseException: Can't create table `pos`.`#sql-19c_894` (errno: 121 "Duplicate key on write or update") [Failed SQL: ALTER TABLE pos.expenses ADD CONSTRAINT fk_user_id FOREIGN KEY (user_id) REFERENCES pos.users (id)] error in intellij when integrating liquibase in your java spring project
MAKE SURE THAT CONSTRAIN NAME ARE UNIQUE
make each constrain name unique
liquibase.exception.DatabaseException: Can't create table `pos`.`#sql-19c_894` (errno: 121 "Duplicate key on write or update") [Failed SQL: ALTER TABLE pos.expenses ADD CONSTRAINT fk_user_id FOREIGN KEY (user_id) REFERENCES pos.users (id)] error in intellij when integrating liquibase in your java spring project
MAKE SURE THAT CONSTRAIN NAME ARE UNIQUE
make each constrain name unique
Comments
Post a Comment