Index is missing in sql scripts for migration from 7.6 to 7.7

Because we are using liquibase as DB versioning tool, i took the postgresql upgrade script from camunda-sql-scripts-7.7.0.jar and created a changeset. After deploying everything was fine, but when using delete scripts from the engine 7.7 jar tables were not dropped because of the following missing index in the upgrade script:

create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);

After adding it to my liquibase-script, everything worked as designed.
This is only to infrom you.

Sönke

Hi @son,

Thanks for the information, but the index isn’t missing. Actually when you upgrade from 7.6 to 7.7, or more in general, for every minor version migration, you also have to execute all the patch scripts available for the version you are migrating too. This is stated in the migration documentation in more details.
You can find your missing index here.

Cheers,
Christian