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
3

A push notification error in Mattermost 10.3 could be due to misconfigured notification settings, expired push notification certificates, or issues with the Push Notification Service. Check the server logs for specific error details and verify your configuration in the System Console under Push Notification Settings.

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