Migrating from 1.14 to 1.15.6

[ndelpuppo]

Gitea Version

gitea-1.15.6

Git Version

git-2.29.3

Operating System

centos7

How are you running Gitea?

I am using the binary release downloaded from https://dl.gitea.io/gitea

Database

PostgreSQL

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

No response

Description

Hi All,
I am facing issues while trying to upgrade Gitea from release 1.14 to 1.15.6.
Looking at the logs, it seems a db migration-related problem:

ORM engine initialization attempt #5/10 failed. Error: migrate: do migrate: pq: column "message" of relation "task" already exists

I would like to avoid wiping the database, is there anything I could do to fix this issue?

PLease see attached the log file.
giteamigration.txt

Screenshots

No response

[wxiaoguang]

Please do not re-install on an installed database.

You should use your old app.ini.

To bypass this error, you may either:

1. Use your 1.14 backup database and use your old app.ini to do the upgrade again.
2. Drop the duplicated column and use the old app.ini to continue to migrate.

The old app.ini is a must.

[wxiaoguang]

Duplicate of #17328

[ndelpuppo]

Please do not re-install on an installed database.

You should use your old app.ini.

To bypass this error, you may either:

1. Use your 1.14 backup database and use your old app.ini to do the upgrade again.
2. Drop the duplicated column and use the old app.ini to continue to migrate.

The old app.ini is a must.

Thank you very much for your quick answer, I went for solution (2) and it worked!
Just for information, I was already using the original app.ini file, I simply replaced the gitea executable with the new one.