Incorrect messages count

RocketChat / Rocket.Chat.Metrics

Monitoring setup for Rocket.Chat servers

MIT License

29 stars 28 forks source link

Incorrect messages count #7

Open emikolajczak opened 3 years ago

emikolajczak commented 3 years ago

Hi messages count presented in Grafana dashboard is much larger than real messages count in mongoDB collection rocketchat.message In our installation dashboard presents 13 462 666 messages but real count is

db.rocketchat_message.find().count()
8486360

I have noticed this difference after upgrade server to 3.6.3

Server Setup Information:

Version of Rocket.Chat Server: 3.6.3
Operating System: Centos 7
Deployment Method: docker-compose
Number of Running Instances: 6
DB Replicaset Oplog: YES
NodeJS Version: v12.16.1
MongoDB Version: 4.0.14

ankar84 commented 3 years ago

Do you use Prune messages feature?

emikolajczak commented 3 years ago

We have own retention tool which delete messages from database.

ankar84 commented 3 years ago

We have own retention tool which delete messages from database.

I think i can be the root cause for that issue. Even RC prune messages feature do messages count go crazy.

frdmn commented 3 years ago

Thanks for reporting this, could be indeed related to the message retention policies. Can you check the statistics from the Info panel in the admin UI and see what it reports for total messages? Does this value match up with the actual message count from MongoDB?

emikolajczak commented 3 years ago

Hi, Info panel shows same, incorrect value of messeges, as Grafana.