Upgrade botched and now won't run correctly 5.32 to 6.0

Troubleshooting
1

Summary
Upgraded following instructions, and the way I always have, from docs. Went from 5.32 to 6.0. Upgrade went fine, but when I start mattermost it runs but won’t load any images and kicks out errors:

{"timestamp":"2021-10-29 10:56:56.103 -04:00","level":"info","msg":"error [2021-10-29 10:56:56.103 -04:00] InitializeTemplates failed caller=\"mlog/mlog.go:228\" error=\"pq: character with byte sequence 0xf0 0x9f 0x99 0x8c in encoding \"UTF8\" has no equivalent in encoding \"LATIN1\"\"\n","caller":"io/io.go:425","plugin_id":"focalboard","source":"plugin_stdout"}
{"timestamp":"2021-10-29 10:56:56.117 -04:00","level":"error","msg":"Failed to install prepackaged plugin","caller":"app/plugin.go:887","path":"/opt/mattermost/prepackaged_plugins/focalboard-v0.9.3-linux-amd64.tar.gz","error":"Failed to install extracted prepackaged plugin /opt/mattermost/prepackaged_plugins/focalboard-v0.9.3-linux-amd64.tar.gz: installExtractedPlugin: Unable to restart plugin on upgrade., error initializing the DB: pq: character with byte sequence 0xf0 0x9f 0x99 0x8c in encoding \"UTF8\" has no equivalent in encoding \"LATIN1\""}
{"timestamp":"2021-10-29 10:56:56.242 -04:00","level":"info","msg":"info [2021-10-29 10:56:56.242 -04:00] connectDatabase caller=\"mlog/mlog.go:218\" dbType=postgres\n","caller":"io/io.go:425","plugin_id":"focalboard","source":"plugin_stdout"}
{"timestamp":"2021-10-29 10:56:56.253 -04:00","level":"info","msg":"debug [2021-10-29 10:56:56.253 -04:00] importInitialTemplates caller=\"mlog/mlog.go:213\"\n","caller":"io/io.go:425","plugin_id":"focalboard","source":"plugin_stdout"}
{"timestamp":"2021-10-29 10:56:56.255 -04:00","level":"info","msg":"debug [2021-10-29 10:56:56.254 -04:00] Inserting blocks caller=\"mlog/mlog.go:213\" block_count=36\n","caller":"io/io.go:425","plugin_id":"focalboard","source":"plugin_stdout"}
{"timestamp":"2021-10-29 10:56:56.258 -04:00","level":"info","msg":"error [2021-10-29 10:56:56.258 -04:00] InitializeTemplates failed caller=\"mlog/mlog.go:228\" error=\"pq: character with byte sequence 0xf0 0x9f 0x99 0x8c in encoding \"UTF8\" has no equivalent in encoding \"LATIN1\"\"\n","caller":"io/io.go:425","plugin_id":"focalboard","source":"plugin_stdout"}
{"timestamp":"2021-10-29 10:56:56.260 -04:00","level":"error","msg":"Unable to activate plugin","caller":"app/plugin.go:146","plugin_id":"focalboard","error":"error initializing the DB: pq: character with byte sequence 0xf0 0x9f 0x99 0x8c in encoding \"UTF8\" has no equivalent in encoding \"LATIN1\""}
{"timestamp":"2021-10-29 10:56:56.310 -04:00","level":"info","msg":"Starting Server...","caller":"app/server.go:1181"}
{"timestamp":"2021-10-29 10:56:56.310 -04:00","level":"info","msg":"Server is listening on [::]:443","caller":"app/server.go:1254","address":"[::]:443"}
2

I got it to run by going from 32 to 37, then to 39, then finally to 6.0. It now runs, images are there, that’s working, but I still cannot get the boards to work. It doesn’t show up in the dropdown of apps, playbooks is there, but not boards. This is the error for boards in the logs:

{"timestamp":"2021-10-29 11:57:24.417 -04:00","level":"info","msg":"error [2021-10-29 11:57:24.416 -04:00] InitializeTemplates failed caller=\"mlog/mlog.go:228\" error=\"pq: character with byte sequence 0xf0 0x9f 0x99 0x8c in encoding \"UTF8\" has no equivalent in encoding \"LATIN1\"\"\n","caller":"io/io.go:425","plugin_id":"focalboard","source":"plugin_stdout"}
{"timestamp":"2021-10-29 11:57:24.431 -04:00","level":"error","msg":"Unable to restart plugin on upgrade.","caller":"web/context.go:105","path":"/api/v4/plugins/marketplace","request_id":"k7rmjnshbbnbmrrmot7hegxdxa","ip_addr":"209.143.44.195","user_id":"acxhxsnkotbfux93gca6s4ubcr","method":"POST","err_where":"installExtractedPlugin","http_code":500,"err_details":"error initializing the DB: pq: character with byte sequence 0xf0 0x9f 0x99 0x8c in encoding \"UTF8\" has no equivalent in encoding \"LATIN1\""}
1 Like