# \[solved\] Mattermost server doesn't work after instalation.Failed to create index Error 1071 **URL:** \ **Category:** Troubleshooting\ **Created:** [March 24, 2019, 11:30am UTC](https://forum.mattermost.com/t/solved-mattermost-server-doesnt-work-after-instalation-failed-to-create-index-error-1071/6910 "2019-03-24T11:30:21Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![francocool](https://avatars.discourse-cdn.com/v4/letter/f/54ee81/32.png) [@francocool](https://forum.mattermost.com/u/francocool)\ **Post date:** [March 24, 2019, 11:30am UTC](https://forum.mattermost.com/t/solved-mattermost-server-doesnt-work-after-instalation-failed-to-create-index-error-1071/6910/1 "2019-03-24T11:30:21Z")
After the instalation mattermost can’t start and shows me this errors: ./mattermost {“level”:“info”,“ts”:1553426325.7105906,“caller”:“utils/i18n.go:83”,“msg”:“Loaded system translations for ‘en’ from ‘/opt/mattermost/i18n/en.json’”} {“level”:“info”,“ts”:1553426325.71098,“caller”:“app/server\_app\_adapters.go:58”,“msg”:“Server is initializing…”} {“level”:“info”,“ts”:1553426325.7225804,“caller”:“sqlstore/supplier.go:215”,“msg”:“Pinging SQL master database”} {“level”:“error”,“ts”:1553426325.7914166,“caller”:“sqlstore/supplier.go:807”,“msg”:“Failed to create index Error 1071: Specified key was too long; max key length is 1000 bytes”} Is there any solution? Thanx. CentOS 7.0, MariaDB 10.4, apache. PHPMyAdmin ---
**Author:** ![amy.blais](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/amy.blais/32/7481_2.png) [@amy.blais](https://forum.mattermost.com/u/amy.blais)\ **Post date:** [March 25, 2019, 12:58pm UTC](https://forum.mattermost.com/t/solved-mattermost-server-doesnt-work-after-instalation-failed-to-create-index-error-1071/6910/2 "2019-03-25T12:58:18Z")
Hi @francocool, Which installation guides did you follow? What Mattermost server version did you install? ---
**Author:** ![francocool](https://avatars.discourse-cdn.com/v4/letter/f/54ee81/32.png) [@francocool](https://forum.mattermost.com/u/francocool)\ **Post date:** [March 25, 2019, 1:24pm UTC](https://forum.mattermost.com/t/solved-mattermost-server-doesnt-work-after-instalation-failed-to-create-index-error-1071/6910/3 "2019-03-25T13:24:00Z")
It was russian guide and i just solved the problem. I used MariaDB for previous installations of mattermost servers, but for new releases this does not work. I used the instructions on the official website and everything turned out. Conclusion - do not use MariaDB for mattermost. ---
**Author:** ![jerlich](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/jerlich/32/3767_2.png) [@jerlich](https://forum.mattermost.com/u/jerlich)\ **Post date:** [April 24, 2020, 5:29am UTC](https://forum.mattermost.com/t/solved-mattermost-server-doesnt-work-after-instalation-failed-to-create-index-error-1071/6910/4 "2020-04-24T05:29:29Z")
Is this true? You can’t use MariaDB anymore? I got the same error trying to upgrade from 4… to 5.22 ---
**Author:** ![amy.blais](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/amy.blais/32/7481_2.png) [@amy.blais](https://forum.mattermost.com/u/amy.blais)\ **Post date:** [April 24, 2020, 12:11pm UTC](https://forum.mattermost.com/t/solved-mattermost-server-doesnt-work-after-instalation-failed-to-create-index-error-1071/6910/5 "2020-04-24T12:11:22Z")
When you upgraded to v5.22, did you first upgrade to v5.0 in between? Have you read all the important upgrade notes between v4.0 and v5.22 versions [https://docs.mattermost.com/administration/important-upgrade-notes.html](https://docs.mattermost.com/administration/important-upgrade-notes.html)? ---
**Author:** ![jerlich](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/jerlich/32/3767_2.png) [@jerlich](https://forum.mattermost.com/u/jerlich)\ **Post date:** [April 25, 2020, 4:23am UTC](https://forum.mattermost.com/t/solved-mattermost-server-doesnt-work-after-instalation-failed-to-create-index-error-1071/6910/6 "2020-04-25T04:23:28Z")
I didn’t upgrade to 5.0 first. I did read the “important upgrade notes” but I guess I missed something. ---
**Author:** ![jerlich](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mattermost.com/jerlich/32/3767_2.png) [@jerlich](https://forum.mattermost.com/u/jerlich)\ **Post date:** [April 25, 2020, 1:32pm UTC](https://forum.mattermost.com/t/solved-mattermost-server-doesnt-work-after-instalation-failed-to-create-index-error-1071/6910/7 "2020-04-25T13:32:38Z")
Turns out I was still using MyISAM as my engine for Mattermost tables. After running `alter table ... engine=InnoDB` things now work. Maybe it should say somewhere explicitly that only `InnoDB` is supported in Mattermost 5 (if that is true).