Database is down. Retrying in 10 seconds.
Man where do I start....
Zabbix server 2.0.13
Agents have a mix..
Database is RDS mysql instance.
So I had been getting these messages off and on for a while.
20087:20150309:091135.023 [Z3005] query failed: [2006] MySQL server has gone away [begin;]
Restarting zabbix would always clear them.
They started becoming much more frequent as in rolling into the log files.. So I tried to follow this guide..
h t t p : / / zabbixzone dot . c o m/zabbix/mysql-performance-tips-for-zabbix/
At first things seemed like they were working and I wasn't getting anymore messages.. Then I started getting the " 20087:20150309:091135.023 [Z3005] query failed: [2006] MySQL server has gone away [begin;]" messages again.. So I restarted Zabbix as I didn't have anymore time to deal with it.
This was a mistake..
Now I am getting these.
......
0113:20150309:090825.371 [Z3005] query failed: [2006] MySQL server has gone away [select distinct t.triggerid,t.type,t.value,t.value_flags,t.error from items i,functions f,triggers t,hosts h where i.itemid=f.itemid and f.triggerid=t.triggerid and i.hostid=h.hostid and i.status=0 and i.type in (0) and f.function not in ('nodata','d
ate','dayofmonth','dayofweek','time','now') and t.status=0 and h.hostid=10522 and h.status=0 and not exists (select 1 from functions f2,items i2,hosts h2 where f2.triggerid=f.triggerid and f2.itemid=i2.itemid and i2.hostid=h2.hostid and (f2.function in ('nodata','date','dayofmonth','dayofweek','time',' now') or (i2.type not in (0) an
d (i2.type not in (0,1,4,6,12,16) or (i2.type in (0) and h2.available=1) or (i2.type in (1,4,6) and h2.snmp_available=1) or (i2.type in (12) and h2.ipmi_available=1) or (i2.type in (16) and h2.jmx_available=1)))) and i2.status=0 and h2.status=0) order by t.triggerid]
.......
22478:20150312:202519.178 [Z3005] query failed: [2006] MySQL server has gone away [update triggers set value_flags=1,error='Zabbix was restarted.' where triggerid=20583;
....
22478:20150312:202539.205 Database is down. Retrying in 10 seconds.
I have been rolling back what changes I can to the mysql config but nothing seems to be working.
J
Zabbix server 2.0.13
Agents have a mix..
Database is RDS mysql instance.
So I had been getting these messages off and on for a while.
20087:20150309:091135.023 [Z3005] query failed: [2006] MySQL server has gone away [begin;]
Restarting zabbix would always clear them.
They started becoming much more frequent as in rolling into the log files.. So I tried to follow this guide..
h t t p : / / zabbixzone dot . c o m/zabbix/mysql-performance-tips-for-zabbix/
At first things seemed like they were working and I wasn't getting anymore messages.. Then I started getting the " 20087:20150309:091135.023 [Z3005] query failed: [2006] MySQL server has gone away [begin;]" messages again.. So I restarted Zabbix as I didn't have anymore time to deal with it.
This was a mistake..
Now I am getting these.
......
0113:20150309:090825.371 [Z3005] query failed: [2006] MySQL server has gone away [select distinct t.triggerid,t.type,t.value,t.value_flags,t.error from items i,functions f,triggers t,hosts h where i.itemid=f.itemid and f.triggerid=t.triggerid and i.hostid=h.hostid and i.status=0 and i.type in (0) and f.function not in ('nodata','d
ate','dayofmonth','dayofweek','time','now') and t.status=0 and h.hostid=10522 and h.status=0 and not exists (select 1 from functions f2,items i2,hosts h2 where f2.triggerid=f.triggerid and f2.itemid=i2.itemid and i2.hostid=h2.hostid and (f2.function in ('nodata','date','dayofmonth','dayofweek','time',' now') or (i2.type not in (0) an
d (i2.type not in (0,1,4,6,12,16) or (i2.type in (0) and h2.available=1) or (i2.type in (1,4,6) and h2.snmp_available=1) or (i2.type in (12) and h2.ipmi_available=1) or (i2.type in (16) and h2.jmx_available=1)))) and i2.status=0 and h2.status=0) order by t.triggerid]
.......
22478:20150312:202519.178 [Z3005] query failed: [2006] MySQL server has gone away [update triggers set value_flags=1,error='Zabbix was restarted.' where triggerid=20583;
....
22478:20150312:202539.205 Database is down. Retrying in 10 seconds.
I have been rolling back what changes I can to the mysql config but nothing seems to be working.
J
Comment