I'm using the 2.4.6 appliance which I realize isn't meant to be in production. I used the VMware ovf template to deploy.
As part of my testing, I've added ~80 Windows hosts using the Zabbix agent. Everything has been running smooth. Recently I started added some Cisco switches. This when things started going wrong. After a period of time, the zabbix-server process crashes. I have about 10 SNMP devices currently configured using the SNMP Interfaces template.
I did make some adjustments to the default values. Below are the changes I made:
/etc/zabbix/zabbix-server.conf
StartPollers=50
CacheSize=1G
/etc/my.cnf
max_connections=256
Set the VM template to 8G RAM. Also configured a 4G swap volume.
Here's an excerpt from the zabbix-server.log:
12700:20160323:161333.033 [Z3005] query failed: [2006] MySQL server has gone away [select distinct i.itemid from items i,hosts h,hosts_groups hg,groups g where i.hostid=h.hostid and h.hostid=hg.hostid and hg.groupid=g.groupid and i.key_='perf_counter["\\KEY"]' and i.status=0 and i.state=0 and h.status=0 and g.name in ('SERVERS')]
12700:20160323:161333.074 [Z3001] connection to database 'zabbix' failed: [1135] Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
12700:20160323:161333.075 Cannot connect to the database. Exiting...
12652:20160323:161333.269 One child process died (PID:12700,exitcode/signal:1). Exiting ...
MySQL stays up and running. Any ideas on where to start? I'm tempted to see if the issue is still present in the 3.x release.
As part of my testing, I've added ~80 Windows hosts using the Zabbix agent. Everything has been running smooth. Recently I started added some Cisco switches. This when things started going wrong. After a period of time, the zabbix-server process crashes. I have about 10 SNMP devices currently configured using the SNMP Interfaces template.
I did make some adjustments to the default values. Below are the changes I made:
/etc/zabbix/zabbix-server.conf
StartPollers=50
CacheSize=1G
/etc/my.cnf
max_connections=256
Set the VM template to 8G RAM. Also configured a 4G swap volume.
Here's an excerpt from the zabbix-server.log:
12700:20160323:161333.033 [Z3005] query failed: [2006] MySQL server has gone away [select distinct i.itemid from items i,hosts h,hosts_groups hg,groups g where i.hostid=h.hostid and h.hostid=hg.hostid and hg.groupid=g.groupid and i.key_='perf_counter["\\KEY"]' and i.status=0 and i.state=0 and h.status=0 and g.name in ('SERVERS')]
12700:20160323:161333.074 [Z3001] connection to database 'zabbix' failed: [1135] Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
12700:20160323:161333.075 Cannot connect to the database. Exiting...
12652:20160323:161333.269 One child process died (PID:12700,exitcode/signal:1). Exiting ...
MySQL stays up and running. Any ideas on where to start? I'm tempted to see if the issue is still present in the 3.x release.
Comment