Focalboard error after upgrade from 7.1 to 7.8

Troubleshooting Upgrade
1

Hi,

we upgraded from Mattermost 7.1.x to 7.8.4 directly → ESR release.
The upgrade worked without any problems and the system was running for ~ 1 week.

After this week we had some problems with the server and we could see some problems with the mattermost db.
After that i had a deeper look into the logs and found some focalboard migration errors.

My hope was that with the next upgrade to 7.8.5 this problem will be solved but …

This is in the error log:

error [2023-05-24 15:43:43.415 Z] Table creation / migration failed error="Error 1054: Unknown column 'dirty' in 'field list' in line 0: SELECT version, dirty FROM `focalboard_schema_migrations` LIMIT 1"
  github.com/mattermost/focalboard/server/services/store/sqlstore.New
      github.com/mattermost/focalboard/server@v0.0.0-20210525112228-f43e4028dbdc/services/store/sqlstore/sqlstore.go:54
  main.(*Plugin).OnActivate
      github.com/mattermost/focalboard/mattermost-plugin/server/plugin.go:103
  github.com/mattermost/mattermost-server/v6/plugin.(*hooksRPCServer).OnActivate
      github.com/mattermost/mattermost-server/v6@v6.0.0-20211022142730-a6cca93ba3c3/plugin/client_rpc.go:319
  reflect.Value.call
      reflect/value.go:476
  reflect.Value.Call
      reflect/value.go:337
  net/rpc.(*service).call
      net/rpc/server.go:377
  runtime.goexit
      runtime/asm_amd64.s:1371

How can I fix this?
I looks like the system is missing only a column but i can not found the table definition to create the column by hand.

Best

Silvio

2

Hi,
I encountered the same error and filed a bug report here: Upgrading leads to error in focalboard plugin: Error 1054: Unknown column 'dirty' in 'field list' in line 0 · Issue #24316 · mattermost/mattermost · GitHub
Best regards,
Nic

2 Likes