Cant see channels

Ilya · September 17, 2020, 5:17pm

Helo.
After upgrade from 5.25 to 5.27 users cant view channels bar on left. How can i fix this issue?

amy.blais · September 17, 2020, 5:51pm

What happens if they click on the filter button on the left side to un-collapse the channels?

Ilya · September 18, 2020, 8:48am

Nothing’s happened

Log

{“level”:“info”,“ts”:1600362226.9226272,“caller”:“app/web_hub.go:83”,“msg”:“Starting websocket hubs”,“number_of_hubs”:4}
{“level”:“info”,“ts”:1600362226.924793,“caller”:“utils/i18n.go:83”,“msg”:“Loaded system translations”,“for locale”:“ru”,“from locale”:"/opt/mattermost/i18n/ru.json"}
{“level”:“info”,“ts”:1600362226.9303873,“caller”:“sqlstore/supplier.go:227”,“msg”:“Pinging SQL”,“database”:“master”}
{“level”:“info”,“ts”:1600362227.8618155,“caller”:“app/license.go:60”,“msg”:“License key valid unlocking enterprise features.”}
{“level”:“info”,“ts”:1600362228.0801926,“caller”:“app/server.go:443”,“msg”:“Current version is 5.27.0 (5.27.0/Mon Sep 14 12:42:44 UTC 2020/bd6149b00455ed615c0552e7f709d33920885ef3/20f9571ef28a0bdaabe36fc7e4d0d5ca5c9bb6f3)”,“current_version”:“5.27.0”,“build_number”:“5.27.0”,“build_date”:“Mon Sep 14 12:42:44 UTC 2020”,“build_hash”:“bd6149b00455ed615c0552e7f709d33920885ef3”,“build_hash_enterprise”:“20f9571ef28a0bdaabe36fc7e4d0d5ca5c9bb6f3”}
{“level”:“info”,“ts”:1600362228.0803382,“caller”:“app/server.go:452”,“msg”:“Enterprise Build”,“enterprise_build”:true}
{“level”:“info”,“ts”:1600362228.0803878,“caller”:“app/server.go:458”,“msg”:“Printing current working”,“directory”:"/opt/mattermost"}
{“level”:“info”,“ts”:1600362228.080418,“caller”:“app/server.go:459”,“msg”:“Loaded config”,“source”:“file:///opt/mattermost/config/config.json”}
{“level”:“info”,“ts”:1600362228.1576183,“caller”:“sqlstore/post_store.go:1597”,“msg”:“Post.Message has size restrictions”,“max_characters”:16383,“max_bytes”:65535}
{“level”:“info”,“ts”:1600362228.1610022,“caller”:“bleveengine/bleve.go:267”,“msg”:“UpdateConf Bleve”}
{“level”:“info”,“ts”:1600362228.4796042,“caller”:“app/server.go:831”,“msg”:“Starting Server…”}
{“level”:“info”,“ts”:1600362228.4801328,“caller”:“app/server.go:908”,“msg”:“Server is listening on [::]:8065”,“address”:"[::]:8065"}
{“level”:“info”,“ts”:1600362228.4801943,“caller”:“commands/server.go:106”,“msg”:“Sending systemd READY notification.”}
{“level”:“info”,“ts”:1600362237.2765875,“caller”:“mlog/log.go:176”,“msg”:“Starting up plugins”}
{“level”:“info”,“ts”:1600362237.2767045,“caller”:“app/plugin.go:215”,“msg”:“Syncing plugins from the file store”}
{“level”:“warn”,“ts”:1600362237.2930806,“caller”:“app/plugin.go:235”,“msg”:“Skipping sync for unmanaged plugin”,“plugin_id”:“rssfeed”}
{“level”:“info”,“ts”:1600362237.3184426,“caller”:“app/plugin.go:275”,“msg”:“Syncing plugin from file store”,“bundle”:“plugins/custom-css-10124.tar.gz”}
{“level”:“info”,“ts”:1600362237.3184602,“caller”:“app/plugin.go:275”,“msg”:“Syncing plugin from file store”,“bundle”:“plugins/com.github.matterpoll.matterpoll.tar.gz”}
{“level”:“info”,“ts”:1600362237.3185112,“caller”:“app/plugin.go:275”,“msg”:“Syncing plugin from file store”,“bundle”:“plugins/topdf.tar.gz”}
{“level”:“info”,“ts”:1600362237.3185363,“caller”:“app/plugin.go:275”,“msg”:“Syncing plugin from file store”,“bundle”:“plugins/zoom.tar.gz”}
{“level”:“info”,“ts”:1600362237.3185575,“caller”:“app/plugin.go:275”,“msg”:“Syncing plugin from file store”,“bundle”:“plugins/com.github.scottleedavis.mattermost-plugin-remind.tar.gz”}
{“level”:“info”,“ts”:1600362237.3185945,“caller”:“app/plugin.go:275”,“msg”:“Syncing plugin from file store”,“bundle”:“plugins/com.mattermost.plugin-todo.tar.gz”}
{“level”:“error”,“ts”:1600362254.2277277,“caller”:“app/plugin.go:806”,“msg”:“Failed to install prepackaged plugin”,“path”:"/opt/mattermost/prepackaged_plugins/mattermost-plugin-nps-v1.0.4-linux-amd64.tar.gz",“error”:“Failed to install extracted prepackaged plugin /opt/mattermost/prepackaged_plugins/mattermost-plugin-nps-v1.0.4-linux-amd64.tar.gz: installExtractedPlugin: Невозможно переместить плагин из временного каталога в конечный пункт назначения. Другой плагин может использовать то же имя каталога., destination already exists”,“errorVerbose”:“installExtractedPlugin: Невозможно переместить плагин из временного каталога в конечный пункт назначения. Другой плагин может использовать то же имя каталога., destination already exists\nFailed to install extracted prepackaged plugin /opt/mattermost/prepackaged_plugins/mattermost-plugin-nps-v1.0.4-linux-amd64.tar.gz\ngithub.com/mattermost/mattermost-server/v5/app.(*App).processPrepackagedPlugin\n\tgithub.com/mattermost/mattermost-server/v5/app/plugin.go:858\ngithub.com/mattermost/mattermost-server/v5/app.(*App).processPrepackagedPlugins.func2\n\tgithub.com/mattermost/mattermost-server/v5/app/plugin.go:804\nruntime.goexit\n\truntime/asm_amd64.s:1373”}
{“level”:“error”,“ts”:1600362254.782256,“caller”:“app/plugin.go:806”,“msg”:“Failed to install prepackaged plugin”,“path”:"/opt/mattermost/prepackaged_plugins/mattermost-plugin-nps-v1.0.3-linux-amd64.tar.gz",“error”:“Failed to install extracted prepackaged plugin /opt/mattermost/prepackaged_plugins/mattermost-plugin-nps-v1.0.3-linux-amd64.tar.gz: installExtractedPlugin: Невозможно переместить плагин из временного каталога в конечный пункт назначения. Другой плагин может использовать то же имя каталога., destination already exists”,“errorVerbose”:“installExtractedPlugin: Невозможно переместить плагин из временного каталога в конечный пункт назначения. Другой плагин может использовать то же имя каталога., destination already exists\nFailed to install extracted prepackaged plugin /opt/mattermost/prepackaged_plugins/mattermost-plugin-nps-v1.0.3-linux-amd64.tar.gz\ngithub.com/mattermost/mattermost-server/v5/app.(*App).processPrepackagedPlugin\n\tgithub.com/mattermost/mattermost-server/v5/app/plugin.go:858\ngithub.com/mattermost/mattermost-server/v5/app.(*App).processPrepackagedPlugins.func2\n\tgithub.com/mattermost/mattermost-server/v5/app/plugin.go:804\nruntime.goexit\n\truntime/asm_amd64.s:1373”}
{“level”:“info”,“ts”:1600362256.49865,“caller”:“mlog/sugar.go:19”,“msg”:“Ensuring Surveybot exists”,“plugin_id”:“com.mattermost.nps”}
{“level”:“info”,“ts”:1600362256.7873962,“caller”:“jobs/workers.go:77”,“msg”:“Starting workers”}
{“level”:“info”,“ts”:1600362256.7951138,“caller”:“jobs/schedulers.go:78”,“msg”:“Starting schedulers.”}
{“level”:“info”,“ts”:1600362256.795734,“caller”:“app/license.go:60”,“msg”:“License key valid unlocking enterprise features.”}
{“level”:“error”,“ts”:1600362508.6761043,“caller”:“mlog/log.go:190”,“msg”:“Unable to connect to AD/LDAP server.”,“path”:"/api/v4/ldap/groups",“request_id”:“h5brisyt7bbxjrwp9hu4r5qery”,“ip_addr”:“192.168.4.68”,“user_id”:“x7n1fe3fdt899deheeztcdxnde”,“method”:“GET”,“err_where”:“connect”,“http_code”:500,“err_details”:“LDAP Result Code 200 “Network Error”: dial tcp :389: connect: connection refused”}
{“level”:“error”,“ts”:1600362544.5607626,“caller”:“mlog/log.go:190”,“msg”:“Unable to connect to AD/LDAP server.”,“path”:"/api/v4/ldap/groups",“request_id”:“ctgjgeegsfympe897zdn5t4rfy”,“ip_addr”:“192.168.4.68”,“user_id”:“x7n1fe3fdt899deheeztcdxnde”,“method”:“GET”,“err_where”:“connect”,“http_code”:500,“err_details”:“LDAP Result Code 200 “Network Error”: dial tcp :389: connect: connection refused”}
{“level”:“error”,“ts”:1600362661.427334,“caller”:“mlog/log.go:190”,“msg”:“Unable to connect to AD/LDAP server.”,“path”:"/api/v4/ldap/groups",“request_id”:“tu6wgwoaxpbbd8nzjujaa3tzse”,“ip_addr”:“192.168.4.68”,“user_id”:“x7n1fe3fdt899deheeztcdxnde”,“method”:“GET”,“err_where”:“connect”,“http_code”:500,“err_details”:“LDAP Result Code 200 “Network Error”: dial tcp :389: connect: connection refused”}
{“level”:“info”,“ts”:1600362871.7065022,“caller”:“expirynotify/worker.go:85”,“msg”:“Worker: Job is complete”,“worker”:“ExpiryNotify”,“job_id”:“wiw8bi6detg8teujr1f7fpkptr”}
{“level”:“error”,“ts”:1600363241.572486,“caller”:“mlog/log.go:190”,“msg”:“Unable to connect to AD/LDAP server.”,“path”:"/api/v4/ldap/groups",“request_id”:“idkg3cx573dkirhsebp5r6tgfw”,“ip_addr”:“192.168.4.68”,“user_id”:“x7n1fe3fdt899deheeztcdxnde”,“method”:“GET”,“err_where”:“connect”,“http_code”:500,“err_details”:“LDAP Result Code 200 “Network Error”: dial tcp :389: connect: connection refused”}
{“level”:“error”,“ts”:1600363253.29569,“caller”:“mlog/log.go:190”,“msg”:“Enter a valid email or username and/or password.”,“path”:"/api/v4/users/login",“request_id”:“s1ygoxsrnbyo9gjcmb8z4fdwoh”,“ip_addr”:“192.168.13.81”,“user_id”:"",“method”:“POST”,“err_where”:“login”,“http_code”:401,“err_details”:""}
{“level”:“error”,“ts”:1600363264.2307582,“caller”:“mlog/log.go:190”,“msg”:“Enter a valid email or username and/or password.”,“path”:"/api/v4/users/login",“request_id”:“bus19neqnbn59xknq1gg7ysd4y”,“ip_addr”:“192.168.13.81”,“user_id”:"",“method”:“POST”,“err_where”:“login”,“http_code”:401,“err_details”:""}
{“level”:“error”,“ts”:1600363280.5301163,“caller”:“mlog/log.go:190”,“msg”:“Enter a valid email or username and/or password.”,“path”:"/api/v4/users/login",“request_id”:“c8jt6moctjyxuq5q35h1g64jhr”,“ip_addr”:“192.168.13.81”,“user_id”:"",“method”:“POST”,“err_where”:“login”,“http_code”:401,“err_details”:""}
{“level”:“error”,“ts”:1600363334.1618733,“caller”:“mlog/log.go:190”,“msg”:“Your password must contain at least 5 characters made up of at least one lowercase letter, at least one uppercase letter, and at least one number.”,“path”:"/api/v4/users/password/reset",“request_id”:“81q8fdrkeby4pf9zqg5uptwgmy”,“ip_addr”:“192.168.13.81”,“user_id”:"",“method”:“POST”,“err_where”:“User.IsValid”,“http_code”:400,“err_details”:""}
{“level”:“info”,“ts”:1600363334.5213516,“caller”:“app/server.go:646”,“msg”:“Stopping Server…”}
{“level”:“info”,“ts”:1600363334.5214598,“caller”:“app/web_hub.go:115”,“msg”:“stopping websocket hub connections”}
{“level”:“error”,“ts”:1600363335.150947,“caller”:“mlog/log.go:190”,“msg”:“Plugin failed to ServeHTTP, RPC call failed”,“plugin_id”:“com.mattermost.plugin-todo”,“error”:“connection is shut down”}
{“level”:“error”,“ts”:1600363335.1517594,“caller”:“mlog/log.go:190”,“msg”:“Plugin failed to ServeHTTP, RPC call failed”,“plugin_id”:“com.mattermost.plugin-todo”,“error”:“connection is shut down”}
{“level”:“error”,“ts”:1600363335.1532564,“caller”:“mlog/log.go:190”,“msg”:“Plugin failed to ServeHTTP, RPC call failed”,“plugin_id”:“com.mattermost.plugin-todo”,“error”:“connection is shut down”}
{“level”:“info”,“ts”:1600363335.3589766,“caller”:“app/plugin.go:292”,“msg”:“Shutting down plugins”}
{“level”:“warn”,“ts”:1600363335.359273,“caller”:“plugin/hclog_adapter.go:69”,“msg”:“error closing client during Kill”,“plugin_id”:“com.mattermost.nps”,“wrapped_extras”:“errconnection is shut down”}
{“level”:“warn”,“ts”:1600363335.3593152,“caller”:“plugin/hclog_adapter.go:71”,“msg”:“plugin failed to exit gracefully”,“plugin_id”:“com.mattermost.nps”}
{“level”:“error”,“ts”:1600363335.3593674,“caller”:“mlog/log.go:190”,“msg”:“RPC call OnDeactivate to plugin failed.”,“plugin_id”:“com.github.scottleedavis.mattermost-plugin-remind”,“error”:“connection is shut down”}
{“level”:“warn”,“ts”:1600363335.3594294,“caller”:“plugin/hclog_adapter.go:69”,“msg”:“error closing client during Kill”,“plugin_id”:“com.github.scottleedavis.mattermost-plugin-remind”,“wrapped_extras”:“errconnection is shut down”}
{“level”:“warn”,“ts”:1600363335.359465,“caller”:“plugin/hclog_adapter.go:71”,“msg”:“plugin failed to exit gracefully”,“plugin_id”:“com.github.scottleedavis.mattermost-plugin-remind”}
{“level”:“warn”,“ts”:1600363335.359529,“caller”:“plugin/hclog_adapter.go:69”,“msg”:“error closing client during Kill”,“plugin_id”:“com.mattermost.plugin-todo”,“wrapped_extras”:“errconnection is shut down”}
{“level”:“warn”,“ts”:1600363335.3595555,“caller”:“plugin/hclog_adapter.go:71”,“msg”:“plugin failed to exit gracefully”,“plugin_id”:“com.mattermost.plugin-todo”}
{“level”:“error”,“ts”:1600363335.3595877,“caller”:“mlog/log.go:190”,“msg”:“RPC call OnDeactivate to plugin failed.”,“plugin_id”:“com.github.matterpoll.matterpoll”,“error”:“connection is shut down”}
{“level”:“warn”,“ts”:1600363335.3596394,“caller”:“plugin/hclog_adapter.go:69”,“msg”:“error closing client during Kill”,“plugin_id”:“com.github.matterpoll.matterpoll”,“wrapped_extras”:“errconnection is shut down”}
{“level”:“warn”,“ts”:1600363335.360036,“caller”:“plugin/hclog_adapter.go:71”,“msg”:“plugin failed to exit gracefully”,“plugin_id”:“com.github.matterpoll.matterpoll”}
{“level”:“warn”,“ts”:1600363335.360134,“caller”:“plugin/hclog_adapter.go:69”,“msg”:“error closing client during Kill”,“plugin_id”:“zoom”,“wrapped_extras”:“errconnection is shut down”}
{“level”:“warn”,“ts”:1600363335.3601632,“caller”:“plugin/hclog_adapter.go:71”,“msg”:“plugin failed to exit gracefully”,“plugin_id”:“zoom”}
{“level”:“warn”,“ts”:1600363335.3602355,“caller”:“plugin/hclog_adapter.go:69”,“msg”:“error closing client during Kill”,“plugin_id”:“rssfeed”,“wrapped_extras”:“errconnection is shut down”}
{“level”:“warn”,“ts”:1600363335.360272,“caller”:“plugin/hclog_adapter.go:71”,“msg”:“plugin failed to exit gracefully”,“plugin_id”:“rssfeed”}
{“level”:“info”,“ts”:1600363335.3702786,“caller”:“jobs/workers.go:217”,“msg”:“Stopped workers”}
{“level”:“info”,“ts”:1600363335.3742833,“caller”:“jobs/schedulers.go:149”,“msg”:“Stopping schedulers.”}
{“level”:“info”,“ts”:1600363335.3744264,“caller”:“jobs/schedulers.go:81”,“msg”:“Schedulers stopped.”}
{“level”:“info”,“ts”:1600363335.375445,“caller”:“app/server.go:724”,“msg”:“Server stopped”}

чт, 17 сент. 2020 г., 21:01 Amy Blais via Mattermost Inc. <mattermost@discoursemail.com>:

amy.blais · September 18, 2020, 3:05pm

What happens if they go to Account Settings > Sidebar > Experimental Sidebar Features > Off, and then try enabling the feature again?

Ilya · September 18, 2020, 3:56pm

YES!
i see channels! But Experimental Sidebar Features don’t work when its on.
How i can do this for all my users?

пт, 18 сент. 2020 г. в 18:15, Amy Blais via Mattermost Inc. <mattermost@discoursemail.com>:

hmhealey · September 22, 2020, 1:18pm

Hi @Ilya. With the experimental sidebar features enabled, if you refresh the page with the browser’s developers console open (you should be able to open it with ctrl/cmd+shift+i), do you see any error messages logged to the console?

Before 5.26, the new sidebar worked mostly like the old one with some new features, but in 5.26, we added the channels that appear to the user’s sidebar to the database so that users can categorize and reorder their sidebar as they see fit. Something in the migration must have failed there, but if that’s the case, I would have expected to see a Channels and a Direct Messages section in the sidebar without any channels in either of them.

Ilya · September 22, 2020, 2:25pm

Hi @hmhealey. I got some mistakes.

index.js:114 Loading plugin com.mattermost.plugin-todo, version 0.3.0
index.js:114 Loading plugin com.github.matterpoll.matterpoll, version 1.3.0
index.js:114 Loading plugin zoom, version 1.4.1
index.js:114 Loading plugin com.mattermost.nps, version 1.0.4
index.js:100 Loaded plugin com.mattermost.plugin-todo, version 0.3.0
index.js:100 Loaded plugin zoom, version 1.4.1
index.js:100 Loaded plugin com.mattermost.nps, version 1.0.4
index.js:100 Loaded plugin com.github.matterpoll.matterpoll, version 1.3.0
websocket_client.jsx:35 websocket connecting to wss://chat.com/api/v4/websocket
websocket_client.jsx:38 [Report Only] Refused to connect to 'wss://chat.com/api/v4/websocket' because it violates the following Content Security Policy directive: "default-src https:". Note that 'connect-src' was not explicitly set, so 'default-src' is used as a fallback.

initialize @ websocket_client.jsx:38
K @ websocket_actions.jsx:132
componentDidMount @ logged_in.jsx:53
os @ react-dom.production.min.js:212
fu @ react-dom.production.min.js:255
t.unstable_runWithPriority @ scheduler.production.min.js:19
Fa @ react-dom.production.min.js:122
du @ react-dom.production.min.js:248
Zs @ react-dom.production.min.js:239
(anonymous) @ react-dom.production.min.js:123
t.unstable_runWithPriority @ scheduler.production.min.js:19
Fa @ react-dom.production.min.js:122
Ha @ react-dom.production.min.js:123
j @ scheduler.production.min.js:17
M.port1.onmessage @ scheduler.production.min.js:14
VM36:1 GET https://chat.com/api/v4/users/x7n1fe3fdt899deheeztcdxnde/teams/e4i8z6bbfbf9mr3xfabd3bjq5r/channels/categories 404
(anonymous) @ VM36:1
t.default @ fetch_etag.js:32
(anonymous) @ client4.js:1609
(anonymous) @ tslib.es6.js:100
(anonymous) @ tslib.es6.js:81
(anonymous) @ tslib.es6.js:74
l @ tslib.es6.js:70
doFetchWithResponse @ client4.js:1605
(anonymous) @ client4.js:1598
(anonymous) @ tslib.es6.js:100
(anonymous) @ tslib.es6.js:81
(anonymous) @ tslib.es6.js:74
l @ tslib.es6.js:70
doFetch @ client4.js:1594
getChannelCategories @ client4.js:752
(anonymous) @ channel_categories.js:80
(anonymous) @ tslib.es6.js:100
(anonymous) @ tslib.es6.js:81
(anonymous) @ tslib.es6.js:74
l @ tslib.es6.js:70
(anonymous) @ channel_categories.js:71
(anonymous) @ index.js:8
(anonymous) @ middleware.js:81
(anonymous) @ redux.js:477
componentDidMount @ sidebar.tsx:63
os @ react-dom.production.min.js:212
fu @ react-dom.production.min.js:255
t.unstable_runWithPriority @ scheduler.production.min.js:19
Fa @ react-dom.production.min.js:122
du @ react-dom.production.min.js:248
Zs @ react-dom.production.min.js:239
(anonymous) @ react-dom.production.min.js:123
t.unstable_runWithPriority @ scheduler.production.min.js:19
Fa @ react-dom.production.min.js:122
Ha @ react-dom.production.min.js:123
j @ scheduler.production.min.js:17
M.port1.onmessage @ scheduler.production.min.js:14
Show 7 more frames
websocket_client.jsx:38 POST https://chat.com/csp-report 405
initialize @ websocket_client.jsx:38
K @ websocket_actions.jsx:132
componentDidMount @ logged_in.jsx:53
os @ react-dom.production.min.js:212
fu @ react-dom.production.min.js:255
t.unstable_runWithPriority @ scheduler.production.min.js:19
Fa @ react-dom.production.min.js:122
du @ react-dom.production.min.js:248
Zs @ react-dom.production.min.js:239
(anonymous) @ react-dom.production.min.js:123
t.unstable_runWithPriority @ scheduler.production.min.js:19
Fa @ react-dom.production.min.js:122
Ha @ react-dom.production.min.js:123
j @ scheduler.production.min.js:17
M.port1.onmessage @ scheduler.production.min.js:14

hmhealey · September 23, 2020, 3:22pm

The call to GET https://chat.com/api/v4/users/x7n1fe3fdt899deheeztcdxnde/teams/e4i8z6bbfbf9mr3xfabd3bjq5r/channels/categories returning a 404 error is very strange. Are you sure you’re running the 5.27 versions of both the server and web app? I think that should only happen if you’re using an older version of the server with a newer version of the web app.

Ilya · September 24, 2020, 6:37am

I updated from 5.25 to 5.27. It is possible that during the update there is something left from 5.25. How can I check that I have web app 5.27?
Here is what is written about the application

hmhealey · September 24, 2020, 3:37pm

Unless you’ve built a custom version of Mattermost, both the server and web app will be the same version. That screen shows the server version, so it’s correctly on 5.27.0 which means that isn’t the issue.

There might be more information in the server logs if you could turn on debug logging and send those to me. Specifically, if you could:

Go to the System Console
Go to Environment > Logging
Set the Console Log Level and File Log Level to DEBUG and save.
Go back to the main page where you can see the empty sidebar and refresh the page.

That will print more information about the 404 error to the logs, so that might help us understand what’s going on. You can also send those to me directly if you’re worried about there being sensitive information in there.

Ilya · September 25, 2020, 10:15am

I found this error

{"level":"debug","ts":1601028194.5530357,"caller":"mlog/log.go:169","msg":"Failed to insert record to database.","path":"/api/v4/users/x7n1fe3fdt899deheeztcdxnde/teams/e4i8z6bbfbf9mr3xfabd3bjq5r/channels/categories","request_id":"mxmiw1xq4jgbdpk1wasait9giy","ip_addr":"192.168.101.174","user_id":"x7n1fe3fdt899deheeztcdxnde","method":"GET","err_where":"SqlPostStore.completePopulatingCategoryChannelsT","http_code":404,"err_details":"Error 1267: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='"} {"level":"debug","ts":1601028194.5532365,"caller":"web/handlers.go:100","msg":"Received HTTP request","method":"GET","url":"/api/v4/users/x7n1fe3fdt899deheeztcdxnde/teams/e4i8z6bbfbf9mr3xfabd3bjq5r/channels/categories","request_id":"mxmiw1xq4jgbdpk1wasait9giy","status_code":"404"}

hmhealey · September 25, 2020, 9:36pm

Excellent. That Failed to insert record to database. is exactly what we’re looking for. The new version of the sidebar that we added in 5.26 store more information about the configuration of the sidebar in the database, so it looks like it’s failing to actually save that new information in the database.

Looking at the Error 1267: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=', MySQL is having issues working on two database tables at once, likely the existing tables and the ones for the new sidebar. Have you recently upgraded to MySQL 8? According to this, MySQL 8.0.1 is what changed the default collation.

To fix the issue, you’ll need to change the collation of the database tables to match. I’d recommend changing the older tables to match the new ones since any future database tables that are created will also match the new ones. This StackOverflow answer should have information on how to do that.

Also, you can change the log levels back to whatever you had them set to before if you want since the DEBUG level is a lot noisier.

Ilya · September 26, 2020, 7:40am

Thank you for your help!
Everything worked out!
Below is a script, maybe it will help someone else.

ALTER DATABASE mattermost CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Audits CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Bots CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table ChannelMemberHistory CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table ChannelMembers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Channels CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table ClusterDiscovery CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table CommandWebhooks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Commands CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Compliances CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Emoji CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table FileInfo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table GroupChannels CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table GroupMembers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table GroupTeams CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table IncomingWebhooks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Jobs CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Licenses CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table LinkMetadata CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table OAuthAccessData CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table OAuthApps CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table OAuthAuthData CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table OutgoingWebhooks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table PluginKeyValueStore CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Posts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Preferences CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table PublicChannels CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Reactions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Roles CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Schemes CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Sessions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table SidebarCategories CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table SidebarChannels CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Status CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Systems CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table TeamMembers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Teams CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table TermsOfService CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Tokens CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table UserAccessTokens CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table UserGroups CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table UserTermsOfService CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table Users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

hmhealey · September 28, 2020, 3:13pm

Awesome! Glad to hear it’s working now. I hope you enjoy the new sidebar

Thanks for the script too. This is the first I’ve seen that issue, but by the sounds of it, we might see more of it in the future, so it’ll be really helpful to have around

Topic		Replies	Views
Sidebar is empty, can't see channels and Mobile app doesn't work Troubleshooting	1	589	May 2, 2022
Channels Names are not listed anymore after Server Update Troubleshooting	6	937	April 29, 2023
Channels not shown on Mattermost 7.1 Troubleshooting	1	460	May 22, 2023
[Solved] Channels disappear after upgrading Troubleshooting	3	1983	March 12, 2022
Failed to insert record to database Troubleshooting	12	3495	August 14, 2023

Cant see channels

Related topics