I recently moved our Mattermost server into a DockerContainer and changed the database (from MySQL to Postgres)
I made a mistake which I have already corrected.
The CLI was a great help as I used
mattermost integrity --verbose to find out where I had to manually repair things.
The integrity check also shows me problems that appear to have nothing to do with my migration.
It marks items in the fileinfo and channels tables that seem to point at the wrong parent.
It looks like this:
Found 74 records in relation FileInfo orphans of relation Posts Child xyzxyzxzyxzyxzyxzy (FileInfo.Id) has empty ParentIdAttr (FileInfo.PostId) Found 220 records in relation Channels orphans of relation Teams Child abcabcabcabcabcabc (Channels.Id) has empty ParentIdAttr (Channels.TeamId)
I looked up the corresponding items in the db. The fileinfo items seem to belong to posts that have been manually deleted (left join results in empty post) and I have no clue what is wrong with the channels items. It has severaly channel entries with an empty teamid. I only have one team in my installation and that did never change.
Is this something I have to worry about?
And if not, why does the integrity check show these as orphaned?
Thanks in advance,