Migration 20180306150303-fix-enum is not idempotent

My version of HedgeDoc is: 1.8.2, 1.7.2 and 1.6.0, plus CodiMD 1.6.0.

What I expected to happen:

After upgrading from hackmdio/hackmd:1.2.0 to quay.io/hedgedoc/hedgedoc:1.8.2 the application runs.

$ diff docker-compose.hackmd.yml docker-compose.yml | grep image
-     image: hackmdio/hackmd:1.2.0
+     image: quay.io/hedgedoc/hedgedoc:1.8.2

What actually happened:

Instead of booting up, a migration fails and startup is interrupted:

With 1.8.2:

2021-06-30T18:49:49.285Z info:  == 20180306150303-fix-enum: migrating =======
2021-06-30T18:49:49.291Z error:         type "enum_Notes_permission" already exists
2021-06-30T18:49:49.291Z error:         Database migration failed. Exiting…

Before

with 1.7.2:
2021/06/30 18:59:48 Waiting for: tcp://database:5432
2021/06/30 18:59:48 Connected to tcp://database:5432

Sequelize CLI [Node: 12.22.1, CLI: 5.5.1, ORM: 5.22.3]

Parsed url postgres://hedgedoc:*****@database:5432/hedgedoc
== 20180306150303-fix-enum: migrating =======

ERROR: type "enum_Notes_permission" already exists> HedgeDoc@1.7.2 start /hedgedoc
> sequelize db:migrate && node app.js


Sequelize CLI [Node: 12.22.1, CLI: 5.5.1, ORM: 5.22.3]

Parsed url postgres://hedgedoc:*****@database:5432/hedgedoc
== 20180306150303-fix-enum: migrating =======

ERROR: type "enum_Notes_permission" already exists

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! HedgeDoc@1.7.2 start: `sequelize db:migrate && node app.js`
npm ERR! Exit status 1
npm ERR! 
npm ERR! Failed at the HedgeDoc@1.7.2 start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
with 1.6.0:
2021/06/30 19:02:24 Waiting for: tcp://database:5432
2021/06/30 19:02:24 Connected to tcp://database:5432

Sequelize CLI [Node: 12.19.1, CLI: 5.5.1, ORM: 5.21.4]

Parsed url postgres://hedgedoc:*****@database:5432/hedgedoc
== 20180306150303-fix-enum: migrating =======

ERROR: type "enum_Notes_permission" already exists


> CodiMD@1.6.0 start /hedgedoc
> sequelize db:migrate && node app.js


Sequelize CLI [Node: 12.19.1, CLI: 5.5.1, ORM: 5.21.4]

Parsed url postgres://hedgedoc:*****@database:5432/hedgedoc
== 20180306150303-fix-enum: migrating =======

ERROR: type "enum_Notes_permission" already exists
npm ERR! code ELIFECYCLEnpm ERR! errno 1
npm ERR! CodiMD@1.6.0 start: `sequelize db:migrate && node app.js`npm ERR! Exit status 1npm ERR! 
npm ERR! Failed at the CodiMD@1.6.0 start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     /hedgedoc/.npm/_logs/2021-06-30T19_02_29_251Z-debug.log

we always get the same error from the database:

ERROR:  type "enum_Notes_permission" already exists
STATEMENT:  ALTER TABLE "Notes" ALTER COLUMN "permission" DROP NOT NULL;ALTER TABLE "Notes" ALTER COLUMN "permission" DROP DEFAULT;CREATE TYPE "public"."enum_Notes_permission" AS ENUM('freely', 'editable', 'limited', 'locked', 'protected', 'private');ALTER TABLE "Notes" ALTER COLUMN "permission" TYPE "public"."enum_Notes_permission" USING ("permission"::"public"."enum_Notes_permission");

I already tried:

Running the application from codimd/server:1.6.0 allows to bypass the non-idempotent migration and run the server either way:

2021/06/30 20:40:24 Waiting for: tcp://database:54322021/06/30 20:40:24 Connected to tcp://database:5432Sequelize CLI [Node: 12.19.0, CLI: 5.5.1, ORM: 5.21.4]

Parsed url postgres://hackmd:*****@database:5432/hackmd
== 20180306150303-fix-enum: migrating =======

ERROR: type "enum_Notes_permission" already exists

Wed, 30 Jun 2021 20:40:29 GMT hsts deprecated The "includeSubdomains" parameter is deprecated. Use "includeSubDomains" (with a capital D) instead. at app.js:85:18
(sequelize) Warning: PostgreSQL does not support TEXT with options. Plain `TEXT` will be used instead. 
>> Check: http://www.postgresql.org/docs/9.4/static/datatype.html
2021-06-30T20:40:29.741Z info:  HTTP Server listening at 0.0.0.0:3000

This has also been filed as