Users shown as online when offline

[ae5960e8-a6fc-491f-b252-898ecf59af95]

Description:

Four of the users in my workspace are always shown as online (i.e. with the green light) even when they are not and all their devices are turned off. This also means they will never be notified on mobile, as the server thinks they’re at their device when they are not.

Steps to reproduce:

unknown

Expected behavior:

The user's status changed to “offline” when their app closes.

Server Setup Information:

Version of Rocket.Chat Server: 4.5.2 Operating System: Alpine Linux Deployment Method: Docker Number of Running Instances: 1 DB Replicaset Oplog: ? NodeJS Version: v14.18.3 MongoDB Version: 4.4.12 / wiredTiger Proxy: Nginx Firewalls involved:

Client Setup Information

• Desktop App or Browser Version: Chrome
• Operating System: Windows, Android, iOS

Additional context

There are no errors in the logs, and I have no idea how to solve it. It started a few days ago, after the 4.5.2 update. Thanks.

Relevant logs:

There are no logs hinting at any issue.

[MarlynxLinux]

Hello i have the same problem on version 5.3.3 (docker)

[ae5960e8-a6fc-491f-b252-898ecf59af95]

Hello i have the same problem on version 5.3.3 (docker)

There is no fix, best option is to rollback to before the issue or move to a new installation. I did the latter.

[MarlynxLinux]

I use mongodb 5.0 (percona server) separately from chat on a virtual machine, and the rocketchat server application is running in docker. I'm thinking of trying to move away from docker to a virtual machine with a rocket chat server application, maybe this will solve the problem with users

P.S. i tried, after switching from docker to virtual machine the problem didn't go away

[MarlynxLinux]

Hello i have the same problem on version 5.3.3 (docker)

There is no fix, best option is to rollback to before the issue or move to a new installation. I did the latter.

i did a new install and this problem reappeared (mongodb 5.0 community edition + rocketchat 5.4.0 + nginx proxy)

this happened after I upgraded the server from version 5.4.0 to 5.4.1, users who were online at that moment of the update, they remained in this status now permanently, even if they are offline.

[joker234]

Our hotfix, which seemed to work for the moment was to find all users with “stuck” sessions using this command:

db.usersSessions.find({"connections": {"$elemMatch": {"_createdAt": {"$lte": ISODate("2023-01-25")}}}})

You should select a date appropriate to your update time.

We then checked thoroughly the IDs and users and deleted all the usersSessions entries for them (one by one):

db.usersSessions.deleteOne({_id: "…"})

I hope this helps others as a hotfix. It seems like a migration problem when updating RocketChat.