Ad Widget

Collapse

zabbix server crashed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tim
    Junior Member
    • Nov 2009
    • 1

    #1

    zabbix server crashed

    hi
    my zabbix server could't running

    debug log message


    //usr/local/sbin/zabbix_server [2010]: DEBUG: ZABBIX semaphores already exist, trying to recreate.
    2010:20091128:115940 Starting zabbix_server. ZABBIX 1.6.7 (revision 8252).
    2010:20091128:115940 **** Enabled features ****
    2010:20091128:115940 SNMP monitoring: YES
    2010:20091128:115940 WEB monitoring: YES
    2010:20091128:115940 Jabber notifications: YES
    2010:20091128:115940 ODBC: NO
    2010:20091128:115940 IPv6 support: NO
    2010:20091128:115940 **************************
    2010:20091128:115940 Query [SET CHARACTER SET utf8]
    2010:20091128:115940 Query [select refresh_unsupported from config where 1=1 and configid between 000000000000000 and 099999999999999]
    2010:20091128:115940 Query [select masterid from nodes where nodeid=0]
    2010:20091128:115940 In DBupdate_triggers_after_restart()
    2010:20091128:115940 Query [select distinct t.triggerid,t.expression,t.description,t.status,t. priority,t.value,t.url,t.comments from hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck+i.delay<1259380780 and i.key_<>'status' and h.status not in (4,3) and i.type not in (2)]
    2010:20091128:115940 Query [select min(i.nextcheck+i.delay) from hosts h,items i,triggers t,functions f where f.triggerid=t.triggerid and f.itemid=i.itemid and h.hostid=i.hostid and i.nextcheck<>0 and t.triggerid=13087 and i.type not in (2)]
    2010:20091128:115940 No triggers to update (2)
    2010:20091128:115940 End of DBupdate_triggers_after_restart()
    2010:20091128:115940 In init_database_cache() size:816
    2010:20091128:115940 Shared memory already exists for database cache, trying to recreate.
    2016:20091128:115940 server #6 started [Trapper]
    2016:20091128:115940 In child_trapper_main()
    2017:20091128:115940 server #7 started [Trapper]
    2017:20091128:115940 In child_trapper_main()
    2016:20091128:115940 Query [SET CHARACTER SET utf8]
    2017:20091128:115940 Query [SET CHARACTER SET utf8]
    2018:20091128:115940 server #8 started [Trapper]
    2018:20091128:115940 In child_trapper_main()
    2021:20091128:115940 server #11 started [ICMP pinger]
    2021:20091128:115940 In main_pinger_loop(num:1)
    2020:20091128:115940 server #10 started [Trapper]
    2020:20091128:115940 In child_trapper_main()
    2019:20091128:115940 server #9 started [Trapper]
    2019:20091128:115940 In child_trapper_main()
    2018:20091128:115940 Query [SET CHARACTER SET utf8]
    2021:20091128:115940 Query [SET CHARACTER SET utf8]
    2022:20091128:115940 server #12 started [Alerter]
    2023:20091128:115940 server #13 started [Housekeeper]
    2023:20091128:115940 Executing housekeeper
    2024:20091128:115940 server #14 started [Timer]
    2022:20091128:115940 Query [SET CHARACTER SET utf8]
    2022:20091128:115940 Query [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]
    2023:20091128:115940 Query [SET CHARACTER SET utf8]
    2023:20091128:115940 In housekeeping_history_and_trends(1259380780)
    2023:20091128:115940 Query [select itemid,history,trends from items]
    2020:20091128:115940 Query [SET CHARACTER SET utf8]
    2019:20091128:115940 Query [SET CHARACTER SET utf8]
    2021:20091128:115940 In get_pinger_hosts()
    2021:20091128:115940 Query [select distinct h.ip from hosts h,items i where mod(h.hostid,1)=0 and i.hostid=h.hostid and h.proxy_hostid=0 and h.status=0 and i.key_ in ('icmpping','icmppingsec') and i.type=3 and i.status in (0,3) and h.useip=1 and i.nextcheck<=1259380780 and h.hostid between 000000000000000 and 099999999999999]
    2024:20091128:115940 Query [SET CHARACTER SET utf8]
    2021:20091128:115940 Query [select distinct h.dns from hosts h,items i where mod(h.hostid,1)=0 and i.hostid=h.hostid and h.proxy_hostid=0 and h.status=0 and i.key_ in ('icmpping','icmppingsec') and i.type=3 and i.status in (0,3) and h.useip=0 and i.nextcheck<=1259380780 and h.hostid between 000000000000000 and 099999999999999]
    2024:20091128:115940 Query [select distinct i.itemid,i.key_,h.host,h.port,i.delay,i.descriptio n,i.nextcheck,i.type,i.snmp_community,i.snmp_oid,h .useip,h.ip,i.history,i.lastvalue,i.prevvalue,i.ho stid,h.status,i.value_type,h.errors_from,i.snmp_po rt,i.delta,i.prevorgvalue,i.lastclock,i.units,i.mu ltiplier,i.snmpv3_securityname,i.snmpv3_securityle vel,i.snmpv3_authpassphrase,i.snmpv3_privpassphras e,i.formula,h.available,i.status,i.trapper_hosts,i .logtimefmt,i.valuemapid,i.delay_flex,h.dns,i.para ms,i.trends,h.useipmi,h.ipmi_port,h.ipmi_authtype, h.ipmi_privilege,h.ipmi_username,h.ipmi_password,i .ipmi_sensor,i.lastlogsize from hosts h, items i, functions f where h.hostid=i.hostid and h.status=0 and i.status=0 and f.function in ('nodata','date','dayofweek','time','now') and i.itemid=f.itemid and h.hostid between 000000000000000 and 099999999999999]
    2021:20091128:115940 End of get_pinger_hosts():0
    2021:20091128:115940 In get_minnextcheck()
    2021:20091128:115940 Query [select count(*),min(i.nextcheck) from items i,hosts h where mod(h.hostid,1)=0 and h.status=0 and h.hostid=i.hostid and h.proxy_hostid=0 and i.key_ in ('icmpping','icmppingsec') and i.type=3 and i.status in (0,3) and h.hostid between 000000000000000 and 099999999999999]
    2021:20091128:115940 No items to update for minnextcheck.
    2021:20091128:115940 Pinger spent 0.019180 seconds while processing 0 items. Nextcheck after 60 sec.
    2023:20091128:115940 In delete_history(history,10001,7,1259380780)
    2023:20091128:115940 Query [select min(clock) from history where itemid=10001]
    2023:20091128:115940 In delete_history(history_uint,10001,7,1259380780)
    2023:20091128:115940 Query [select min(clock) from history_uint where itemid=10001]
    2023:20091128:115940 In delete_history(history_str,10001,7,1259380780)
    2023:20091128:115940 Query [select min(clock) from history_str where itemid=10001]
    2023:20091128:115940 In delete_history(history_text,10001,7,1259380780)
    2023:20091128:115940 Query [select min(clock) from history_text where itemid=10001]
    2023:20091128:115940 In delete_history(history_log,10001,7,1259380780)
    2023:20091128:115940 Query [select min(clock) from history_log where itemid=10001]
    2023:20091128:115940 In delete_history(trends,10001,365,1259380780)
    2023:20091128:115940 Query [select min(clock) from trends where itemid=10001]
    2029:20091128:115940 server #19 started [Escalator]
    2029:20091128:115940 In main_escalator_loop()
    2010:20091128:115941 server #0 started [Watchdog]
    2010:20091128:115941 In main_watchdog_loop()
    2026:20091128:115941 server #16 started [Node watcher. Node ID:0]
    2026:20091128:115941 In main_nodeupdater_loop()
    2026:20091128:115941 Starting sync with nodes
    2027:20091128:115941 server #17 started [HTTP Poller]
    2027:20091128:115941 In main_httppoller_loop(num:1)
    2026:20091128:115941 Query [SET CHARACTER SET utf8]
    2023:20091128:115941 In delete_history(history,10002,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history where itemid=10002]
    2023:20091128:115941 In delete_history(history_uint,10002,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_uint where itemid=10002]
    2023:20091128:115941 In delete_history(history_str,10002,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_str where itemid=10002]
    2026:20091128:115941 In main_historysender()
    2026:20091128:115941 Sleeping 10 seconds
    2023:20091128:115941 In delete_history(history_text,10002,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_text where itemid=10002]
    2027:20091128:115941 Query [SET CHARACTER SET utf8]
    2023:20091128:115941 In delete_history(history_log,10002,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_log where itemid=10002]
    2027:20091128:115941 In process_httptests()
    2027:20091128:115941 Query [select httptestid,name,applicationid,nextcheck,status,del ay,macros,agent from httptest where status=0 and nextcheck<=1259380781 and mod(httptestid,1)=0 and httptestid between 000000000000000 and 099999999999999]
    2023:20091128:115941 In delete_history(trends,10002,365,1259380780)
    2023:20091128:115941 Query [select min(clock) from trends where itemid=10002]
    2023:20091128:115941 In delete_history(history,10003,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history where itemid=10003]
    2010:20091128:115941 One child process died. Exiting ...
    2027:20091128:115941 End process_httptests()
    2027:20091128:115941 Spent 0 seconds while processing HTTP tests
    2027:20091128:115941 Query [select count(*),min(nextcheck) from httptest t where t.status=0 and mod(t.httptestid,1)=0 and t.httptestid between 000000000000000 and 099999999999999]
    2023:20091128:115941 In delete_history(history_uint,10003,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_uint where itemid=10003]
    2027:20091128:115941 No httptests to process in get_minnextcheck.
    2027:20091128:115941 Nextcheck:-1 Time:1259380781
    2027:20091128:115941 Sleeping for 5 seconds
    2023:20091128:115941 In delete_history(history_str,10003,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_str where itemid=10003]
    2023:20091128:115941 In delete_history(history_text,10003,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_text where itemid=10003]
    2029:20091128:115941 Query [SET CHARACTER SET utf8]
    2023:20091128:115941 In delete_history(history_log,10003,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_log where itemid=10003]
    2016:20091128:115941 Got signal. Exiting ...
    2029:20091128:115941 In process_escalations()
    2029:20091128:115941 Query [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,1) and nextcheck<=1259380781 and escalationid between 000000000000000 and 099999999999999]
    2029:20091128:115941 Escalator spent 0.005062 seconds while processing escalation items. Nextcheck after 3 sec.
    2023:20091128:115941 In delete_history(trends,10003,365,1259380780)
    2023:20091128:115941 Query [select min(clock) from trends where itemid=10003]
    2017:20091128:115941 Got signal. Exiting ...
    2018:20091128:115941 Got signal. Exiting ...
    2023:20091128:115941 In delete_history(history,10004,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history where itemid=10004]
    2023:20091128:115941 In delete_history(history_uint,10004,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_uint where itemid=10004]
    2023:20091128:115941 In delete_history(history_str,10004,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_str where itemid=10004]
    2023:20091128:115941 In delete_history(history_text,10004,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_text where itemid=10004]
    2023:20091128:115941 In delete_history(history_log,10004,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_log where itemid=10004]
    2023:20091128:115941 In delete_history(trends,10004,365,1259380780)
    2023:20091128:115941 Query [select min(clock) from trends where itemid=10004]
    2019:20091128:115941 Got signal. Exiting ...
    2023:20091128:115941 In delete_history(history,10005,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history where itemid=10005]
    2023:20091128:115941 In delete_history(history_uint,10005,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_uint where itemid=10005]
    2023:20091128:115941 In delete_history(history_str,10005,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_str where itemid=10005]
    2020:20091128:115941 Got signal. Exiting ...
    2023:20091128:115941 In delete_history(history_text,10005,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_text where itemid=10005]
    2023:20091128:115941 In delete_history(history_log,10005,7,1259380780)
    2021:20091128:115941 Got signal. Exiting ...
    2023:20091128:115941 Query [select min(clock) from history_log where itemid=10005]
    2023:20091128:115941 In delete_history(trends,10005,365,1259380780)
    2023:20091128:115941 Query [select min(clock) from trends where itemid=10005]
    2023:20091128:115941 In delete_history(history,10006,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history where itemid=10006]
    2022:20091128:115941 Got signal. Exiting ...
    2023:20091128:115941 In delete_history(history_uint,10006,7,1259380780)
    2023:20091128:115941 Query [select min(clock) from history_uint where itemid=10006]
    2023:20091128:115941 Got signal. Exiting ...
    2024:20091128:115941 Got signal. Exiting ...
    2026:20091128:115941 Got signal. Exiting ...
    2027:20091128:115941 Got signal. Exiting ...
    2029:20091128:115941 Got signal. Exiting ...
    2010:20091128:115943 Query [SET CHARACTER SET utf8]
    2010:20091128:115943 In free_database_cache()
    2010:20091128:115943 End of free_database_cache()
    2010:20091128:115943 ZABBIX Server stopped. ZABBIX 1.6.7 (revision 8252).


    what can i do ?
    thanks

    tim
Working...