[SOLVED] Server statistics does not working

[boblin]

After change to new zmmylogpasswd i don't see any new error mesages about mysql in zmstat.out, but statistics still not working.

Any help?

Thanks.

[Priyantha Bleeker]

Same problem here.
In my log file there is still the message:

Warning: Not possible to monitor process stats

I have changed the Mysql root and normal password like the wiki said.

[hawk684]

My issue is very similar to yours.

My graphs on Message Count and Message Volume are blank, but my Anti-Spam one shows correct info.
zmsgtrace doesn't show any emails no matter what search parameters I use.
zmdailyreport always says "No messages found".
logmysql zimbra_logger works fine. The raw_logs table shows plenty of information and is adding new records just fine. loghost should be only x in x.domain.com, correct?

I do get the error "Warning: Not possible to monitor process stats" in zmstat.out

Running:
Release 5.0.4_GA_2101.UBUNTU6 UBUNTU6 FOSS edition
On Ubuntu Edgy Eft

[Priyantha Bleeker]

I am getting these errors:

04/11/2008 11:40:30: ERROR: No such process: '22696'
Warning: Not possible to monitor process stats
Warning: Not possible to monitor process stats
04/11/2008 15:32:30: ERROR: No such process: '30433'
04/11/2008 16:39:30: ERROR: No such process: '1135'
04/11/2008 17:47:30: ERROR: No such process: '32476'
04/11/2008 21:39:00: ERROR: No such process: '27416'
04/12/2008 21:13:30: ERROR: No such process: '8990'
04/13/2008 01:40:00: ERROR: No such process: '6825'
04/13/2008 06:50:31: ERROR: No such process: '29435'
04/13/2008 19:29:00: ERROR: No such process: '22897'
04/13/2008 19:50:00: ERROR: No such process: '28752'
04/13/2008 23:12:00: ERROR: No such process: '8648'
04/14/2008 09:06:00: ERROR: No such process: '2856'

I am running:
Release 5.0.2_GA_1975.RHEL4_20080130212006 CentOS4 FOSS edition

[p24t]

I've got the same in my zmstat.out - lots of Error no such pid. Still on 5.0.2 here as well.

[uxbod]

If you are getting that message then I reckon ZCS thinks the process has forked and is trying to monitor it. Please review all your Log Files - Zimbra :: Wiki again and also check /opt/zimbra/zmstat to see if files are being updated. You can also run

logmysql

does that connect to the MySQL instance okay ?

[boblin]

zimbra@zimbra:~/zmstat$ tail zmstat.out
04/13/2008 14:38:00: ERROR: No such process: '32524'
04/13/2008 14:49:00: ERROR: No such process: '2431'
04/13/2008 14:49:00: ERROR: No such process: '2432'
04/14/2008 01:07:30: ERROR: No such process: '12165'
Warning: Not possible to monitor process stats
04/14/2008 11:09:30: ERROR: No such process: '15959'
04/14/2008 11:09:30: ERROR: No such process: '15960'
04/15/2008 00:25:30: ERROR: No such process: '10346'
Warning: Not possible to monitor process stats
04/15/2008 06:07:30: ERROR: No such process: '28354'
zimbra@zimbra:~/zmstat$ logmysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 521
Server version: 5.0.51a-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

[jholder]

Hate to disagree, but I don't think this is a password issue.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=**** --database=z
imbra --batch --skip-column-names'. at /opt/zimbra/zimbramon/lib/Zimbra/DB/DB.pm line 73.
ERROR: service.FAILURE (system failure: getDirectContext) (cause: javax.naming.CommunicationException dog.ucetn
ictvi-on-line.cz:389)

I see 2 errors in here, a naming exception, and a unable to connect through socket. Both of these make me believe that it's your host file.

[boblin]

I think in my case are more than one problem:

Errors about mysql are in zmstat.out from time to time (once or twice in a month?). So i think this is not a problem, maybe it relate to restarts of zimbra.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=hzdPbn0sFISZZApQEQNn7r5rIbbbB8 --database=z
imbra --batch --skip-column-names'. at /opt/zimbra/zimbramon/lib/Zimbra/DB/DB.pm line 73.

Errors like

Warning: Not possible to monitor process stats

..and..

04/12/2008 07:30:00: ERROR: No such process: '30196'

..are in my zmstat.out since i have zimbra on server. So I think this is also not related to problem with graphs.

I don't have another errors in zmstat.out. I don't have any errors in syslog related to stats. I don't know why stats not working and where to find why.

[multicast]

All I get is this in my zmstat.out file:

Warning: Not possible to monitor process stats
04/11/2008 21:55:31: ERROR: No such process: '17247'
04/12/2008 03:03:30: ERROR: No such process: '26014'
04/12/2008 03:03:30: ERROR: No such process: '26016'
04/12/2008 04:17:00: ERROR: No such process: '6524'
04/14/2008 02:20:00: ERROR: No such process: '29973'
04/14/2008 19:33:30: ERROR: No such process: '2798'
04/14/2008 23:09:00: ERROR: No such process: '1617'

Ideas?