Latest Data OK, Dashboard Graph Blank for New Zabbix Hosts (6.0.40)

[Daniel_Stickel]

Hello everyone,

I’m currently facing the following issue with Zabbix:

For newly added hosts (since 2024/2025), values like CPU utilization appear correctly under Monitoring > Latest data, but in the standard Graph widget on the dashboard the data line is completely missing. When I switch to the Classic Graph, all CPU data displays as expected.

Interestingly, these new hosts also aren’t found via the full-text search: if I enter the hostname under Monitoring > Hosts, only the “old” servers (added before 2023) show up. The new ones must be selected manually via Host Groups.

My questions are:

1. Has anyone experienced that Zabbix fails to render graphs on the dashboard for freshly registered hosts, even though data is being collected?
2. Could the search issue and the graph issue be related (e.g. an indexing or permission cache problem)?

I’m running Zabbix 6.0.40.

Many thanks in advance for your help!

Best regards!

[cyber]

Just a very (VERY) wild guess... I think, I have seen it around... Something has gone wrong at one point with upgrades and you miss some DB triggers. If you go directly to DB, and look for "hosts" table, then you can see 2 fields, "name" and "name_upper" ... I am somewhat sure, that latter one does not get updated... table definition "should" have following, but you may not have it... You can compare data for older and newer hosts there...

Triggers:
hosts_name_upper_insert AFTER INSERT ON hosts FOR EACH ROW EXECUTE FUNCTION hosts_name_upper_upper()
hosts_name_upper_update AFTER UPDATE OF name ON hosts FOR EACH ROW EXECUTE FUNCTION hosts_name_upper_upper()

IIRC, that "name_upper" is used on many queries and if it is empty, you get nothing...

[Daniel_Stickel]

Thank you very much!
It really was that the triggers were missing on the database.
In addition, I had to update the data for the hosts where name_upper was not stored.
I also discovered that in the items table, a name_upper had to be entered for the items as well, and triggers had to be created.
After that, the graphs of the new servers worked, as did the full-text search.

Many thanks!

[cyber]

Just a very (VERY) wild guess... I think, I have seen it around... Something has gone wrong at one point with upgrades and you miss some DB triggers. If you go directly to DB, and look for "hosts" table, then you can see 2 fields, "name" and "name_upper" ... I am somewhat sure, that latter one does not get updated... table definition "should" have following, but you may not have it... You can compare data for older and newer hosts there...

Triggers:
hosts_name_upper_insert AFTER INSERT ON hosts FOR EACH ROW EXECUTE FUNCTION hosts_name_upper_upper()
hosts_name_upper_update AFTER UPDATE OF name ON hosts FOR EACH ROW EXECUTE FUNCTION hosts_name_upper_upper()

IIRC, that "name_upper" is used on many queries and if it is empty, you get nothing...

[Daniel_Stickel]

Thank you very much!
It really was that the triggers were missing on the database.
In addition, I had to update the data for the hosts where name_upper was not stored.
I also discovered that in the items table, a name_upper had to be entered for the items as well, and triggers had to be created.
After that, the graphs of the new servers worked, as did the full-text search.

Many thanks!