syncing history data.

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Trivial
    • None
    • Affects Version/s: None
    • Component/s: None
    • None

      Hi
      My zabbix server log file showing syncing history data. please help me on this issue. please find the below log file

      Process ID: 70101
      Session ID: 92 Serial number: 39222 [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23278]
       20462:20170614:114327.518 slow query: 929.253011 sec, "select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23278"
       20461:20170614:114329.573 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
      Process ID: 70091
      Session ID: 678 Serial number: 64210 [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23279]
       20461:20170614:114329.574 slow query: 929.961380 sec, "select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23279"
       20472:20170614:114430.141 housekeeper [deleted 8168 hist/trends, 0 items, 0 events, 0 sessions, 0 alarms, 0 audit items in 64.336757 sec, idle for 1 hour(s)]
       20459:20170614:124327.896 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
      Process ID: 63825
      Session ID: 237 Serial number: 26869 [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23278]
       20459:20170614:124327.898 slow query: 929.064770 sec, "select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23278"
       20472:20170614:124430.448 executing housekeeper
       20472:20170614:124524.188 housekeeper [deleted 8218 hist/trends, 0 items, 0 events, 0 sessions, 0 alarms, 0 audit items in 53.640270 sec, idle for 1 hour(s)]
       20461:20170614:134327.813 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
      Process ID: 98534
      Session ID: 152 Serial number: 54496 [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23279]
       20460:20170614:134327.815 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
      Process ID: 93287
      Session ID: 502 Serial number: 8848 [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23278]
       20461:20170614:134327.816 slow query: 927.904284 sec, "select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23279"
       20460:20170614:134327.817 slow query: 929.054978 sec, "select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23278"
       20472:20170614:134524.492 executing housekeeper
       20472:20170614:134630.391 housekeeper [deleted 8208 hist/trends, 0 items, 0 events, 0 sessions, 0 alarms, 0 audit items in 65.781906 sec, idle for 1 hour(s)]
       20459:20170614:144326.635 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
      Process ID: 138645
      Session ID: 678 Serial number: 33599 [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23278]
       20459:20170614:144326.636 slow query: 927.851330 sec, "select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23278"
       20462:20170614:144328.659 [Z3005] query failed: [-1] ORA-03113: end-of-file on communication channel
      Process ID: 98490
      Session ID: 92 Serial number: 49183 [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23279]
       20462:20170614:144328.660 slow query: 928.848477 sec, "select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=23279"
       20472:20170614:144630.689 executing housekeeper
       20472:20170614:144739.892 housekeeper [deleted 8069 hist/trends, 0 items, 0 events, 0 sessions, 0 alarms, 0 audit items in 69.092753 sec, idle for 1 hour(s)]
       20456:20170614:150447.164 syncing history data...
      

            Assignee:
            Unassigned
            Reporter:
            Avinash
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: