Zabbix Server stopped collecting data

[iftitutul]

I have using Zabbix 3.4.3 with mysql -5.5.58. few months ago I upgrade from zabbix 2.4. to zabbix 3.4.3 and mysql 5.1 to 5.5.58. But last few days I am facing a problem in Zabbix server, it can not collect data while zabbix history syncers is too high. If I restart the service sometimes it collect data but after a while it stopped collecting data. What is the issue of this?

My Mysql db size is: 85 GB. Is there issue of zabbix or mysql?

$ vim /etc/zabbix/zabbix_server.conf
StartPollers=100
StartPollersUnreachable=30
StartTrappers=5
StartPingers=30
StartHTTPPollers=4
StartJavaPollers=15
HousekeepingFrequency=24
MaxHousekeeperDelete= 5000
StartDBSyncers=10
HistoryCacheSize=16M
TrendCacheSize=16M
ValueCacheSize=256M
Timeout=20
UnreachablePeriod=60
UnreachableDelay=30

$/etc/my.cnf
[mysqld]
datadir=/dbdata/mysql
socket=/dbdata/mysql/mysql.sock
user=mysql
max_connections=200
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
skip-networking=0
bind-address=0.0.0.0
innodb_buffer_pool_size = 2000M
innodb_additional_mem_pool_size = 1024M
innodb_log_file_size = 1024M
innodb_log_buffer_size = 512M
innodb_flush_log_at_trx_commit = 0
innodb_write_io_threads = 4

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[tcilmo]

You might be hitting a bug that is fixed in 3.4.7. Here are the release notes: https://www.zabbix.com/rn/rn3.4.7

Take a look at this one: ZBX-13343 fixed last trends update clock caching.

We have had similar issues, but it was to do to a massive amount of internal events being created. Specifically internal trigger events.

If you are using the builtin template (Template Module Interfaces SNMPv2) with out modifications, check this out. https://support.zabbix.com/browse/ZBX-13478 - Posted by one of my colleagues.

[iftitutul]

It might be but how can I ensure about that. Becasue last few months it works well with any complications. Morever, I don't get any clue is there any issue of zabbix or database (MySql). Could you please tell me how to check? I have to investigate the issue.

[tcilmo]

It might be but how can I ensure about that. Becasue last few months it works well with any complications. Morever, I don't get any clue is there any issue of zabbix or database (MySql). Could you please tell me how to check? I have to investigate the issue.

If you are not on 3.4.7, you can upgrade to it and see if performance changes. Part of the issue could be number of items and triggers in the environment. Have you recently added a lot of new hosts to be monitored? Made any changes to templates, etc?

Also, in the template I mentioned - are you using it? There is a performance flaw in it.

[iftitutul]

I don't monitor any host via snmp so don't use any snmp template.
Recently don't add any lots of hosts but randomly added and modify hosts, items and triggers.

So without any check, Will I upgraded into 3.4.7 ?

[tcilmo]

I don't monitor any host via snmp so don't use any snmp template.
Recently don't add any lots of hosts but randomly added and modify hosts, items and triggers.

So without any check, Will I upgraded into 3.4.7 ?

It is an easy test and a quick thing to rule out.