[Solved] Can't upgrade after version 10.0.1

Troubleshooting Upgrade
1

Hi all,

I had to migrate a self hosted (targz version) Mattermost 10.0.0 on a new server.
The migration worked fine, I’m trying now to upgrade this instance to a newer version but impossible to go after 10.0.1. I tried 10.0.2, 10.1, 10.5, 10.10 and every time after the update we receive a “Username or password invalid” from the web interface and this message in the logs

We encountered an error while finding user profiles

Can’t do anything either using the mmctl

When switching back to 10.0.1 or 10.0.0 everything is fine

Any idea about this issue?

Thanks!

2

okay, after lots of tests, we found out there was a missing column in the “users” table: mfausedtimestamps

alter table users add column mfausedtimestamps JSONB; fixed the problem

2 Likes
3

Yay! Glad to hear you got it figured out, @darxmuf. Thank you for following up with the solution!