Some items trends stopped to being populated

[stammer]

Some items trends stopped to been populated.
These items are set to keep trends for 365 days.
The housekeeper never runs.
Zabbix server is on version 2.2.3.
After April 17th trends data stopped to be calculated/populated.
Anyone know what is the root cause and how can I solve this problem?

[glebs.ivanovskis]

Maybe your trend cache is full?

[DmitryL]

Hello, stammer.

Does this problem affect all items or just few of them?
You said that housekeeper never runs. If that is true, how are the history/trends tables cleared from old data? Table partitioning?

Can you run this query from db?

SELECT clock FROM trends order by clock ASC limit 1;

Best regards,
Dmitry

[stammer]

Answer

Hello Dmitryb

Not all items are affected by this problem.
Only HISTORY_TEXT is purged, every week.
We don't purge data from HISTORY and HISTORY_UINT tables. The plan is to maintain this data for three years.
We use partitioned tables and indexes. All tables are compressed.
The database has almost 1TB of data.
I think we have data from 1 year and 2 months ago.

[stammer]

Some items trends stopped to being populated.

Any solution?

[glebs.ivanovskis]

Hi stammer!

Did you mean that trends for text values are not being populated?

Trends are computed only for Numeric (float) and Numeric (unsigned) item data types. Character, Text and Log have only history, no trends.

[stammer]

NO,

Float and unsigned stopped to being calculated.
Some of these items are not in TRENDS and TRENDS_UINT.

Maybe zabbix can't process so many items (currently I have 276273 items of type float and unsigned).

[stammer]

I observed another tip.
These items have daily interval updates, so zabbix receive only one value per day.

[glebs.ivanovskis]

These items have daily interval updates, so zabbix receive only one value per day.

Ordinary update intervals, scheduling intervals or trapper items?

[stammer]

Trapper Items

[glebs.ivanovskis]

Do you see them in history? Can it be a permission issue?