Hello,

Am trying to setup rundeck :4.11(with customized docker image) with MySQL azure:8.0.42 as database.

Am struck with the liquibase below error:

Issue:

“Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set core/WorkflowWorkflowStepPrimaryKey.groovy::1653585641550-1::rundeckuser (generated):
     Reason: liquibase.exception.DatabaseException: Incorrect table definition; there can be only one auto column and it must be defined as a key aFailed SQL: (1075) ALTER TABLE poc_rundeck.workflow_workflow_step ADD id BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY]
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:696)”. 

When I tried the same instance on flexible server database with MySQL:8.0.25, it is running without any error.

I have done all the prerequisites mentioned in the official documentation regarding “sql_generate_invisible_primary_key > Change its value to OFF”, sql mode also off. But still getting the same error. (Using MySQL as a database backend)

Do we need to do any further changes or do we have any specific jar files related mysql azure databases. Do we need to do any changes in Dockerfile or code.

Any assistance in this matter, is greatly appreciated.

Thanks in Advance,

Saritha