Error when updating from Version 7.1 to 7.8 with Docker

Troubleshooting
1

I tried to update our Mattermost Server running Version 7.1 in a Docker Container.
I pulled the newest changes from the mattermost repo, changed the Version in the .env from 7.1 to 7.8.

Everything seemed finde with one problem: Boards do not function anymore.

Further investigation lead to the following database error:

“2023-09-22 08:34:00.610 UTC [1] LOG: database system is ready to accept connections
2023-09-22 08:34:05.075 UTC [39] ERROR: column “name” does not exist at character 17
2023-09-22 08:34:05.075 UTC [39] STATEMENT: SELECT version, name FROM focalboard_schema_migrations
2023-09-22 08:34:05.194 UTC [41] ERROR: column “name” does not exist at character 17
2023-09-22 08:34:05.194 UTC [41] STATEMENT: SELECT version, name FROM focalboard_schema_migrations
2023-09-22 08:43:53.140 UTC [62] ERROR: duplicate key value violates unique constraint “pluginkeyvaluestore_pkey”
2023-09-22 08:43:53.140 UTC [62] DETAIL: Key (pluginid, pkey)=(com.mattermost.nps, UserLock-shfjshbgf348njkr48) already exists.
2023-09-22 08:43:53.140 UTC [62] STATEMENT: INSERT INTO PluginKeyValueStore (PluginId,PKey,PValue,ExpireAt) VALUES ($1,$2,$3,$4)”

Has anyone an idea how to fix this?

Thank you

2

First of all you should not migrate from 7.1 in one go. I know theoretically Mattermost could apply all migrations in between, but according to the documentation this is not supported.

You should upgrade in this sequence as far as I can see in the documentation to get the the latest version:

  1. Upgrade to Mattermost 7.2
  2. Upgrade to Mattermost 7.4
  3. Upgrade to Mattermost 7.5
  4. Upgrade to Mattermost 7.8
  5. Upgrade to Mattermost 7.9
  6. Upgrade to Mattermost 7.10
  7. Upgrade to Mattermost 8.0
  8. Upgrade to Mattermost 8.1
  9. Upgrade to Mattermost 9.0

Using docker it should be a relatively quick procedure.

1 Like