Zabbix 6.2.1 does not show graphs older than two days

[piti]

Hello,
I noticed an interesting thing.
after updating to zabbix 6.2, the graphs only show data for a maximum of two days... when I enter, for example, seven days... the displayed data is empty.

i'm running on zabbix server 6.2.1,
MariaDB 10.5.15 and Debian 11


graph of 2 days

graph of 7 days

[VeeEnDee]

Hey, piti.
What previous version you had?
It seems to me like you have updated from version 5.X< and ran sql script to update history tables, but you have not transferred your old data from old history tables to new ones.
If I am right all your history is availiable within zabbix db in tables like "history_old, history_uint_old" etc. And you need to do this.
In any case, if you have not got history, you should start checking history tables in your databases. Check your mysql\zabbix logs, maybe some access errors for histroy* tables there.

[Hamardaban]

When displaying a graph for a longer period, trends are used instead of history.
trends_uint and trends tables

Check how trend storage is configured for items data and clearing trend data.

And of course pay attention to the comments VeeEnDee !

[VeeEnDee]

longer period than what period?

[Hamardaban]

https://www.zabbix.com/documentation/current/en/manual/config/visualization/graphs/simple

please note "Generating from history/trends"

[VeeEnDee]

thank you for you reply. from docs:
>longevity of item history. For example, item history can be kept for 14 days. In that case, any data older than the fourteen days will be coming from trends.
Normally history is kept 7+ days as I can see from default zabbix templates, so my assumption is not silly. In the comment there were nothing about history keeping periods, so I did "pay attention". chill
BR

[Hamardaban]

то VeeEnDee : you probably misunderstood me (translation difficulties - sorry)
I wrote to piti to pay attention to YOUR comments! Because I think it is correct, adjusted for which tables you need to pay attention to (trends no history)

[VeeEnDee]

oh, thank you than. That was misunderstanding from my side. Sorry
Thanks for adjusting,
BR

[bunkzilla]

I'm having the same thing happen on 6.0.4. If I try to show anything greater than 2 days, it tries to grab data from trends, which in my scenario doesn't exist.