Statistics no longer working

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
liverpoolfcfan
Elite member
Elite member
Posts: 1096
Joined: Sat Sep 13, 2014 12:47 am

Re: Statistics no longer working

Post by liverpoolfcfan »

Slowly but surely ...

Charts are now generating for "Last 48 hours" but as yet there is little data to graph - I am confident this will rectify itself once a few hours have passed and enough messages have come/gone.

And, yes, we are running FOSS.

For history sake - the upgrade from 8.5.1 to 8.6 broke the stats on this server.

I have updated the bugzilla ticket and offered to supply zimbra with a copy of my saved file(s) to aid in debugging what the root cause of the problem was.

Thanks again for your help with this.
User avatar
JDunphy
Outstanding Member
Outstanding Member
Posts: 889
Joined: Fri Sep 12, 2014 11:18 pm
Location: Victoria, BC
ZCS/ZD Version: 9.0.0_P39 NETWORK Edition

Re: Statistics no longer working

Post by JDunphy »

I haven't been able to figure out what causes this to fail or when. I have been upgrading my versions since 5.0 and this was the first time I had to do this procedure and I moved from 32-bit to 64-bit at some point in the upgrades. Crazy stuff eh? :D
liverpoolfcfan
Elite member
Elite member
Posts: 1096
Joined: Sat Sep 13, 2014 12:47 am

Re: Statistics no longer working

Post by liverpoolfcfan »

I am pretty much in the same boat. I started testing with 6.0.1 and went live with 6.0.4 and upgraded all the way up. In my case it was the 8.5.1 -> 8.6 step that broke the stats.

Once again @JDunphy - thanks a million for your suggestions and pointing me to the method to reinitialize the stats DB. Although I have lost all the historic data it was of no use whatsoever when I couldn't see it.

I now have almost 4 days of stats graphed beautifully :-)

It would be nice if someone from zimbra actually followed up to get a copy of the broken data files and figured out what went wrong.
Bittone
Posts: 21
Joined: Mon Sep 05, 2016 4:30 pm

Re: Statistics no longer working

Post by Bittone »

Hello,
sorry for the long absence, I applied the solution proposed by JDunphy and graphs are back online.
Many thanks for your help and support and for you time.
The problem is probably related to update procedures, in my case, a fresh install of FOSS 8.7, the problem occured after some updates on LDAP components pushed through YUM.
Bye

Alberto
rmb33
Posts: 1
Joined: Sun Nov 20, 2016 11:12 pm

Re: Statistics no longer working

Post by rmb33 »

I was having the same exact issue as you and the fix was to get rsyslog working. I am running Centos7 and it wasn't running so I uncommented out the following lines in /etc/rsyslogd.conf:

Code: Select all

# Provides UDP syslog reception
$ModLoad imudp
$UDPServerRun 514

# Provides TCP syslog reception
$ModLoad imtcp
$InputTCPServerRun 514
Once enabling port 514 on UDP & TCP and restarting the service the graphs started to show up immediately.
linuradu
Posts: 4
Joined: Mon Apr 24, 2017 6:18 pm

Re: Statistics no longer working

Post by linuradu »

Thank you, reinitializing the Logger works for me https://wiki.zimbra.com/wiki/Ajcody-Log ... om_Scratch;
I'm using zimbra 8.7.7;
rotorboy
Advanced member
Advanced member
Posts: 169
Joined: Fri Sep 12, 2014 11:24 pm

Re: Statistics no longer working

Post by rotorboy »

Greetings,
I'm running ZCS NE 8.7.11GA 1854 currently and notice that whenever I try to view the statistics it says "Adobe Flash is required to view charts". I am not able to see any statistics as every chart is just showing "loading data for chart".
I don't have the problem where Zimbra says all services are offline. We had that awhile ago but got that part working.

I tried running:

Code: Select all

#tail -f log/zmlogswatch.out
Wed Feb 28 11:27:33 2018: Spawned: 13262 -- Connected from 127.0.0.1:54767
Wed Feb 28 11:27:33 2018: Spawned: 13263 -- Connected from 127.0.0.1:54768
Wed Feb 28 11:27:35 2018: Spawned: 13362 -- Connected from 127.0.0.1:54769
Wed Feb 28 11:27:35 2018: Spawned: 13363 -- Connected from 127.0.0.1:54770
Wed Feb 28 11:27:35 2018: Spawned: 13364 -- Connected from 127.0.0.1:54771
Wed Feb 28 11:27:35 2018: Spawned: 13365 -- Connected from 127.0.0.1:54772
Wed Feb 28 11:27:37 2018: Spawned: 13562 -- Connected from 127.0.0.1:54774
Wed Feb 28 11:27:37 2018: Spawned: 13563 -- Connected from 127.0.0.1:54775
Wed Feb 28 11:27:37 2018: Spawned: 13564 -- Connected from 127.0.0.1:54776
Wed Feb 28 11:27:37 2018: Spawned: 13565 -- Connected from 127.0.0.1:54777
Log file permissions seem to world readable. Stats seem to be running:

Code: Select all

[zimbra@zimbra ~]$ zmstatctl status
Running: zmstat-nginx
Running: zmstat-cpu
Running: zmstat-vm
Running: zmstat-proc
Running: zmstat-convertd
Running: zmstat-allprocs
Running: zmstat-io-x
Running: zmstat-fd
Running: zmstat-ldap
Running: zmstat-mtaqueue
Running: zmstat-io
Running: zmstat-df
Running: zmstat-mysql

Code: Select all

ls -lt /opt/zimbra/logger/db/data/rrds
shows lots of files that are up-to-date.

In zmstat.out the only error I see is:

Code: Select all

02/28/2018 11:20:10: Queue is too big! (20608 msgs); Already at maximum monitor interval of 600 seconds
I'm confused about what steps to check for at this time.
sureshpkolathur
Posts: 3
Joined: Mon Aug 22, 2016 6:02 am

Re: Statistics no longer working

Post by sureshpkolathur »

HI all,

zimbra 8.8.6 cant see message count and message volume statistics from admin console( GUI )

any help pls
rafael.pelegrineli
Posts: 1
Joined: Mon Apr 29, 2019 1:26 pm

Re: Statistics no longer working

Post by rafael.pelegrineli »

Same problem with new installation on Cent OS 7.
rotorboy wrote:Greetings,
I'm running ZCS NE 8.7.11GA 1854 currently and notice that whenever I try to view the statistics it says "Adobe Flash is required to view charts". I am not able to see any statistics as every chart is just showing "loading data for chart".
I don't have the problem where Zimbra says all services are offline. We had that awhile ago but got that part working.

I tried running:

Code: Select all

#tail -f log/zmlogswatch.out
Wed Feb 28 11:27:33 2018: Spawned: 13262 -- Connected from 127.0.0.1:54767
Wed Feb 28 11:27:33 2018: Spawned: 13263 -- Connected from 127.0.0.1:54768
Wed Feb 28 11:27:35 2018: Spawned: 13362 -- Connected from 127.0.0.1:54769
Wed Feb 28 11:27:35 2018: Spawned: 13363 -- Connected from 127.0.0.1:54770
Wed Feb 28 11:27:35 2018: Spawned: 13364 -- Connected from 127.0.0.1:54771
Wed Feb 28 11:27:35 2018: Spawned: 13365 -- Connected from 127.0.0.1:54772
Wed Feb 28 11:27:37 2018: Spawned: 13562 -- Connected from 127.0.0.1:54774
Wed Feb 28 11:27:37 2018: Spawned: 13563 -- Connected from 127.0.0.1:54775
Wed Feb 28 11:27:37 2018: Spawned: 13564 -- Connected from 127.0.0.1:54776
Wed Feb 28 11:27:37 2018: Spawned: 13565 -- Connected from 127.0.0.1:54777
Log file permissions seem to world readable. Stats seem to be running:

Code: Select all

[zimbra@zimbra ~]$ zmstatctl status
Running: zmstat-nginx
Running: zmstat-cpu
Running: zmstat-vm
Running: zmstat-proc
Running: zmstat-convertd
Running: zmstat-allprocs
Running: zmstat-io-x
Running: zmstat-fd
Running: zmstat-ldap
Running: zmstat-mtaqueue
Running: zmstat-io
Running: zmstat-df
Running: zmstat-mysql

Code: Select all

ls -lt /opt/zimbra/logger/db/data/rrds
shows lots of files that are up-to-date.

In zmstat.out the only error I see is:

Code: Select all

02/28/2018 11:20:10: Queue is too big! (20608 msgs); Already at maximum monitor interval of 600 seconds
I'm confused about what steps to check for at this time.
rotorboy
Advanced member
Advanced member
Posts: 169
Joined: Fri Sep 12, 2014 11:24 pm

Re: Statistics no longer working

Post by rotorboy »

I submitted this to Zimbra support some time ago and we went back and forth for quite awhile on it. Turns out, there's no solution and it doesn't sound like there's any intention for them to put in a proper solution anytime soon. For now we just have to accept that this area of the admin is effectively useless.
Post Reply