5.0.5 data is stale

[chrisp8756]

Hello,
My server appears to be working great but in the admin panel I'm seeing data is stale next to all my services. But all my services report they are up and working. Should I just reboot the server? How do I correct this problem?

[uxbod]

On the Server Status tab just click refresh.

[chrisp8756]

Did that and no change still showing data is stale. I also rebooted the server and no change. But everything is working as far as I can tell. Running Fedora Core 7, any other ideas?

[chrisp8756]

Hello,
I still don't have an answer does anyone else know what I can do to correct this problem?

[uxbod]

Well, mine always shows stable until I hit refresh. Does the timestamp next to the services change ?

[chrisp8756]

Yes when I hit refresh it displays the current time and date and then show data is stale.

[mmorse]

It's not too much to worry about -logger is not a critical process - 'data is stale' is not referring to the time when you refreshed the list, but the time when the data was reported to the logger database.

su - zimbra
/opt/zimbra/libexec/zmlogprocess
/opt/zimbra/libexec/zmgengraphs

If that doesn't help check for any errors in /opt/zimbra/logger/db/data/<hostname>.err and check the tables Logger - Zimbra :: Wiki as it can mean data isn't getting to the logger properly.

How it's calculated:

if (onlyServiceInfo) { if(((new Date()).getTime()/1000 - item.timestamp) > 21*60*60/1000) { html[idx++] = "<span class='ZaStaleData'>"; html[idx++] = AjxStringUtil.htmlEncode(item.time); html[idx++] = "&nbsp;"; html[idx++] = ZaMsg.DataIsStale;

(Also, read the description on Bug 24199 - kill logger service )

[chrisp8756]

Hello,
I'm lost at this point, I login to mysql and cannot find "zimbra_logger" in any of the tables in the Zimbra database.

This wasn't ever an issue until I upgraded to 5.0.5. So if everything appears to be functioning as far mail in and out is it worth troubleshooting the issue? I'm not very good with mysql and command line stuff.

If I don't do anything about it will my server crash?

[mmorse]

Hello,
I'm lost at this point, I login to mysql and cannot find "zimbra_logger" in any of the tables in the Zimbra database.

Simply:
su - zimbra
logmysql zimbra_logger
& you're there, then follow the rest of: Troubleshooting - Logger - Zimbra :: Wiki

This wasn't ever an issue until I upgraded to 5.0.5. So if everything appears to be functioning as far mail in and out is it worth troubleshooting the issue? I'm not very good with mysql and command line stuff.

If we can find a common factor in this so we can file a bug report that would be great, as I gave pretty much the same answer over in another thread: data is stale
(& I'm sure Dirk, Adv, or Uxbod would have hollered by now if something more critical was wrong.)
Whether Bug 24199 - kill logger service (slated for 5.5) will make filing a new issue for 5.0.4/.5 a moot point I don't know, but any leads you can provide would be appreciated.

If I don't do anything about it will my server crash?

Nope, nothing major that I can foresee to cause a crash if everything else reports fine right now (I assume nothing jumps out in a basic zmcontrol status).

[chrisp8756]

Thanks for the help on the MSQl I did the first part checking the tables and everything was ok with no errors. How much of article in Wiki should I go through in troubleshooting this issue?