Hi, zabbix shows me: Server Zabbix Server is unreachable
I am newbie to zabbix. I have installed zabbix hours ago, and since installation it shows this error.
I monitor one mikrotik router using snmp v2.(this works).
I used this manuals:
http://www.zabbix.com/documentation/...on_from_source
I have ubuntu 10.10 server and zabbix 1.8.2.
Last lines of: var/log/zabbix-server/zabbix_server.log:
I am newbie to zabbix. I have installed zabbix hours ago, and since installation it shows this error.
I monitor one mikrotik router using snmp v2.(this works).
I used this manuals:
http://www.zabbix.com/documentation/...on_from_source
I have ubuntu 10.10 server and zabbix 1.8.2.
Last lines of: var/log/zabbix-server/zabbix_server.log:
/usr/sbin/zabbix_server [15429]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15446]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15446]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Unlock failed [Identifier removed]
15449:20110213:144804.516 Expression [{12289}>150000] for item [22323][Main router:ifOutOctets4] cannot be evaluated: unable to get function value: lastvalue IS NULL for function [12289][Main router:ifOutOctets4.delta(0)]
/usr/sbin/zabbix_server [15427]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15428]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15428]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15428]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15428]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15429]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15429]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15429]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15429]: Unlock failed [Identifier removed]
15438:20110213:144808.340 [Z3005] Query failed: [2006] MySQL server has gone away [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.messa ge,a.status,mt.mediatypeid,mt.type,mt.description, mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_ path,mt.gsm_modem,mt.username,mt.passwd,a.retries from alerts a,media_type mt where a.status=0 and a.mediatypeid=mt.mediatypeid and a.alerttype=0 and mt.mediatypeid between 000000000000000 and 099999999999999 order by a.clock]
15438:20110213:144808.340 Database is down. Retrying in 10 seconds
15425:20110213:144808.373 [Z3001] Connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
15425:20110213:144808.373 Watchdog: Database is down
15448:20110213:144808.408 [Z3005] Query failed: [2006] MySQL server has gone away [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1297604888 or nextcheck>1297604888+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
15448:20110213:144808.408 Database is down. Retrying in 10 seconds
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15446]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15446]: Unlock failed [Identifier removed]
15426:20110213:144809.071 [Z3005] Query failed: [2006] MySQL server has gone away [select hostid,proxy_hostid,host,useip,ip,dns,port,status, useipmi,ipmi_ip,ipmi_port,ipmi_authtype,ipmi_privi lege,ipmi_username,ipmi_password,maintenance_statu s,maintenance_type,maintenance_from,errors_from,av ailable,disable_until,snmp_errors_from,snmp_availa ble,snmp_disable_until,ipmi_errors_from,ipmi_avail able,ipmi_disable_until from hosts where status in (0) and hostid between 000000000000000 and 099999999999999 order by hostid]
15426:20110213:144809.071 Database is down. Retrying in 10 seconds
/usr/sbin/zabbix_server [15431]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Unlock failed [Identifier removed]
15447:20110213:144809.984 [Z3005] Query failed: [2006] MySQL server has gone away [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.delay,t.macros,t.agent,t.authentication,t .http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1297604889 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
15447:20110213:144809.984 Database is down. Retrying in 10 seconds
15459:20110213:144810.091 [Z3005] Query failed: [2006] MySQL server has gone away [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,1) and nextcheck<=1297604890 and escalationid between 000000000000000 and 099999999999999]
15459:20110213:144810.091 Database is down. Retrying in 10 seconds
/usr/sbin/zabbix_server [15427]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Unlock failed [Identifier removed]
15425:20110213:144811.373 One child process died (PID:15449). Exiting ...
15425:20110213:144813.383 [Z3001] Connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15446]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15446]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Unlock failed [Identifier removed]
15449:20110213:144804.516 Expression [{12289}>150000] for item [22323][Main router:ifOutOctets4] cannot be evaluated: unable to get function value: lastvalue IS NULL for function [12289][Main router:ifOutOctets4.delta(0)]
/usr/sbin/zabbix_server [15427]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15428]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15428]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15428]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15428]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15429]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15429]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15429]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15429]: Unlock failed [Identifier removed]
15438:20110213:144808.340 [Z3005] Query failed: [2006] MySQL server has gone away [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.messa ge,a.status,mt.mediatypeid,mt.type,mt.description, mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_ path,mt.gsm_modem,mt.username,mt.passwd,a.retries from alerts a,media_type mt where a.status=0 and a.mediatypeid=mt.mediatypeid and a.alerttype=0 and mt.mediatypeid between 000000000000000 and 099999999999999 order by a.clock]
15438:20110213:144808.340 Database is down. Retrying in 10 seconds
15425:20110213:144808.373 [Z3001] Connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
15425:20110213:144808.373 Watchdog: Database is down
15448:20110213:144808.408 [Z3005] Query failed: [2006] MySQL server has gone away [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1297604888 or nextcheck>1297604888+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
15448:20110213:144808.408 Database is down. Retrying in 10 seconds
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15430]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15446]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15446]: Unlock failed [Identifier removed]
15426:20110213:144809.071 [Z3005] Query failed: [2006] MySQL server has gone away [select hostid,proxy_hostid,host,useip,ip,dns,port,status, useipmi,ipmi_ip,ipmi_port,ipmi_authtype,ipmi_privi lege,ipmi_username,ipmi_password,maintenance_statu s,maintenance_type,maintenance_from,errors_from,av ailable,disable_until,snmp_errors_from,snmp_availa ble,snmp_disable_until,ipmi_errors_from,ipmi_avail able,ipmi_disable_until from hosts where status in (0) and hostid between 000000000000000 and 099999999999999 order by hostid]
15426:20110213:144809.071 Database is down. Retrying in 10 seconds
/usr/sbin/zabbix_server [15431]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15431]: Unlock failed [Identifier removed]
15447:20110213:144809.984 [Z3005] Query failed: [2006] MySQL server has gone away [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.delay,t.macros,t.agent,t.authentication,t .http_user,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1297604889 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
15447:20110213:144809.984 Database is down. Retrying in 10 seconds
15459:20110213:144810.091 [Z3005] Query failed: [2006] MySQL server has gone away [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,1) and nextcheck<=1297604890 and escalationid between 000000000000000 and 099999999999999]
15459:20110213:144810.091 Database is down. Retrying in 10 seconds
/usr/sbin/zabbix_server [15427]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Unlock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Lock failed [Identifier removed]
/usr/sbin/zabbix_server [15427]: Unlock failed [Identifier removed]
15425:20110213:144811.373 One child process died (PID:15449). Exiting ...
15425:20110213:144813.383 [Z3001] Connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Comment