Mattermost Peer-to-Peer Forum

Mattermost not reachable after upgrade to 5.4.0

#1

Summary

Mattermost is not reachable after upgrade to 5.4.0, log fills with error “Failed to create index Error 1214: The used table type doesn’t support FULLTEXT indexes”

Steps to reproduce

Upgrade from version 5.3.1 to 5.4.0 (tried twice)

Expected behavior

Mattermost should work after upgrade

Observed behavior

After upgrade from version 5.3.1 to 5.4.0 mattermost is not reachable. “status mattermost” indicates that it’s running, but nginx reports a 503 error. Logfile fills with the following lines:

{"level":"info","ts":1539764926.9835474,"caller":"utils/i18n.go:78","msg":"Loaded system translations for 'en' from '/var/www/mm.intercorp.de/mattermost/i18n/en.json'"}
{"level":"info","ts":1539764926.9836452,"caller":"app/app.go:204","msg":"Server is initializing..."}
{"level":"info","ts":1539764926.9850402,"caller":"sqlstore/supplier.go:209","msg":"Pinging SQL master database"}	 
{"level":"info","ts":1539764926.9858572,"caller":"sqlstore/channel_store_experimental.go:47","msg":"Enabling experimental public channels materialization"}
{"level":"error","ts":1539764926.9981923,"caller":"sqlstore/supplier.go:751","msg":"Failed to create index Error 1214: The used table type doesn't support FULLTEXT indexes"}

System is Ubuntu 14.04 LTS with MySQL 5.5.61, PHP 5.5.9 and nginx 1.4.6

kind regards
Stephan

#2

Could solve it by changing the storage engine of table “PublicChannels” from innodb to myisam. innodb is the default engine, but doesn’t support fulltext indexes in version 5.5.9
After that, update was successful

1 Like
#3

Yep, that worked for me, too. Here is the SQL command:

ALTER TABLE `PublicChannels` ENGINE = MyISAM;