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 email@example.com/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 firstname.lastname@example.org/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.