Summary
Unable to activate plugin.
Please tell me ths solution.
Steps to reproduce
1.upload plugins
2.Dice Roller
3.Matterpoll
4.Enables 2 plugins
5.Either one gets an error.(this case is matterpoll-error)
Env
Mattermost 5.10.0(port 80)
MySQL CE 8.0
Windows Server 2016
IIS
Expected behavior
- 1 line of log.
{
"level":"error",
"ts":1557880693.8251514,
"caller":"mlog/log.go:172",
"msg":"Unable to activate plugin",
"plugin_id":"com.github.matterpoll.matterpoll",
"error":"unable to start plugin: com.github.matterpoll.matterpoll: SqlPluginStore.Get: プラグインのキーを取得できませんでした,
plugin_id=com.github.matterpoll.matterpoll,
key=version,
err=Error 1054: Unknown column 'ExpireAt' in 'where clause'",
"errorVerbose":"SqlPluginStore.Get: プラグインのキーを取得できませんでした,
plugin_id=com.github.matterpoll.matterpoll,
key=version,
err=Error 1054: Unknown column 'ExpireAt' in 'where clause'
unable to start plugin: com.github.matterpoll.matterpoll
github.com/mattermost/mattermost-server/plugin.(*Environment).Activate
/go/src/github.com/mattermost/mattermost-server/plugin/environment.go:216
github.com/mattermost/mattermost-server/app.(*App).SyncPluginsActiveState
/go/src/github.com/mattermost/mattermost-server/app/plugin.go:95
github.com/mattermost/mattermost-server/app.(*App).InitPlugins.func2
/go/src/github.com/mattermost/mattermost-server/app/plugin.go:172
github.com/mattermost/mattermost-server/config.(*emitter).invokeConfigListeners.func1
/go/src/github.com/mattermost/mattermost-server/config/emitter.go:35
sync.(*Map).Range
/usr/local/go/src/sync/map.go:333
github.com/mattermost/mattermost-server/config.(*emitter).invokeConfigListeners
/go/src/github.com/mattermost/mattermost-server/config/emitter.go:33
github.com/mattermost/mattermost-server/config.(*commonStore).set
/go/src/github.com/mattermost/mattermost-server/config/common.go:80
github.com/mattermost/mattermost-server/config.(*FileStore).Set
/go/src/github.com/mattermost/mattermost-server/config/file.go:97
github.com/mattermost/mattermost-server/app.(*Server).UpdateConfig
/go/src/github.com/mattermost/mattermost-server/app/config.go:53
github.com/mattermost/mattermost-server/app.(*App).UpdateConfig
/go/src/github.com/mattermost/mattermost-server/app/config.go:59
github.com/mattermost/mattermost-server/app.(*App).EnablePlugin
/go/src/github.com/mattermost/mattermost-server/app/plugin.go:245
github.com/mattermost/mattermost-server/api4.enablePlugin
/go/src/github.com/mattermost/mattermost-server/api4/plugin.go:187
github.com/mattermost/mattermost-server/web.Handler.ServeHTTP
/go/src/github.com/mattermost/mattermost-server/web/handlers.go:167
github.com/mattermost/mattermost-server/vendor/github.com/gorilla/mux.(*Router).ServeHTTP
/go/src/github.com/mattermost/mattermost-server/vendor/github.com/gorilla/mux/mux.go:162
github.com/mattermost/mattermost-server/app.(*RateLimiter).RateLimitHandler.func1
/go/src/github.com/mattermost/mattermost-server/app/ratelimit.go:107
net/http.HandlerFunc.ServeHTTP
/usr/local/go/src/net/http/server.go:1995
net/http.serverHandler.ServeHTTP
/usr/local/go/src/net/http/server.go:2774
net/http.(*conn).serve
/usr/local/go/src/net/http/server.go:1878
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1337"
}
- logs
{"level":"debug","ts":1557880892.7104774,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880892.7105482,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880892.7717557,"caller":"plugin/hclog_adapter.go:32","msg":"using plugin","plugin_id":"com.github.matterpoll.matterpoll","wrapped_extras":"version1"}
{"level":"debug","ts":1557880892.7718081,"caller":"plugin/hclog_adapter.go:32","msg":"plugin address","plugin_id":"com.github.matterpoll.matterpoll","wrapped_extras":"address/tmp/plugin480970980networkunixtimestamp2019-05-15T00:41:32.771Z"}
{"level":"error","ts":1557880892.7796729,"caller":"app/plugin_key_value_store.go:54","msg":"Failed to query plugin key value","plugin_id":"com.github.matterpoll.matterpoll","key":"version","error":"SqlPluginStore.Get: プラグインのキーを取得できませんでした, plugin_id=com.github.matterpoll.matterpoll, key=version, err=Error 1054: Unknown column 'ExpireAt' in 'where clause'"}
{"level":"debug","ts":1557880892.781468,"caller":"plugin/hclog_adapter.go:32","msg":"plugin process exited","plugin_id":"com.github.matterpoll.matterpoll","wrapped_extras":"path/mattermost/plugins/com.github.matterpoll.matterpoll/server/dist/plugin-linux-amd64pid11693"}
{"level":"error","ts":1557880892.7815397,"caller":"mlog/log.go:172","msg":"Unable to activate plugin","plugin_id":"com.github.matterpoll.matterpoll","error":"unable to start plugin: com.github.matterpoll.matterpoll: SqlPluginStore.Get: プラグインのキーを取得できませんでした, plugin_id=com.github.matterpoll.matterpoll, key=version, err=Error 1054: Unknown column 'ExpireAt' in 'where clause'","errorVerbose":"SqlPluginStore.Get: プラグインのキーを取得できませんでした, plugin_id=com.github.matterpoll.matterpoll, key=version, err=Error 1054: Unknown column 'ExpireAt' in 'where clause'\nunable to start plugin: com.github.matterpoll.matterpoll\ngithub.com/mattermost/mattermost-server/plugin.(*Environment).Activate\n\t/go/src/github.com/mattermost/mattermost-server/plugin/environment.go:216\ngithub.com/mattermost/mattermost-server/app.(*App).SyncPluginsActiveState\n\t/go/src/github.com/mattermost/mattermost-server/app/plugin.go:95\ngithub.com/mattermost/mattermost-server/app.(*App).InitPlugins.func2\n\t/go/src/github.com/mattermost/mattermost-server/app/plugin.go:172\ngithub.com/mattermost/mattermost-server/config.(*emitter).invokeConfigListeners.func1\n\t/go/src/github.com/mattermost/mattermost-server/config/emitter.go:35\nsync.(*Map).Range\n\t/usr/local/go/src/sync/map.go:333\ngithub.com/mattermost/mattermost-server/config.(*emitter).invokeConfigListeners\n\t/go/src/github.com/mattermost/mattermost-server/config/emitter.go:33\ngithub.com/mattermost/mattermost-server/config.(*commonStore).set\n\t/go/src/github.com/mattermost/mattermost-server/config/common.go:80\ngithub.com/mattermost/mattermost-server/config.(*FileStore).Set\n\t/go/src/github.com/mattermost/mattermost-server/config/file.go:97\ngithub.com/mattermost/mattermost-server/app.(*Server).UpdateConfig\n\t/go/src/github.com/mattermost/mattermost-server/app/config.go:53\ngithub.com/mattermost/mattermost-server/app.(*App).UpdateConfig\n\t/go/src/github.com/mattermost/mattermost-server/app/config.go:59\ngithub.com/mattermost/mattermost-server/app.(*App).EnablePlugin\n\t/go/src/github.com/mattermost/mattermost-server/app/plugin.go:245\ngithub.com/mattermost/mattermost-server/api4.enablePlugin\n\t/go/src/github.com/mattermost/mattermost-server/api4/plugin.go:187\ngithub.com/mattermost/mattermost-server/web.Handler.ServeHTTP\n\t/go/src/github.com/mattermost/mattermost-server/web/handlers.go:167\ngithub.com/mattermost/mattermost-server/vendor/github.com/gorilla/mux.(*Router).ServeHTTP\n\t/go/src/github.com/mattermost/mattermost-server/vendor/github.com/gorilla/mux/mux.go:162\ngithub.com/mattermost/mattermost-server/app.(*RateLimiter).RateLimitHandler.func1\n\t/go/src/github.com/mattermost/mattermost-server/app/ratelimit.go:107\nnet/http.HandlerFunc.ServeHTTP\n\t/usr/local/go/src/net/http/server.go:1995\nnet/http.serverHandler.ServeHTTP\n\t/usr/local/go/src/net/http/server.go:2774\nnet/http.(*conn).serve\n\t/usr/local/go/src/net/http/server.go:1878\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1337"}
{"level":"debug","ts":1557880892.7993038,"caller":"jobs/schedulers.go:185","msg":"Schedulers received config change."}
{"level":"debug","ts":1557880892.801845,"caller":"jobs/schedulers.go:167","msg":"Next run time for scheduler MigrationsScheduler: <nil>"}
{"level":"debug","ts":1557880892.8042414,"caller":"jobs/schedulers.go:167","msg":"Next run time for scheduler PluginsScheduler: 2019-05-15 00:42:32.804232 +0000 UTC m=+44444.352444601"}
{"level":"debug","ts":1557880892.8042796,"caller":"jobs/workers.go:108","msg":"Workers received config change."}
{"level":"debug","ts":1557880892.8344994,"caller":"jobs/workers.go:108","msg":"Workers received config change."}
{"level":"debug","ts":1557880892.8345308,"caller":"jobs/schedulers.go:185","msg":"Schedulers received config change."}
{"level":"debug","ts":1557880892.8378177,"caller":"jobs/schedulers.go:167","msg":"Next run time for scheduler MigrationsScheduler: <nil>"}
{"level":"debug","ts":1557880892.8398943,"caller":"jobs/schedulers.go:167","msg":"Next run time for scheduler PluginsScheduler: 2019-05-15 00:42:32.8398851 +0000 UTC m=+44444.388097701"}
{"level":"debug","ts":1557880894.6465302,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880894.646682,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880896.4069977,"caller":"web/handlers.go:58","msg":"GET - /api/v4/logs"}
{"level":"debug","ts":1557880897.4758525,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880897.4760103,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880898.1915643,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880898.1920583,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880900.96416,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880900.9643154,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880902.1423597,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880902.1425424,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880904.0742428,"caller":"web/handlers.go:58","msg":"POST - /api/v4/channels/members/me/view"}
{"level":"debug","ts":1557880904.0744326,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880904.136692,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/a3cbsc7xp3883rz3snwja99bfh/channels"}
{"level":"debug","ts":1557880904.1375167,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/a3cbsc7xp3883rz3snwja99bfh/channels/members"}
{"level":"debug","ts":1557880908.7468667,"caller":"web/handlers.go:58","msg":"GET - /"}
{"level":"debug","ts":1557880908.9178472,"caller":"wsapi/websocket_handler.go:26","msg":"websocket: user_typing"}
{"level":"debug","ts":1557880914.1557493,"caller":"wsapi/websocket_handler.go:26","msg":"websocket: user_typing"}
{"level":"debug","ts":1557880915.672305,"caller":"web/handlers.go:58","msg":"POST - /api/v4/posts"}
{"level":"debug","ts":1557880915.6723874,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880917.1122391,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880917.1141057,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880918.5658572,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/yzasxws3hjdk5fr5h3jien3zwh/members/me"}
{"level":"debug","ts":1557880918.6364174,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/yzasxws3hjdk5fr5h3jien3zwh/posts"}
{"level":"debug","ts":1557880918.6571538,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/yzasxws3hjdk5fr5h3jien3zwh/stats"}
{"level":"debug","ts":1557880918.6581662,"caller":"web/handlers.go:58","msg":"POST - /api/v4/channels/members/me/view"}
{"level":"debug","ts":1557880918.6583974,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880926.9913807,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/73upp1q4bjnsbq89aybatfktoh/members/me"}
{"level":"debug","ts":1557880927.0224223,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/73upp1q4bjnsbq89aybatfktoh/posts"}
{"level":"debug","ts":1557880927.0572467,"caller":"web/handlers.go:58","msg":"POST - /api/v4/channels/members/me/view"}
{"level":"debug","ts":1557880927.0573118,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880927.0723345,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/73upp1q4bjnsbq89aybatfktoh/stats"}
{"level":"debug","ts":1557880927.5106926,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/rm66do1rd7raik45tyb7gc56pr/image"}
{"level":"debug","ts":1557880929.1044288,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880929.1045926,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880930.8757663,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880930.875867,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880938.980764,"caller":"web/handlers.go:58","msg":"GET - /"}
{"level":"debug","ts":1557880942.1368809,"caller":"web/handlers.go:58","msg":"GET - /"}
{"level":"debug","ts":1557880944.5835564,"caller":"web/handlers.go:58","msg":"GET - /api/v4/config/client"}
{"level":"debug","ts":1557880944.7121093,"caller":"web/handlers.go:58","msg":"GET - /api/v4/license/client"}
{"level":"debug","ts":1557880944.7306986,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me"}
{"level":"debug","ts":1557880944.7436163,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/preferences"}
{"level":"debug","ts":1557880944.8330715,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams"}
{"level":"debug","ts":1557880944.8345165,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/members"}
{"level":"debug","ts":1557880944.8348205,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/unread"}
{"level":"debug","ts":1557880945.1387498,"caller":"web/handlers.go:58","msg":"GET - /api/v4/teams/name/zep2/channels/name/shidaren"}
{"level":"debug","ts":1557880945.2357802,"caller":"web/handlers.go:58","msg":"GET - /api/v4/plugins/webapp"}
{"level":"debug","ts":1557880945.3978062,"caller":"web/handlers.go:58","msg":"POST - /api/v4/users/status/ids"}
{"level":"debug","ts":1557880945.3979547,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}
{"level":"debug","ts":1557880945.5273077,"caller":"web/handlers.go:58","msg":"GET - /api/v4/websocket"}
{"level":"debug","ts":1557880945.551377,"caller":"web/handlers.go:58","msg":"POST - /api/v4/roles/names"}
{"level":"debug","ts":1557880945.7979527,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/unread"}
{"level":"debug","ts":1557880945.9570692,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/a3cbsc7xp3883rz3snwja99bfh/channels"}
{"level":"debug","ts":1557880946.0258617,"caller":"web/handlers.go:58","msg":"GET - /api/v4/users/me/teams/a3cbsc7xp3883rz3snwja99bfh/channels/members"}
{"level":"debug","ts":1557880946.0769048,"caller":"web/handlers.go:58","msg":"POST - /api/v4/roles/names"}
{"level":"debug","ts":1557880946.2844827,"caller":"web/handlers.go:58","msg":"GET - /api/v4/channels/t37rbfkx77nxpk63unk6axpkda/members/me"}
{"level":"debug","ts":1557880946.3619938,"caller":"web/handlers.go:58","msg":"GET - /api/v4/teams"}
{"level":"debug","ts":1557880947.0418048,"caller":"web/handlers.go:58","msg":"POST - /api/v4/channels/members/me/view"}
{"level":"debug","ts":1557880947.0419965,"caller":"mlog/log.go:160","msg":"CSRF Header check failed for request - Please upgrade your web application or custom app to set a CSRF Header"}