Update from 5.5.1 to 6.0.0 failed with postgres error

[DennisCodeBuds]

Hello,

I recently upgraded from 5.4.0 to 5.5.1 which worked straight away. I then tried to upgrade to 6.0.0 using

helm upgrade --install mattermost mattermost/mattermost-team-edition -n default -f helms/mattermost/values.production.yaml --version=6.0.0

This makes the pood repeatedly fail indicating a postgres error :

"level":"fatal","msg":"Failed to alter column type.","caller":"sqlstore/store.go:860","error":"pq: must be owner of table posts"

Reading through the changelog I noticed some warnings on database changes but found nothing related to the error I am getting.

Do you have any idea where this might be coming from ?

Versions

• kubectl : Client Version: version.Info{Major:"1", Minor:"21", GitVersion:"v1.21.5+k3s2", GitCommit:"724ef700bab896ff252a75e2be996d5f4ff1b842", GitTreeState:"clean", BuildDate:"2021-10-05T19:59:14Z", GoVersion:"go1.16.8", Compiler:"gc", Platform:"linux/amd64"} Server Version: version.Info{Major:"1", Minor:"21", GitVersion:"v1.21.5+k3s2", GitCommit:"724ef700bab896ff252a75e2be996d5f4ff1b842", GitTreeState:"clean", BuildDate:"2021-10-05T19:59:14Z", GoVersion:"go1.16.8", Compiler:"gc", Platform:"linux/amd64"}

• PostGres : postgres (PostgreSQL) 12.7

[DennisCodeBuds]

I finally got it to work.

The issue was that the owner of the database and the tables was gitlab_mattermost but the user that wanted to connect was gitlab.

To get the update to run correctly I changed the owner of the database and the tables (in order to do so I had to connect with the psql root user) :

ALTER DATABASE mattermost_production OWNER TO gitlab;
REASSIGN OWNED BY gitlab_mattermost TO gitlab;

I will now close this issue