Page 1 of 1

Multi-server event counts wrong

Posted: Tue Oct 09, 2018 12:30 pm
by tcg
I installed 1.32.1 in a test environment yesterday to try out multi-server mode as I need to deploy a multi-server setup. I have set up four cameras with two servers. I've noticed that the event totals are incorrect for the Hour column in the console. The system has not been up long enough to know whether the Day, Week and Month columns are accurate. In the attached photo, you can see that the Hour column actually shows the total number of events for that camera. When I click in the Hour column, there is only a couple of events for each camera within the last hour. Can anyone confirm?

Re: Multi-server event counts wrong

Posted: Tue Oct 09, 2018 1:00 pm
by iconnor
It looks to me like all the events happened in the last hour.

One thing to check is that zmstats.pl is being run on at least one of your servers. It does the event counts in the background.

Re: Multi-server event counts wrong

Posted: Tue Oct 09, 2018 1:49 pm
by tcg
So, I can confirm that all of the events did NOT happen within the last hour but instead were spread out over the last 24 hours. Also, I have zmstats running on one of the two servers but according to journalctl it hasn't run since yesterday afternoon. How often is it supposed to execute?

Re: Multi-server event counts wrong

Posted: Tue Oct 09, 2018 2:08 pm
by tcg
It looks like zmstats.pl was not running. I restarted zoneminder and it came back and updated the totals. Thanks for your help!

Re: Multi-server event counts wrong

Posted: Mon Jun 08, 2020 2:03 pm
by bspiegel
I am running zm 1.32.3 on a single xubuntu 18 server. All working well but the event totals don't seem to update.
zmstats.pl is running. When I kill zmstats, it restarts.
Status_Update_interval=60. Screen refresh is 20. Set to Hi-B/W.
If I delete events, the counts do not reset, even after waiting 5 minutes. Sometimes they do update but takes forever.
Any ideas?

Re: Multi-server event counts wrong

Posted: Mon Jun 08, 2020 9:55 pm
by iconnor
You don't have triggers. mysql -u zmuser -p zm < /usr/share/zoneminder/db/triggers.sql

Also, we REALLY recommend updating to 1.34