Hello,
I have a selfhosted mm-instance (1), whose data I have imported with the mmctl-cli into another also selfhosted mm-instance (2).
After the successful import, however, I get the following error message in the server logs of mm-instance (2) every 5 minutes:
{
"caller": "app/post.go:2149",
"error": "SqlBotStore.Get: Bot does not exist., resource: Bot id: dhqs6peui3yszqhtj4ore7x68y",
"level": "error",
"msg": "Failed to get system bot",
"timestamp": "2024-06-07 21:00:00.003 Z"
}
I’ve had a look in the database: There is the user system-bot (table users), but no corresponding bot in the table bots. In the mm-instance (1), however, there are system-bot users and bots. So somehow something didn’t work during the data migration, I guess. By the way, I did not create the system-bot.
Now I wanted to create the bot manually in the mm-instance (2) with the mmctl-cli and used the command “user convert --bot”, which was obviously a mistake, because now the system-bot bot exists but no longer the corresponding user. The error message has not disappeared either.
Now my question is: How can I restore the system-bot user and fix the error message in the server logs? Or can I simply delete the system-bot bot? Or have I broken the instance completely (I hope not)?
Version Mattermost Team Edition (both instances): 9.9.0
Version PostgreSQL (both instances): 13.12
Thank you very much for your help!