Error message after upgrade

Troubleshooting
1

Hello

I am using Mattermost Free Edition and I recently upgraded to Mattermost-Version: 10.11.1and Datenbankschema-Version: 141. Since then systemctl status mattermost regularly shows the following error.

Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘>>’$.last_removed_device_id’, ‘’)’ at line 1"}

How can I fix this? Mattermost still runs on Debian 12.12 with MariaDB mariadb-server-10.5.
Yours sincerely

Stefan Malte Schumacher

2

Just a guess: MariaDB isn’t supported (anymore) since a long time ago. As MySQL is deprecated soon in v11.x, too, it’s not really worth doing a migration from MariaDB to MySQL. I would switch to PostgreSQL directly, if possible.

But I can’t say for sure if the error message has something to do with the unsupported MariaDB

1 Like