Mattermost 10.3 push notification error

1

It’s been 2 days since I updated Mattermost from version 10.1 to version 10.3, and since then, I am no longer receiving messenger notifications on my phone.

I tried using the new “Test Notification” feature, and after selecting this option, I get the following message:
Error sending test notification

I checked the logs in the System Console and found the following error when attempting to send a notification:

{
  "caller": "app/notification_push.go:454",
  "error": "getMobileAppSessions: We encountered an error while finding user sessions., failed to find Sessions with userId=6qybfs4dafbi7ks1c1xuork91a: 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 9",
  "level": "error",
  "msg": "Unable to send push notification",
  "notification_type": "clear",
  "timestamp": "2025-01-11 08:02:03.668 Z"
}

I am using MySQL as my database.
I would greatly appreciate any help in resolving this issue.

Thank you!

sending notification error
sending notification error785×817 76 KB

2

You are using MariaDB (not MySQL) which is not supported by Mattermost. More context here: Push notifications do not work (SQL syntax error) · Issue #29459 · mattermost/mattermost · GitHub. Would suggest to migrate to MySQL, and eventually move to Postgres as we would be deprecating MySQL support soon as well.

1 Like
4

Is there any document here for migrating to Postgres?

5

in this case, this error is for Databese which is MariaDB and it is not compatible with mattermost 10.3

6

https://docs.mattermost.com/deploy/postgres-migration.html

1 Like