Error upgrading from 5.32 to 6.0.2

This issue has been tracked since 2021-10-27.


I have mattermost server on debian 9 and mariadb 10.1.48

When I try to upgrade from 5.32 to 6.0.2 I get this error in the logs.

Oct 27 15:54:05  sshd[30967]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=xxxxxxxxx  user=root
Oct 27 15:54:05  mattermost[30971]: {"timestamp":"2021-10-27 15:54:05.446 Z","level":"info","msg":"Server is initializing...","caller":"app/server.go:265","go_version":"go1.16.7"}
Oct 27 15:54:05  mattermost[30971]: {"timestamp":"2021-10-27 15:54:05.446 Z","level":"info","msg":"Starting websocket hubs","caller":"app/web_hub.go:93","number_of_hubs":2}
Oct 27 15:54:05  mattermost[30971]: {"timestamp":"2021-10-27 15:54:05.447 Z","level":"info","msg":"Loaded system translations","caller":"i18n/i18n.go:93","for locale":"es","from locale":"/var/www/vhosts/xxxxxx/mattermost/i18n/es.json"}
Oct 27 15:54:05  mattermost[30971]: {"timestamp":"2021-10-27 15:54:05.462 Z","level":"info","msg":"Pinging SQL","caller":"sqlstore/store.go:253","database":"master"}
Oct 27 15:54:05  mattermost[30971]: {"timestamp":"2021-10-27 15:54:05.490 Z","level":"info","msg":"Pinging SQL","caller":"sqlstore/store.go:253","database":"migrations"}
Oct 27 15:54:05  mattermost[30971]: {"timestamp":"2021-10-27 15:54:05.500 Z","level":"fatal","msg":"Error creating database tables.","caller":"sqlstore/store.go:200","error":"Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json, `LastUpdateAt` bigint, `SchemeUser` tinyint, `SchemeAdmin` tinyint, `Schem' at line 1"}
Oct 27 15:54:05  systemd[1]: [email protected]: Main process exited, code=exited, status=1/FAILURE


joseant wrote this answer on 2021-10-28

I solved it.
the problem was that the mariadb version was very old, I have updated it to version 10.5 and it already works

More Details About Repo
Owner Name mattermost
Repo Name mattermost-server
Full Name mattermost/mattermost-server
Language Go
Created Date 2015-06-15
Updated Date 2022-06-24
Star Count 23270
Watcher Count 544
Fork Count 5540
Issue Count 696


Issue Title Created Date Updated Date