MySQL error with edoras 2.0.6


#1

Hello,

I try to upgrade from edoras 1.6.13 to edoras 2.0.6. If I start my custom code project with edoras 2.0.6 and an empty MySQL database the following error occurs: “Failed to add the foreign key constraint on table ‘act_procdef_info’. Incorrect options in FOREIGN KEY constraint ‘edorasdev_2_x_empty/ACT_FK_INFO_JSON_BA’ (SQL State: HY000 - Error Code: 1825)”. At the same time I can start my project with an empty h2 database without problem. Could you help me solve this problem, please?

The full exception stack trace is attached.

Thank you.

Best regards,
Olga

FaildToAddForeignKeyConstraint_ExceptionStackTrace_edoras2_0_6.zip (3.5 KB)


#2

Hello Olga,

Usually flyway errors are due to local database changes that affect the regular database migration path. What do you have as initial database state?

Regards,
José


#3

Hello José,

I use an empty database for my tests. I create the new schema on mySQL server. Then I start the tomcat with my custom code project. You can see the schema details in the attached screenshot.

Thank you and best regards,
Olga

SchemaDetails


#4

Hello Olga, can you execute the following statement after the exception appears?

SHOW ENGINE innodb STATUS

Thanks and regards,
José.


#5

Hello José,

you can view the result of the statement in the attached file.

Best regards,
Olga

SHOW _ENGINE_innodb_STATUS.zip (2.3 KB)