Mattermostを 5.10.0 から 7.7.1 へバージョンアップした際の備忘録

$ sudo systemctl start mattermost
Job for mattermost.service failed because the control process exited with error code. See "systemctl status mattermost.service" and "journalctl -xe" for details.

$ sudo ./mattermost
{"timestamp":"2023-01-27 13:54:14.119 +09:00","level":"info","msg":"Server is initializing...","caller":"platform/service.go:165","go_version":"go1.18.1"}
{"timestamp":"2023-01-27 13:54:14.119 +09:00","level":"info","msg":"Pinging SQL","caller":"sqlstore/store.go:238","database":"master"}
{"timestamp":"2023-01-27 13:54:14.129 +09:00","level":"info","msg":"Pinging SQL","caller":"sqlstore/store.go:238","database":"master"}
{"timestamp":"2023-01-27 13:54:14.135 +09:00","level":"fatal","msg":"Failed to apply database migrations.","caller":"sqlstore/store.go:169","error":"driver: mysql, message: failed when applying migration, command: apply_migration, originalError: Error 1072: Key column 'SchemeAdmin' doesn't exist in table, query: \n\nCREATE TABLE IF NOT EXISTS GroupChannels (\n    GroupId varchar(26) NOT NULL,\n    AutoAdd tinyint(1),\n    SchemeAdmin tinyint(1) DEFAULT NULL,\n    CreateAt bigint(20) DEFAULT NULL,\n    DeleteAt bigint(20) DEFAULT NULL,\n    UpdateAt bigint(20) DEFAULT NULL,\n    ChannelId varchar(26) NOT NULL,\n    PRIMARY KEY (GroupId, ChannelId),\n    KEY idx_groupchannels_schemeadmin (SchemeAdmin),\n    KEY idx_groupchannels_channelid (ChannelId)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\n\nSET @preparedStatement = (SELECT IF(\n    (\n        SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS\n        WHERE table_name = 'GroupChannels'\n        AND table_schema = DATABASE()\n        AND index_name = 'idx_groupchannels_channelid'\n    ) > 0,\n    'SELECT 1',\n    'CREATE INDEX idx_groupchannels_channelid ON GroupChannels (ChannelId);'\n));\n\nPREPARE createIndexIfNotExists FROM @preparedStatement;\nEXECUTE createIndexIfNotExists;\nDEALLOCATE PREPARE createIndexIfNotExists;\n\nSET @preparedStatement = (SELECT IF(\n    (\n        SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS\n        WHERE table_name = 'GroupChannels'\n        AND table_schema = DATABASE()\n        AND index_name = 'idx_groupchannels_schemeadmin'\n    ) > 0,\n    'SELECT 1',\n    'CREATE INDEX idx_groupchannels_schemeadmin ON GroupChannels(SchemeAdmin);'\n));\n\nPREPARE createIndexIfNotExists FROM @preparedStatement;\nEXECUTE createIndexIfNotExists;\nDEALLOCATE PREPARE createIndexIfNotExists;\n\nSET @preparedStatement = (SELECT IF(\n    (\n        SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS\n        WHERE table_name = 'GroupChannels'\n        AND table_schema = DATABASE()\n        AND column_name = 'SchemeAdmin'\n    ) > 0,\n    'SELECT 1',\n    'ALTER TABLE GroupChannels ADD COLUMN SchemeAdmin tinyint(1);'\n));\n\nPREPARE createColumnIfNotExists FROM @preparedStatement;\nEXECUTE createColumnIfNotExists;\nDEALLOCATE PREPARE createColumnIfNotExists;\n\n"}