API tools faq
paste
Guest User

Untitled

a guest
Feb 27th, 2014
198
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 146.38 KB | None | 0 0
raw download clone embed print report
  1. 18546:20140228:000429.734 In DBconnect() flag:1
  2. 18546:20140228:000429.734 query [txnlev:0] [PRAGMA synchronous = 0]
  3. 18546:20140228:000429.740 query [txnlev:0] [PRAGMA temp_store = 2]
  4. 18546:20140228:000429.740 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  5. 18546:20140228:000429.740 End of DBconnect():0
  6. 18546:20140228:000429.740 In free_database_cache()
  7. 18546:20140228:000429.740 In DCsync_all()
  8. 18546:20140228:000429.741 In DCsync_history() history_first:0 history_num:0
  9. 18546:20140228:000429.741 syncing history data...
  10. 18546:20140228:000429.741 syncing history data done
  11. 18546:20140228:000429.741 End of DCsync_all()
  12. 18546:20140228:000429.741 In zbx_mem_destroy() descr:'history cache'
  13. 18546:20140228:000429.741 End of zbx_mem_destroy()
  14. 18546:20140228:000429.741 In zbx_mem_destroy() descr:'history text cache'
  15. 18546:20140228:000429.741 End of zbx_mem_destroy()
  16. 18546:20140228:000429.741 End of free_database_cache()
  17. 18546:20140228:000429.741 In free_configuration_cache()
  18. 18546:20140228:000429.741 In zbx_mem_destroy() descr:'configuration cache'
  19. 18546:20140228:000429.741 End of zbx_mem_destroy()
  20. 18546:20140228:000429.741 In zbx_strpool_destroy()
  21. 18546:20140228:000429.741 In zbx_mem_destroy() descr:'string pool'
  22. 18546:20140228:000429.741 End of zbx_mem_destroy()
  23. 18546:20140228:000429.741 End of zbx_strpool_destroy()
  24. 18546:20140228:000429.741 End of free_configuration_cache()
  25. 18546:20140228:000429.742 In free_ipmi_handler()
  26. 18546:20140228:000429.742 End of free_ipmi_handler()
  27. 18546:20140228:000429.742 In free_selfmon_collector() collector:0x7fea0db2c000
  28. 18546:20140228:000429.742 End of free_selfmon_collector()
  29. 18546:20140228:000429.742 Zabbix Proxy stopped. Zabbix 2.0.5 (revision 33558).
  30. 18706:20140228:000429.793 Starting Zabbix Proxy (active) [prodBETA-mon-master]. Zabbix 2.0.5 (revision 33558).
  31. 18706:20140228:000429.793 **** Enabled features ****
  32. 18706:20140228:000429.793 SNMP monitoring: YES
  33. 18706:20140228:000429.793 IPMI monitoring: YES
  34. 18706:20140228:000429.793 WEB monitoring: YES
  35. 18706:20140228:000429.793 ODBC: NO
  36. 18706:20140228:000429.793 SSH2 support: YES
  37. 18706:20140228:000429.793 IPv6 support: YES
  38. 18706:20140228:000429.793 **************************
  39. 18706:20140228:000429.793 In init_database_cache()
  40. 18706:20140228:000429.793 In zbx_mem_required_size() size:0 chunks_num:4 descr:'history cache' param:'HistoryCacheSize'
  41. 18706:20140228:000429.793 End of zbx_mem_required_size() size:495
  42. 18706:20140228:000429.793 In zbx_mem_create() descr:'history cache' param:'HistoryCacheSize' size:8388575
  43. 18706:20140228:000429.794 valid user addresses: [0x7f23a6a78160, 0x7f23a7277fd8] total size: 8388216
  44. 18706:20140228:000429.794 End of zbx_mem_create()
  45. 18706:20140228:000429.794 In zbx_mem_required_size() size:0 chunks_num:1 descr:'history text cache' param:'HistoryTextCacheSize'
  46. 18706:20140228:000429.794 End of zbx_mem_required_size() size:411
  47. 18706:20140228:000429.794 In zbx_mem_create() descr:'history text cache' param:'HistoryTextCacheSize' size:16777216
  48. 18706:20140228:000429.794 valid user addresses: [0x7f23a5a78168, 0x7f23a6a77ff8] total size: 16776848
  49. 18706:20140228:000429.794 End of zbx_mem_create()
  50. 18706:20140228:000429.794 End of init_database_cache()
  51. 18706:20140228:000429.794 In init_configuration_cache() size:8388608
  52. 18706:20140228:000429.794 In zbx_mem_create() descr:'configuration cache' param:'CacheSize' size:7130317
  53. 18706:20140228:000429.794 valid user addresses: [0x7f23a53ab160, 0x7f23a5a77cc8] total size: 7129960
  54. 18706:20140228:000429.794 End of zbx_mem_create()
  55. 18706:20140228:000429.795 In zbx_strpool_create()
  56. 18706:20140228:000429.795 In zbx_mem_create() descr:'string pool' param:'CacheSize' size:1258291
  57. 18706:20140228:000429.795 valid user addresses: [0x7f23ad95a158, 0x7f23ada8d328] total size: 1257936
  58. 18706:20140228:000429.795 End of zbx_mem_create()
  59. 18706:20140228:000429.795 End of zbx_strpool_create()
  60. 18706:20140228:000429.795 End of init_configuration_cache()
  61. 18706:20140228:000429.795 In init_selfmon_collector()
  62. 18706:20140228:000429.795 init_selfmon_collector() size:5992
  63. 18706:20140228:000429.795 End of init_selfmon_collector() collector:0x7f23adaa4000
  64. 18706:20140228:000429.795 In DBconnect() flag:0
  65. 18706:20140228:000429.796 query [txnlev:0] [PRAGMA synchronous = 0]
  66. 18706:20140228:000429.802 query [txnlev:0] [PRAGMA temp_store = 2]
  67. 18706:20140228:000429.802 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  68. 18706:20140228:000429.802 End of DBconnect():0
  69. 18706:20140228:000429.802 In DCsync_configuration()
  70. 18706:20140228:000429.802 query [txnlev:0] [select alert_history,event_history,refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5 from config where 1=1]
  71. 18706:20140228:000429.802 query [txnlev:0] [select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_hosts,i.logtimefmt,i.params,i.status,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.lastclock from items i,hosts h where i.hostid=h.hostid and h.status in (0) and i.status in (0,3)]
  72. 18706:20140228:000429.803 query [txnlev:0] [select distinct t.triggerid,t.description,t.expression,t.error,t.priority,t.type,t.value,t.value_flags from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0) and i.status in (0,3) and t.status in (0) and t.flags not in (2)]
  73. 18706:20140228:000429.803 query [txnlev:0] [select d.triggerid_down,d.triggerid_up from trigger_depends d where 1=1 order by d.triggerid_down]
  74. 18706:20140228:000429.803 query [txnlev:0] [select i.itemid,f.functionid,f.function,f.parameter,t.triggerid from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status in (0) and i.status in (0,3) and t.status in (0) and t.flags not in (2)]
  75. 18706:20140228:000429.804 query [txnlev:0] [select hostid,proxy_hostid,host,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,maintenance_status,maintenance_type,maintenance_from,errors_from,available,disable_until,snmp_errors_from,snmp_available,snmp_disable_until,ipmi_errors_from,ipmi_available,ipmi_disable_until,jmx_errors_from,jmx_available,jmx_disable_until,status,name from hosts where status in (0,5,6)]
  76. 18706:20140228:000429.804 query [txnlev:0] [select hostid,templateid from hosts_templates where 1=1 order by hostid,templateid]
  77. 18706:20140228:000429.804 query [txnlev:0] [select globalmacroid,macro,value from globalmacro where 1=1]
  78. 18706:20140228:000429.804 query [txnlev:0] [select hostmacroid,hostid,macro,value from hostmacro where 1=1]
  79. 18706:20140228:000429.804 query [txnlev:0] [select interfaceid,hostid,type,main,useip,ip,dns,port from interface where 1=1]
  80. 18706:20140228:000429.804 In DCsync_config()
  81. 18706:20140228:000429.805 End of DCsync_config()
  82. 18706:20140228:000429.805 In DCsync_items()
  83. 18706:20140228:000429.805 End of DCsync_items()
  84. 18706:20140228:000429.805 In DCsync_triggers()
  85. 18706:20140228:000429.805 End of DCsync_triggers()
  86. 18706:20140228:000429.805 In DCsync_trigdeps()
  87. 18706:20140228:000429.805 End of DCsync_trigdeps()
  88. 18706:20140228:000429.805 In DCsync_functions()
  89. 18706:20140228:000429.805 End of DCsync_functions()
  90. 18706:20140228:000429.805 In DCsync_hosts()
  91. 18706:20140228:000429.805 End of DCsync_hosts()
  92. 18706:20140228:000429.805 In DCsync_htmpls()
  93. 18706:20140228:000429.805 End of DCsync_htmpls()
  94. 18706:20140228:000429.805 In DCsync_gmacros()
  95. 18706:20140228:000429.805 End of DCsync_gmacros()
  96. 18706:20140228:000429.805 In DCsync_hmacros()
  97. 18706:20140228:000429.805 End of DCsync_hmacros()
  98. 18706:20140228:000429.805 In DCsync_interfaces()
  99. 18706:20140228:000429.805 End of DCsync_interfaces()
  100. 18706:20140228:000429.805 DCsync_configuration() config : sql:0.000194 sync:0.000133 sec.
  101. 18706:20140228:000429.806 DCsync_configuration() items : sql:0.000406 sync:0.000096 sec.
  102. 18706:20140228:000429.806 DCsync_configuration() triggers : sql:0.000312 sync:0.000091 sec.
  103. 18706:20140228:000429.806 DCsync_configuration() trigdeps : sql:0.000165 sync:0.000092 sec.
  104. 18706:20140228:000429.806 DCsync_configuration() functions : sql:0.000263 sync:0.000155 sec.
  105. 18706:20140228:000429.806 DCsync_configuration() hosts : sql:0.000248 sync:0.000099 sec.
  106. 18706:20140228:000429.806 DCsync_configuration() templates : sql:0.000155 sync:0.000092 sec.
  107. 18706:20140228:000429.806 DCsync_configuration() globmacros : sql:0.000143 sync:0.000090 sec.
  108. 18706:20140228:000429.806 DCsync_configuration() hostmacros : sql:0.000150 sync:0.000091 sec.
  109. 18706:20140228:000429.806 DCsync_configuration() interfaces : sql:0.000157 sync:0.000095 sec.
  110. 18706:20140228:000429.806 DCsync_configuration() total sync : 0.001032 sec.
  111. 18706:20140228:000429.806 DCsync_configuration() total : 0.003226 sec.
  112. 18706:20140228:000429.806 DCsync_configuration() items : 0 (1009 slots)
  113. 18706:20140228:000429.806 DCsync_configuration() items_hk : 0 (1009 slots)
  114. 18706:20140228:000429.806 DCsync_configuration() snmpitems : 0 (1009 slots)
  115. 18706:20140228:000429.806 DCsync_configuration() ipmiitems : 0 (1009 slots)
  116. 18706:20140228:000429.806 DCsync_configuration() flexitems : 0 (1009 slots)
  117. 18706:20140228:000429.806 DCsync_configuration() trapitems : 0 (1009 slots)
  118. 18706:20140228:000429.806 DCsync_configuration() logitems : 0 (1009 slots)
  119. 18706:20140228:000429.806 DCsync_configuration() dbitems : 0 (1009 slots)
  120. 18706:20140228:000429.806 DCsync_configuration() sshitems : 0 (1009 slots)
  121. 18706:20140228:000429.806 DCsync_configuration() telnetitems: 0 (1009 slots)
  122. 18706:20140228:000429.807 DCsync_configuration() jmxitems : 0 (1009 slots)
  123. 18706:20140228:000429.807 DCsync_configuration() calcitems : 0 (1009 slots)
  124. 18706:20140228:000429.807 DCsync_configuration() functions : 0 (1009 slots)
  125. 18706:20140228:000429.807 DCsync_configuration() triggers : 0 (1009 slots)
  126. 18706:20140228:000429.807 DCsync_configuration() trigdeps : 0 (1009 slots)
  127. 18706:20140228:000429.807 DCsync_configuration() time_trigs : 0 (0 allocated)
  128. 18706:20140228:000429.807 DCsync_configuration() hosts : 0 (1009 slots)
  129. 18706:20140228:000429.807 DCsync_configuration() hosts_ph : 0 (1009 slots)
  130. 18706:20140228:000429.807 DCsync_configuration() proxies : 0 (1009 slots)
  131. 18706:20140228:000429.807 DCsync_configuration() ipmihosts : 0 (1009 slots)
  132. 18706:20140228:000429.807 DCsync_configuration() htmpls : 0 (1009 slots)
  133. 18706:20140228:000429.807 DCsync_configuration() gmacros : 0 (1009 slots)
  134. 18706:20140228:000429.807 DCsync_configuration() gmacros_m : 0 (1009 slots)
  135. 18706:20140228:000429.807 DCsync_configuration() hmacros : 0 (1009 slots)
  136. 18706:20140228:000429.807 DCsync_configuration() hmacros_hm : 0 (1009 slots)
  137. 18706:20140228:000429.807 DCsync_configuration() interfaces : 0 (1009 slots)
  138. 18706:20140228:000429.807 DCsync_configuration() interfac_ht: 0 (1009 slots)
  139. 18706:20140228:000429.807 DCsync_configuration() if_snmpitms: 0 (1009 slots)
  140. 18706:20140228:000429.807 DCsync_configuration() if_snmpaddr: 0 (1009 slots)
  141. 18706:20140228:000429.807 DCsync_configuration() queue[0] : 0 (0 allocated)
  142. 18706:20140228:000429.807 DCsync_configuration() queue[1] : 0 (0 allocated)
  143. 18706:20140228:000429.807 DCsync_configuration() queue[2] : 0 (0 allocated)
  144. 18706:20140228:000429.807 DCsync_configuration() queue[3] : 0 (0 allocated)
  145. 18706:20140228:000429.808 DCsync_configuration() queue[4] : 0 (0 allocated)
  146. 18706:20140228:000429.808 DCsync_configuration() pqueue : 0 (0 allocated)
  147. 18706:20140228:000429.808 DCsync_configuration() configfree : 96.085265%
  148. 18706:20140228:000429.808 DCsync_configuration() strings : 6 (1009 slots)
  149. 18706:20140228:000429.808 DCsync_configuration() strpoolfree: 99.294042%
  150. 18706:20140228:000429.808 === memory statistics for configuration cache ===
  151. 18706:20140228:000429.808 free chunks of size >= 256 bytes: 1
  152. 18706:20140228:000429.808 min chunk size: 6851184 bytes
  153. 18706:20140228:000429.808 max chunk size: 6851184 bytes
  154. 18706:20140228:000429.808 memory of total size 7129960 bytes fragmented into 43 chunks
  155. 18706:20140228:000429.808 of those, 6851184 bytes are in 1 free chunks
  156. 18706:20140228:000429.808 of those, 278440 bytes are in 42 used chunks
  157. 18706:20140228:000429.808 ================================
  158. 18706:20140228:000429.808 === memory statistics for string pool ===
  159. 18706:20140228:000429.808 free chunks of size >= 256 bytes: 1
  160. 18706:20140228:000429.808 min chunk size: 1249408 bytes
  161. 18706:20140228:000429.808 max chunk size: 1249408 bytes
  162. 18706:20140228:000429.808 memory of total size 1257936 bytes fragmented into 15 chunks
  163. 18706:20140228:000429.808 of those, 1249408 bytes are in 1 free chunks
  164. 18706:20140228:000429.808 of those, 8416 bytes are in 14 used chunks
  165. 18706:20140228:000429.808 ================================
  166. 18706:20140228:000429.808 End of DCsync_configuration()
  167. 18707:20140228:000429.814 proxy #1 started [configuration syncer #1]
  168. 18707:20140228:000429.814 In main_proxyconfig_loop()
  169. 18707:20140228:000429.814 In DBconnect() flag:0
  170. 18707:20140228:000429.815 query [txnlev:0] [PRAGMA synchronous = 0]
  171. 18708:20140228:000429.817 proxy #2 started [heartbeat sender #1]
  172. 18708:20140228:000429.818 In main_heart_loop()
  173. 18708:20140228:000429.818 In send_heartbeat()
  174. 18708:20140228:000429.818 In connect_to_server() [10.168.24.153]:10051 [timeout:60]
  175. 18708:20140228:000429.821 In put_data_to_server() datalen:62
  176. 18708:20140228:000429.821 In send_data_to_server() [{
  177. "request":"proxy heartbeat",
  178. "host":"prodBETA-mon-master"}]
  179. 18708:20140228:000429.821 In zbx_recv_response()
  180. 18709:20140228:000429.822 proxy #3 started [data sender #1]
  181. 18709:20140228:000429.822 In main_datasender_loop()
  182. 18709:20140228:000429.822 In DBconnect() flag:0
  183. 18707:20140228:000429.829 query [txnlev:0] [PRAGMA temp_store = 2]
  184. 18707:20140228:000429.829 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  185. 18710:20140228:000429.833 proxy #4 started [poller #1]
  186. 18710:20140228:000429.833 In main_poller_loop() process_type:'poller' process_num:1
  187. 18710:20140228:000429.833 In DBconnect() flag:0
  188. 18709:20140228:000429.833 query [txnlev:0] [PRAGMA synchronous = 0]
  189. 18711:20140228:000429.837 proxy #5 started [poller #2]
  190. 18711:20140228:000429.837 In main_poller_loop() process_type:'poller' process_num:2
  191. 18711:20140228:000429.837 In DBconnect() flag:0
  192. 18708:20140228:000429.842 zbx_recv_response() '{
  193. "response":"success"}'
  194. 18708:20140228:000429.842 End of zbx_recv_response():SUCCEED
  195. 18708:20140228:000429.842 End of put_data_to_server():SUCCEED
  196. 18708:20140228:000429.842 sleeping for 60 seconds
  197. 18713:20140228:000429.849 proxy #7 started [poller #4]
  198. 18713:20140228:000429.849 In main_poller_loop() process_type:'poller' process_num:4
  199. 18713:20140228:000429.849 In DBconnect() flag:0
  200. 18707:20140228:000429.853 End of DBconnect():0
  201. 18707:20140228:000429.853 In process_configuration_sync()
  202. 18707:20140228:000429.853 In connect_to_server() [10.168.24.153]:10051 [timeout:600]
  203. 18710:20140228:000429.854 query [txnlev:0] [PRAGMA synchronous = 0]
  204. 18711:20140228:000429.854 query [txnlev:0] [PRAGMA synchronous = 0]
  205. 18707:20140228:000429.855 In get_data_from_server() request:'proxy config'
  206. 18707:20140228:000429.855 In send_data_to_server() [{
  207. "request":"proxy config",
  208. "host":"prodBETA-mon-master"}]
  209. 18707:20140228:000429.855 In recv_data_from_server()
  210. 18714:20140228:000429.863 proxy #8 started [poller #5]
  211. 18714:20140228:000429.863 In main_poller_loop() process_type:'poller' process_num:5
  212. 18714:20140228:000429.863 In DBconnect() flag:0
  213. 18714:20140228:000429.864 query [txnlev:0] [PRAGMA synchronous = 0]
  214. 18709:20140228:000429.865 query [txnlev:0] [PRAGMA temp_store = 2]
  215. 18712:20140228:000429.865 proxy #6 started [poller #3]
  216. 18712:20140228:000429.865 In main_poller_loop() process_type:'poller' process_num:3
  217. 18712:20140228:000429.865 In DBconnect() flag:0
  218. 18712:20140228:000429.866 query [txnlev:0] [PRAGMA synchronous = 0]
  219. 18713:20140228:000429.872 query [txnlev:0] [PRAGMA synchronous = 0]
  220. 18716:20140228:000429.881 proxy #10 started [trapper #1]
  221. 18716:20140228:000429.882 In main_trapper_loop()
  222. 18716:20140228:000429.882 In DBconnect() flag:0
  223. 18716:20140228:000429.883 query [txnlev:0] [PRAGMA synchronous = 0]
  224. 18717:20140228:000429.873 proxy #11 started [trapper #2]
  225. 18717:20140228:000429.884 In main_trapper_loop()
  226. 18717:20140228:000429.884 In DBconnect() flag:0
  227. 18715:20140228:000429.886 proxy #9 started [unreachable poller #1]
  228. 18715:20140228:000429.886 In main_poller_loop() process_type:'unreachable poller' process_num:1
  229. 18715:20140228:000429.886 In DBconnect() flag:0
  230. 18715:20140228:000429.887 query [txnlev:0] [PRAGMA synchronous = 0]
  231. 18710:20140228:000429.889 query [txnlev:0] [PRAGMA temp_store = 2]
  232. 18717:20140228:000429.889 query [txnlev:0] [PRAGMA synchronous = 0]
  233. 18709:20140228:000429.897 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  234. 18711:20140228:000429.903 query [txnlev:0] [PRAGMA temp_store = 2]
  235. 18719:20140228:000429.904 proxy #13 started [trapper #4]
  236. 18719:20140228:000429.904 In main_trapper_loop()
  237. 18718:20140228:000429.905 proxy #12 started [trapper #3]
  238. 18718:20140228:000429.906 In main_trapper_loop()
  239. 18718:20140228:000429.906 In DBconnect() flag:0
  240. 18718:20140228:000429.907 query [txnlev:0] [PRAGMA synchronous = 0]
  241. 18719:20140228:000429.913 In DBconnect() flag:0
  242. 18707:20140228:000429.914 Received [{
  243. "globalmacro":{
  244. "fields":["globalmacroid","macro","value"],
  245. "data":[
  246. [2,"{$SNMP_COMMUNITY}","public"]]},
  247. "hosts":{
  248. "fields":["hostid","host","status","ipmi_authtype","ipmi_privilege","ipmi_username","ipmi_password","name"],
  249. "data":[
  250. [10048,"Template App Zabbix Proxy",3,0,2,"","","Template App Zabbix Proxy"],
  251. [10050,"Template App Zabbix Agent",3,0,2,"","","Template App Zabbix Agent"],
  252. [10060,"Template SNMP Interfaces",3,0,2,"","","Template SNMP Interfaces"],
  253. [10065,"Template SNMP Generic",3,0,2,"","","Template SNMP Generic"],
  254. [10068,"Template SNMP Disks",3,0,2,"","","Template SNMP Disks"],
  255. [10069,"Template SNMP OS Linux",3,0,2,"","","Template SNMP OS Linux"],
  256. [10070,"Template SNMP Processors",3,0,2,"","","Template SNMP Processors"],
  257. [10095,"Template App HTTPS Service",3,0,2,"","","Template App HTTPS Service"],
  258. [10102,"Template App SSH Service",3,0,2,"","","Template App SSH Service"],
  259. [10104,"Template ICMP Ping",3,0,2,"","","Template ICMP Ping"],
  260. [10110,"10.185.3.248",0,0,2,"","","prodBETA-mon-master"],
  261. [10111,"prodBETA-lb-0",0,0,2,"","","prodBETA-lb-0"]]},
  262. "interface":{
  263. "fields":["interfaceid","hostid","main","type","useip","ip","dns","port"],
  264. "data":[
  265. [9,10110,1,1,1,"10.185.3.248","","10050"],
  266. [10,10110,1,2,1,"10.185.3.248","","161"],
  267. [11,10111,1,1,1,"10.164.38.249","","10050"],
  268. [12,10111,1,2,1,"10.164.38.249","","161"]]},
  269. "hosts_templates":{
  270. "fields":["hosttemplateid","hostid","templateid"],
  271. "data":[
  272. [26,10069,10068],
  273. [27,10069,10065],
  274. [28,10069,10060],
  275. [29,10069,10070],
  276. [50,10110,10050],
  277. [51,10110,10069],
  278. [52,10110,10102],
  279. [53,10110,10048],
  280. [54,10110,10104],
  281. [55,10111,10050],
  282. [56,10111,10069],
  283. [57,10111,10102],
  284. [58,10111,10095],
  285. [59,10111,10104]]},
  286. "hostmacro":{
  287. "fields":["hostmacroid","hostid","macro","value"],
  288. "data":[]},
  289. "items":{
  290. "fields":["itemid","type","snmp_community","snmp_oid","hostid","key_","delay","status","value_type","trapper_hosts","snmpv3_securityname","snmpv3_securitylevel","snmpv3_authpassphrase","snmpv3_privpassphrase","formula","logtimefmt","delay_flex","params","ipmi_sensor","data_type","authtype","username","password","publickey","privatekey","flags","filter","interfaceid","port","snmpv3_authprotocol","snmpv3_privprotocol","snmpv3_contextname"],
  291. "data":[
  292. [23774,0,"","",10110,"agent.hostname",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",9,"",0,0,""],
  293. [23775,0,"","",10110,"agent.ping",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",9,"",0,0,""],
  294. [23776,0,"","",10110,"agent.version",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",9,"",0,0,""],
  295. [23777,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrProcessorLoad",10110,"hrProcessorLoad",3600,0,4,"","",0,"","","1","","","","",0,0,"","","","",1,":",10,"",0,0,""],
  296. [23778,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageDescr",10110,"hrStorageDescr",3600,0,4,"","",0,"","","1","","","","",0,0,"","","","",1,"{#SNMPVALUE}:@Storage devices for SNMP discovery",10,"",0,0,""],
  297. [23779,4,"{$SNMP_COMMUNITY}","IF-MIB::ifDescr",10110,"ifDescr",3600,0,4,"","",0,"","","1","","","","",0,0,"","","","",1,":",10,"",0,0,""],
  298. [23780,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrProcessorLoad.{#SNMPINDEX}",10110,"hrProcessorLoad[{#SNMPINDEX}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  299. [23781,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageAllocationUnits.{#SNMPINDEX}",10110,"hrStorageAllocationUnits[{#SNMPVALUE}]",3600,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  300. [23782,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageDescr.{#SNMPINDEX}",10110,"hrStorageDescr[{#SNMPVALUE}]",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  301. [23784,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageSize.{#SNMPINDEX}",10110,"hrStorageSize[{#SNMPVALUE}]",3600,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  302. [23786,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageUsed.{#SNMPINDEX}",10110,"hrStorageUsed[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  303. [23787,4,"{$SNMP_COMMUNITY}","IF-MIB::ifAdminStatus.{#SNMPINDEX}",10110,"ifAdminStatus[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  304. [23788,4,"{$SNMP_COMMUNITY}","IF-MIB::ifAlias.{#SNMPINDEX}",10110,"ifAlias[{#SNMPVALUE}]",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  305. [23789,4,"{$SNMP_COMMUNITY}","IF-MIB::ifDescr.{#SNMPINDEX}",10110,"ifDescr[{#SNMPVALUE}]",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  306. [23790,4,"{$SNMP_COMMUNITY}","IF-MIB::ifInErrors.{#SNMPINDEX}",10110,"ifInErrors[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  307. [23791,4,"{$SNMP_COMMUNITY}","IF-MIB::ifInOctets.{#SNMPINDEX}",10110,"ifInOctets[{#SNMPVALUE}]",60,0,3,"","",0,"","","8","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  308. [23792,4,"{$SNMP_COMMUNITY}","IF-MIB::ifOperStatus.{#SNMPINDEX}",10110,"ifOperStatus[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  309. [23793,4,"{$SNMP_COMMUNITY}","IF-MIB::ifOutErrors.{#SNMPINDEX}",10110,"ifOutErrors[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  310. [23794,4,"{$SNMP_COMMUNITY}","IF-MIB::ifOutOctets.{#SNMPINDEX}",10110,"ifOutOctets[{#SNMPVALUE}]",60,0,3,"","",0,"","","8","","","","",0,0,"","","","",2,"",10,"",0,0,""],
  311. [23795,4,"{$SNMP_COMMUNITY}","IF-MIB::ifNumber.0",10110,"ifNumber",3600,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",10,"",0,0,""],
  312. [23796,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysContact.0",10110,"sysContact",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",10,"",0,0,""],
  313. [23797,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysDescr.0",10110,"sysDescr",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",10,"",0,0,""],
  314. [23798,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysLocation.0",10110,"sysLocation",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",10,"",0,0,""],
  315. [23799,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysName.0",10110,"sysName",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",10,"",0,0,""],
  316. [23800,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysUpTime.0",10110,"sysUpTime",60,0,3,"","",0,"","","0.01","","","","",0,0,"","","","",0,"",10,"",0,0,""],
  317. [23801,3,"","",10110,"net.tcp.service[ssh]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",9,"",0,0,""],
  318. [23802,5,"","",10110,"zabbix[process,configuration syncer,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  319. [23803,5,"","",10110,"zabbix[process,data sender,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  320. [23804,5,"","",10110,"zabbix[process,discoverer,avg,busy]",60,0,0,"localhost","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  321. [23805,5,"","",10110,"zabbix[process,heartbeat sender,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  322. [23806,5,"","",10110,"zabbix[process,history syncer,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  323. [23807,5,"","",10110,"zabbix[process,housekeeper,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  324. [23808,5,"","",10110,"zabbix[process,http poller,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  325. [23809,5,"","",10110,"zabbix[process,icmp pinger,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  326. [23810,5,"","",10110,"zabbix[process,ipmi poller,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  327. [23811,5,"","",10110,"zabbix[process,java poller,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  328. [23812,5,"","",10110,"zabbix[process,poller,avg,busy]",60,0,0,"localhost","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  329. [23813,5,"","",10110,"zabbix[process,self-monitoring,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  330. [23814,5,"","",10110,"zabbix[process,snmp trapper,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  331. [23815,5,"","",10110,"zabbix[process,trapper,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  332. [23816,5,"","",10110,"zabbix[process,unreachable poller,avg,busy]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  333. [23817,5,"","",10110,"zabbix[queue,10m]",600,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  334. [23818,5,"","",10110,"zabbix[queue]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  335. [23819,5,"","",10110,"zabbix[rcache,buffer,pfree]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  336. [23820,5,"","",10110,"zabbix[wcache,history,pfree]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  337. [23821,5,"","",10110,"zabbix[wcache,text,pfree]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  338. [23822,5,"","",10110,"zabbix[wcache,values]",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",null,"",0,0,""],
  339. [23823,3,"","",10110,"icmpping",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",9,"",0,0,""],
  340. [23824,3,"","",10110,"icmppingloss",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",9,"",0,0,""],
  341. [23825,3,"","",10110,"icmppingsec",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",9,"",0,0,""],
  342. [23826,0,"","",10111,"agent.hostname",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",11,"",0,0,""],
  343. [23827,0,"","",10111,"agent.ping",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",11,"",0,0,""],
  344. [23828,0,"","",10111,"agent.version",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",11,"",0,0,""],
  345. [23829,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrProcessorLoad",10111,"hrProcessorLoad",3600,0,4,"","",0,"","","1","","","","",0,0,"","","","",1,":",12,"",0,0,""],
  346. [23830,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageDescr",10111,"hrStorageDescr",3600,0,4,"","",0,"","","1","","","","",0,0,"","","","",1,"{#SNMPVALUE}:@Storage devices for SNMP discovery",12,"",0,0,""],
  347. [23831,4,"{$SNMP_COMMUNITY}","IF-MIB::ifDescr",10111,"ifDescr",3600,0,4,"","",0,"","","1","","","","",0,0,"","","","",1,":",12,"",0,0,""],
  348. [23832,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrProcessorLoad.{#SNMPINDEX}",10111,"hrProcessorLoad[{#SNMPINDEX}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  349. [23833,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageAllocationUnits.{#SNMPINDEX}",10111,"hrStorageAllocationUnits[{#SNMPVALUE}]",3600,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  350. [23834,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageDescr.{#SNMPINDEX}",10111,"hrStorageDescr[{#SNMPVALUE}]",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  351. [23836,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageSize.{#SNMPINDEX}",10111,"hrStorageSize[{#SNMPVALUE}]",3600,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  352. [23838,4,"{$SNMP_COMMUNITY}","HOST-RESOURCES-MIB::hrStorageUsed.{#SNMPINDEX}",10111,"hrStorageUsed[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  353. [23839,4,"{$SNMP_COMMUNITY}","IF-MIB::ifAdminStatus.{#SNMPINDEX}",10111,"ifAdminStatus[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  354. [23840,4,"{$SNMP_COMMUNITY}","IF-MIB::ifAlias.{#SNMPINDEX}",10111,"ifAlias[{#SNMPVALUE}]",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  355. [23841,4,"{$SNMP_COMMUNITY}","IF-MIB::ifDescr.{#SNMPINDEX}",10111,"ifDescr[{#SNMPVALUE}]",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  356. [23842,4,"{$SNMP_COMMUNITY}","IF-MIB::ifInErrors.{#SNMPINDEX}",10111,"ifInErrors[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  357. [23843,4,"{$SNMP_COMMUNITY}","IF-MIB::ifInOctets.{#SNMPINDEX}",10111,"ifInOctets[{#SNMPVALUE}]",60,0,3,"","",0,"","","8","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  358. [23844,4,"{$SNMP_COMMUNITY}","IF-MIB::ifOperStatus.{#SNMPINDEX}",10111,"ifOperStatus[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  359. [23845,4,"{$SNMP_COMMUNITY}","IF-MIB::ifOutErrors.{#SNMPINDEX}",10111,"ifOutErrors[{#SNMPVALUE}]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  360. [23846,4,"{$SNMP_COMMUNITY}","IF-MIB::ifOutOctets.{#SNMPINDEX}",10111,"ifOutOctets[{#SNMPVALUE}]",60,0,3,"","",0,"","","8","","","","",0,0,"","","","",2,"",12,"",0,0,""],
  361. [23847,4,"{$SNMP_COMMUNITY}","IF-MIB::ifNumber.0",10111,"ifNumber",3600,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",12,"",0,0,""],
  362. [23848,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysContact.0",10111,"sysContact",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",12,"",0,0,""],
  363. [23849,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysDescr.0",10111,"sysDescr",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",12,"",0,0,""],
  364. [23850,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysLocation.0",10111,"sysLocation",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",12,"",0,0,""],
  365. [23851,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysName.0",10111,"sysName",3600,0,1,"","",0,"","","1","","","","",0,0,"","","","",0,"",12,"",0,0,""],
  366. [23852,4,"{$SNMP_COMMUNITY}","SNMPv2-MIB::sysUpTime.0",10111,"sysUpTime",60,0,3,"","",0,"","","0.01","","","","",0,0,"","","","",0,"",12,"",0,0,""],
  367. [23853,3,"","",10111,"net.tcp.service[ssh]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",11,"",0,0,""],
  368. [23854,3,"","",10111,"net.tcp.service[https]",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",11,"",0,0,""],
  369. [23855,3,"","",10111,"icmpping",60,0,3,"","",0,"","","1","","","","",0,0,"","","","",0,"",11,"",0,0,""],
  370. [23856,3,"","",10111,"icmppingloss",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",11,"",0,0,""],
  371. [23857,3,"","",10111,"icmppingsec",60,0,0,"","",0,"","","1","","","","",0,0,"","","","",0,"",11,"",0,0,""]]},
  372. "drules":{
  373. "fields":["druleid","iprange","delay"],
  374. "data":[]},
  375. "dchecks":{
  376. "fields":["dcheckid","druleid","type","key_","snmp_community","ports","snmpv3_securityname","snmpv3_securitylevel","snmpv3_authpassphrase","snmpv3_privpassphrase","uniq","snmpv3_authprotocol","snmpv3_privprotocol","snmpv3_contextname"],
  377. "data":[]},
  378. "regexps":{
  379. "fields":["regexpid","name"],
  380. "data":[
  381. [1,"File systems for discovery"],
  382. [2,"Network interfaces for discovery"],
  383. [3,"Storage devices for SNMP discovery"]]},
  384. "expressions":{
  385. "fields":["expressionid","regexpid","expression","expression_type","exp_delimiter","case_sensitive"],
  386. "data":[
  387. [1,1,"^(btrfs|ext2|ext3|ext4|jfs|reiser|xfs|ffs|ufs|jfs|jfs2|vxfs|hfs|ntfs|fat32|zfs)$",3,",",0],
  388. [2,2,"^lo$",4,",",1],
  389. [3,3,"^(Physical memory|Virtual memory|Memory buffers|Cached memory|Swap space)$",4,",",1],
  390. [4,2,"^Software Loopback Interface",4,",",1]]},
  391. "groups":{
  392. "fields":["groupid"],
  393. "data":[
  394. [5]]},
  395. "config":{
  396. "fields":["configid","refresh_unsupported","discovery_groupid","snmptrap_logging"],
  397. "data":[
  398. [1,600,5,1]]},
  399. "httptest":{
  400. "fields":["httptestid","name","delay","variables","agent","authentication","http_user","http_password","hostid","http_proxy","retries"],
  401. "data":[]},
  402. "httptestitem":{
  403. "fields":["httptestitemid","httptestid","itemid","type"],
  404. "data":[]},
  405. "httpstep":{
  406. "fields":["httpstepid","httptestid","name","no","url","timeout","posts","required","status_codes","variables"],
  407. "data":[]},
  408. "httpstepitem":{
  409. "fields":["httpstepitemid","httpstepid","itemid","type"],
  410. "data":[]}}] from server
  411. 18707:20140228:000429.914 End of get_data_from_server():SUCCEED
  412. 18707:20140228:000429.914 Received configuration data from server. Datalen 16080
  413. 18707:20140228:000429.914 In process_proxyconfig()
  414. 18712:20140228:000429.917 query [txnlev:0] [PRAGMA temp_store = 2]
  415. 18719:20140228:000429.917 query [txnlev:0] [PRAGMA synchronous = 0]
  416. 18714:20140228:000429.918 query [txnlev:0] [PRAGMA temp_store = 2]
  417. 18720:20140228:000429.918 proxy #14 started [trapper #5]
  418. 18720:20140228:000429.918 In main_trapper_loop()
  419. 18720:20140228:000429.919 In DBconnect() flag:0
  420. 18720:20140228:000429.919 query [txnlev:0] [PRAGMA synchronous = 0]
  421. 18713:20140228:000429.925 query [txnlev:0] [PRAGMA temp_store = 2]
  422. 18721:20140228:000429.928 proxy #15 started [icmp pinger #1]
  423. 18721:20140228:000429.929 In main_pinger_loop() process_num:1
  424. 18723:20140228:000429.929 proxy #17 started [http poller #1]
  425. 18723:20140228:000429.930 In main_httppoller_loop() process_num:1
  426. 18723:20140228:000429.930 In DBconnect() flag:0
  427. 18723:20140228:000429.931 query [txnlev:0] [PRAGMA synchronous = 0]
  428. 18710:20140228:000429.936 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  429. 18722:20140228:000429.941 proxy #16 started [housekeeper #1]
  430. 18722:20140228:000429.942 executing housekeeper
  431. 18722:20140228:000429.942 In DBconnect() flag:0
  432. 18722:20140228:000429.943 query [txnlev:0] [PRAGMA synchronous = 0]
  433. 18721:20140228:000429.943 In DBconnect() flag:0
  434. 18721:20140228:000429.944 query [txnlev:0] [PRAGMA synchronous = 0]
  435. 18716:20140228:000429.944 query [txnlev:0] [PRAGMA temp_store = 2]
  436. 18709:20140228:000429.945 End of DBconnect():0
  437. 18711:20140228:000429.945 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  438. 18709:20140228:000429.949 In host_availability_sender()
  439. 18709:20140228:000429.949 In get_host_availability_data()
  440. 18709:20140228:000429.949 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  441. 18717:20140228:000429.952 query [txnlev:0] [PRAGMA temp_store = 2]
  442. 18715:20140228:000429.953 query [txnlev:0] [PRAGMA temp_store = 2]
  443. 18725:20140228:000429.953 proxy #19 started [history syncer #1]
  444. 18725:20140228:000429.954 In main_dbsyncer_loop() process_num:1
  445. 18725:20140228:000429.954 In DBconnect() flag:0
  446. 18725:20140228:000429.955 query [txnlev:0] [PRAGMA synchronous = 0]
  447. 18707:20140228:000429.956 query [txnlev:1] [begin;]
  448. 18707:20140228:000429.956 In process_proxyconfig_table() table:'globalmacro'
  449. 18707:20140228:000429.956 query [txnlev:1] [select globalmacroid from globalmacro]
  450. 18707:20140228:000429.956 query [txnlev:1] [insert into globalmacro (globalmacroid,macro,value) values (2,'{$SNMP_COMMUNITY}','public');
  451. ]
  452. 18707:20140228:000429.957 End of process_proxyconfig_table():SUCCEED
  453. 18707:20140228:000429.957 In process_proxyconfig_table() table:'hosts'
  454. 18707:20140228:000429.957 query [txnlev:1] [select hostid from hosts]
  455. 18707:20140228:000429.957 query [txnlev:1] [insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10048,'Template App Zabbix Proxy',3,0,2,'','','Template App Zabbix Proxy');
  456. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10050,'Template App Zabbix Agent',3,0,2,'','','Template App Zabbix Agent');
  457. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10060,'Template SNMP Interfaces',3,0,2,'','','Template SNMP Interfaces');
  458. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10065,'Template SNMP Generic',3,0,2,'','','Template SNMP Generic');
  459. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10068,'Template SNMP Disks',3,0,2,'','','Template SNMP Disks');
  460. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10069,'Template SNMP OS Linux',3,0,2,'','','Template SNMP OS Linux');
  461. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10070,'Template SNMP Processors',3,0,2,'','','Template SNMP Processors');
  462. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10095,'Template App HTTPS Service',3,0,2,'','','Template App HTTPS Service');
  463. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10102,'Template App SSH Service',3,0,2,'','','Template App SSH Service');
  464. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10104,'Template ICMP Ping',3,0,2,'','','Template ICMP Ping');
  465. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10110,'10.185.3.248',0,0,2,'','','prodBETA-mon-master');
  466. insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name) values (10111,'prodBETA-lb-0',0,0,2,'','','prodBETA-lb-0');
  467. ]
  468. 18707:20140228:000429.958 End of process_proxyconfig_table():SUCCEED
  469. 18707:20140228:000429.958 In process_proxyconfig_table() table:'interface'
  470. 18707:20140228:000429.958 query [txnlev:1] [select interfaceid from interface]
  471. 18707:20140228:000429.959 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (9,10110,1,1,1,'10.185.3.248','','10050');
  472. insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (10,10110,1,2,1,'10.185.3.248','','161');
  473. insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (11,10111,1,1,1,'10.164.38.249','','10050');
  474. insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port) values (12,10111,1,2,1,'10.164.38.249','','161');
  475. ]
  476. 18707:20140228:000429.959 End of process_proxyconfig_table():SUCCEED
  477. 18707:20140228:000429.959 In process_proxyconfig_table() table:'hosts_templates'
  478. 18707:20140228:000429.959 query [txnlev:1] [select hosttemplateid from hosts_templates]
  479. 18707:20140228:000429.959 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid) values (26,10069,10068);
  480. insert into hosts_templates (hosttemplateid,hostid,templateid) values (27,10069,10065);
  481. insert into hosts_templates (hosttemplateid,hostid,templateid) values (28,10069,10060);
  482. insert into hosts_templates (hosttemplateid,hostid,templateid) values (29,10069,10070);
  483. insert into hosts_templates (hosttemplateid,hostid,templateid) values (50,10110,10050);
  484. insert into hosts_templates (hosttemplateid,hostid,templateid) values (51,10110,10069);
  485. insert into hosts_templates (hosttemplateid,hostid,templateid) values (52,10110,10102);
  486. insert into hosts_templates (hosttemplateid,hostid,templateid) values (53,10110,10048);
  487. insert into hosts_templates (hosttemplateid,hostid,templateid) values (54,10110,10104);
  488. insert into hosts_templates (hosttemplateid,hostid,templateid) values (55,10111,10050);
  489. insert into hosts_templates (hosttemplateid,hostid,templateid) values (56,10111,10069);
  490. insert into hosts_templates (hosttemplateid,hostid,templateid) values (57,10111,10102);
  491. insert into hosts_templates (hosttemplateid,hostid,templateid) values (58,10111,10095);
  492. insert into hosts_templates (hosttemplateid,hostid,templateid) values (59,10111,10104);
  493. ]
  494. 18707:20140228:000429.960 End of process_proxyconfig_table():SUCCEED
  495. 18707:20140228:000429.960 In process_proxyconfig_table() table:'hostmacro'
  496. 18707:20140228:000429.960 query [txnlev:1] [select hostmacroid from hostmacro]
  497. 18707:20140228:000429.960 End of process_proxyconfig_table():SUCCEED
  498. 18707:20140228:000429.960 In process_proxyconfig_table() table:'items'
  499. 18707:20140228:000429.960 End of process_proxyconfig_table():FAIL
  500. 18707:20140228:000429.960 failed to update local proxy configuration copy: invalid field name "items.snmpv3_authprotocol"
  501. 18707:20140228:000429.960 query [txnlev:1] [rollback;]
  502. 18712:20140228:000429.961 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  503. 18718:20140228:000429.969 query [txnlev:0] [PRAGMA temp_store = 2]
  504. 18707:20140228:000429.970 End of process_proxyconfig()
  505. 18707:20140228:000429.970 End of process_configuration_sync()
  506. 18707:20140228:000429.970 sleeping for 3600 seconds
  507. 18714:20140228:000429.973 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  508. 18719:20140228:000429.977 query [txnlev:0] [PRAGMA temp_store = 2]
  509. 18713:20140228:000429.979 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  510. 18726:20140228:000429.986 proxy #20 started [history syncer #2]
  511. 18726:20140228:000429.986 In main_dbsyncer_loop() process_num:2
  512. 18726:20140228:000429.986 In DBconnect() flag:0
  513. 18726:20140228:000429.987 query [txnlev:0] [PRAGMA synchronous = 0]
  514. 18724:20140228:000429.987 proxy #18 started [discoverer #1]
  515. 18724:20140228:000429.988 In main_discoverer_loop() process_num:1
  516. 18724:20140228:000429.988 In DBconnect() flag:0
  517. 18724:20140228:000429.988 query [txnlev:0] [PRAGMA synchronous = 0]
  518. 18720:20140228:000429.989 query [txnlev:0] [PRAGMA temp_store = 2]
  519. 18706:20140228:000429.992 proxy #0 started [main process]
  520. 18710:20140228:000429.993 End of DBconnect():0
  521. 18710:20140228:000429.993 In get_values()
  522. 18710:20140228:000429.993 In DCconfig_get_poller_items() poller_type:0
  523. 18710:20140228:000429.997 End of DCconfig_get_poller_items():0
  524. 18710:20140228:000429.997 End of get_values():0
  525. 18710:20140228:000429.997 poller #1 spent 0.004360 seconds while updating 0 values
  526. 18710:20140228:000429.997 In DCconfig_get_poller_nextcheck() poller_type:0
  527. 18710:20140228:000429.997 End of DCconfig_get_poller_nextcheck():-1
  528. 18710:20140228:000429.997 sleeping for 5 seconds
  529. 18723:20140228:000429.997 query [txnlev:0] [PRAGMA temp_store = 2]
  530. 18727:20140228:000429.998 proxy #21 started [history syncer #3]
  531. 18727:20140228:000429.998 In main_dbsyncer_loop() process_num:3
  532. 18727:20140228:000429.999 In DBconnect() flag:0
  533. 18727:20140228:000429.999 query [txnlev:0] [PRAGMA synchronous = 0]
  534. 18728:20140228:000430.000 proxy #22 started [history syncer #4]
  535. 18728:20140228:000430.000 In main_dbsyncer_loop() process_num:4
  536. 18728:20140228:000430.000 In DBconnect() flag:0
  537. 18716:20140228:000430.009 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  538. 18709:20140228:000430.009 End of get_host_availability_data():FAIL
  539. 18709:20140228:000430.009 End of host_availability_sender()
  540. 18709:20140228:000430.009 In history_sender()
  541. 18709:20140228:000430.009 In proxy_get_history_data() table:'proxy_history'
  542. 18709:20140228:000430.009 In proxy_get_lastid() [proxy_history.history_lastid]
  543. 18709:20140228:000430.009 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  544. 18717:20140228:000430.009 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  545. 18715:20140228:000430.010 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  546. 18711:20140228:000430.013 End of DBconnect():0
  547. 18711:20140228:000430.013 In get_values()
  548. 18711:20140228:000430.013 In DCconfig_get_poller_items() poller_type:0
  549. 18711:20140228:000430.013 End of DCconfig_get_poller_items():0
  550. 18711:20140228:000430.013 End of get_values():0
  551. 18711:20140228:000430.013 poller #2 spent 0.000432 seconds while updating 0 values
  552. 18711:20140228:000430.014 In DCconfig_get_poller_nextcheck() poller_type:0
  553. 18711:20140228:000430.014 End of DCconfig_get_poller_nextcheck():-1
  554. 18711:20140228:000430.014 sleeping for 5 seconds
  555. 18728:20140228:000430.014 query [txnlev:0] [PRAGMA synchronous = 0]
  556. 18712:20140228:000430.017 End of DBconnect():0
  557. 18712:20140228:000430.017 In get_values()
  558. 18712:20140228:000430.017 In DCconfig_get_poller_items() poller_type:0
  559. 18718:20140228:000430.017 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  560. 18714:20140228:000430.017 End of DBconnect():0
  561. 18714:20140228:000430.017 In get_values()
  562. 18714:20140228:000430.017 In DCconfig_get_poller_items() poller_type:0
  563. 18714:20140228:000430.017 End of DCconfig_get_poller_items():0
  564. 18714:20140228:000430.017 End of get_values():0
  565. 18714:20140228:000430.017 poller #5 spent 0.000270 seconds while updating 0 values
  566. 18714:20140228:000430.017 In DCconfig_get_poller_nextcheck() poller_type:0
  567. 18714:20140228:000430.018 End of DCconfig_get_poller_nextcheck():-1
  568. 18714:20140228:000430.018 sleeping for 5 seconds
  569. 18719:20140228:000430.018 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  570. 18713:20140228:000430.018 End of DBconnect():0
  571. 18713:20140228:000430.018 In get_values()
  572. 18713:20140228:000430.018 In DCconfig_get_poller_items() poller_type:0
  573. 18713:20140228:000430.018 End of DCconfig_get_poller_items():0
  574. 18713:20140228:000430.018 End of get_values():0
  575. 18713:20140228:000430.018 poller #4 spent 0.000283 seconds while updating 0 values
  576. 18713:20140228:000430.018 In DCconfig_get_poller_nextcheck() poller_type:0
  577. 18713:20140228:000430.018 End of DCconfig_get_poller_nextcheck():-1
  578. 18713:20140228:000430.018 sleeping for 5 seconds
  579. 18712:20140228:000430.021 End of DCconfig_get_poller_items():0
  580. 18712:20140228:000430.021 End of get_values():0
  581. 18712:20140228:000430.021 poller #3 spent 0.004336 seconds while updating 0 values
  582. 18712:20140228:000430.021 In DCconfig_get_poller_nextcheck() poller_type:0
  583. 18712:20140228:000430.021 End of DCconfig_get_poller_nextcheck():-1
  584. 18712:20140228:000430.021 sleeping for 5 seconds
  585. 18722:20140228:000430.029 query [txnlev:0] [PRAGMA temp_store = 2]
  586. 18720:20140228:000430.030 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  587. 18723:20140228:000430.030 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  588. 18726:20140228:000430.033 query [txnlev:0] [PRAGMA temp_store = 2]
  589. 18725:20140228:000430.033 query [txnlev:0] [PRAGMA temp_store = 2]
  590. 18724:20140228:000430.033 query [txnlev:0] [PRAGMA temp_store = 2]
  591. 18716:20140228:000430.035 End of DBconnect():0
  592. 18709:20140228:000430.035 End of proxy_get_lastid():0
  593. 18709:20140228:000430.035 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  594. 18717:20140228:000430.036 End of DBconnect():0
  595. 18715:20140228:000430.036 End of DBconnect():0
  596. 18715:20140228:000430.036 In get_values()
  597. 18715:20140228:000430.036 In DCconfig_get_poller_items() poller_type:1
  598. 18715:20140228:000430.036 End of DCconfig_get_poller_items():0
  599. 18715:20140228:000430.036 End of get_values():0
  600. 18715:20140228:000430.036 unreachable poller #1 spent 0.000295 seconds while updating 0 values
  601. 18715:20140228:000430.036 In DCconfig_get_poller_nextcheck() poller_type:1
  602. 18715:20140228:000430.036 End of DCconfig_get_poller_nextcheck():-1
  603. 18715:20140228:000430.036 sleeping for 5 seconds
  604. 18721:20140228:000430.041 query [txnlev:0] [PRAGMA temp_store = 2]
  605. 18718:20140228:000430.042 End of DBconnect():0
  606. 18719:20140228:000430.042 End of DBconnect():0
  607. 18722:20140228:000430.042 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  608. 18720:20140228:000430.042 End of DBconnect():0
  609. 18723:20140228:000430.042 End of DBconnect():0
  610. 18723:20140228:000430.042 In process_httptests()
  611. 18723:20140228:000430.042 query [txnlev:0] [select t.httptestid,t.name,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<=1393545870 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  612. 18726:20140228:000430.042 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  613. 18725:20140228:000430.043 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  614. 18724:20140228:000430.043 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  615. 18709:20140228:000430.043 End of proxy_get_history_data():0 lastid:0
  616. 18709:20140228:000430.043 End of history_sender()
  617. 18709:20140228:000430.043 In history_sender()
  618. 18709:20140228:000430.043 In proxy_get_history_data() table:'proxy_dhistory'
  619. 18709:20140228:000430.043 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  620. 18709:20140228:000430.043 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  621. 18722:20140228:000430.043 End of DBconnect():0
  622. 18722:20140228:000430.043 In housekeeping_history()
  623. 18722:20140228:000430.043 In delete_history() table:'proxy_history' now:1393545869
  624. 18723:20140228:000430.044 End of process_httptests()
  625. 18723:20140228:000430.044 http poller #1 spent 0.001515 seconds while updating HTTP tests
  626. 18723:20140228:000430.044 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  627. 18726:20140228:000430.044 End of DBconnect():0
  628. 18726:20140228:000430.044 Syncing ...
  629. 18726:20140228:000430.044 In DCsync_history() history_first:0 history_num:0
  630. 18726:20140228:000430.044 history syncer #2 spent 0.000103 seconds while processing 0 items
  631. 18726:20140228:000430.044 sleeping for 5 seconds
  632. 18725:20140228:000430.044 End of DBconnect():0
  633. 18725:20140228:000430.044 Syncing ...
  634. 18725:20140228:000430.045 In DCsync_history() history_first:0 history_num:0
  635. 18725:20140228:000430.045 history syncer #1 spent 0.000096 seconds while processing 0 items
  636. 18725:20140228:000430.045 sleeping for 5 seconds
  637. 18709:20140228:000430.045 End of proxy_get_lastid():0
  638. 18709:20140228:000430.045 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  639. 18722:20140228:000430.045 query [txnlev:1] [begin;]
  640. 18722:20140228:000430.045 query [txnlev:1] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  641. 18722:20140228:000430.045 query [txnlev:1] [rollback;]
  642. 18722:20140228:000430.045 In delete_history() table:'proxy_dhistory' now:1393545869
  643. 18723:20140228:000430.046 No httptests to process in get_minnextcheck.
  644. 18723:20140228:000430.046 sleeping for 5 seconds
  645. 18709:20140228:000430.046 End of proxy_get_history_data():0 lastid:0
  646. 18709:20140228:000430.046 End of history_sender()
  647. 18709:20140228:000430.046 In history_sender()
  648. 18709:20140228:000430.046 In proxy_get_history_data() table:'proxy_autoreg_host'
  649. 18709:20140228:000430.046 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  650. 18709:20140228:000430.046 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  651. 18722:20140228:000430.046 query [txnlev:1] [begin;]
  652. 18722:20140228:000430.046 query [txnlev:1] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  653. 18722:20140228:000430.046 query [txnlev:1] [rollback;]
  654. 18722:20140228:000430.047 In delete_history() table:'proxy_autoreg_host' now:1393545869
  655. 18724:20140228:000430.045 End of DBconnect():0
  656. 18724:20140228:000430.047 query [txnlev:0] [select distinct r.druleid,r.iprange,r.name,c.dcheckid from drules r left join dchecks c on c.druleid=r.druleid and uniq=1 where r.proxy_hostid is null and r.status=0 and (r.nextcheck<=1393545870 or r.nextcheck>1393545870+r.delay) and r.druleid%1=0]
  657. 18721:20140228:000430.047 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  658. 18709:20140228:000430.047 End of proxy_get_lastid():146
  659. 18709:20140228:000430.047 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  660. 18722:20140228:000430.047 query [txnlev:1] [begin;]
  661. 18722:20140228:000430.047 query [txnlev:1] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  662. 18722:20140228:000430.047 query [txnlev:1] [select min(clock) from proxy_autoreg_host]
  663. 18722:20140228:000430.047 query [txnlev:1] [select max(id) from proxy_autoreg_host]
  664. 18722:20140228:000430.047 query [txnlev:1] [delete from proxy_autoreg_host where id<146 and (clock<1393459469 or (id<=146 and clock<1393545869))]
  665. 18722:20140228:000430.048 query [txnlev:1] [commit;]
  666. 18722:20140228:000430.048 housekeeper deleted 4 records from history (spent 0.004573 seconds)
  667. 18722:20140228:000430.049 sleeping for 3599 seconds
  668. 18724:20140228:000430.049 discoverer #1 spent 0.002343 seconds while processing rules
  669. 18724:20140228:000430.049 query [txnlev:0] [select count(*),min(nextcheck) from drules where proxy_hostid is null and status=0 and druleid%1=0]
  670. 18721:20140228:000430.049 End of DBconnect():0
  671. 18721:20140228:000430.049 In get_pinger_hosts()
  672. 18721:20140228:000430.049 In DCconfig_get_poller_items() poller_type:3
  673. 18721:20140228:000430.049 End of DCconfig_get_poller_items():0
  674. 18721:20140228:000430.049 End of get_pinger_hosts():0
  675. 18721:20140228:000430.049 In process_pinger_hosts()
  676. 18721:20140228:000430.050 End of process_pinger_hosts()
  677. 18721:20140228:000430.050 icmp pinger #1 spent 0.000368 seconds while processing 0 items
  678. 18721:20140228:000430.050 In DCconfig_get_poller_nextcheck() poller_type:3
  679. 18721:20140228:000430.050 End of DCconfig_get_poller_nextcheck():-1
  680. 18721:20140228:000430.050 sleeping for 5 seconds
  681. 18709:20140228:000430.050 End of proxy_get_history_data():0 lastid:0
  682. 18709:20140228:000430.050 End of history_sender()
  683. 18709:20140228:000430.050 Datasender spent 0.101204 seconds while processing 0 values.
  684. 18709:20140228:000430.050 sleeping for 1 seconds
  685. 18724:20140228:000430.050 get_minnextcheck(): no items to update
  686. 18724:20140228:000430.050 sleeping for 60 seconds
  687. 18727:20140228:000430.051 query [txnlev:0] [PRAGMA temp_store = 2]
  688. 18727:20140228:000430.051 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  689. 18727:20140228:000430.051 End of DBconnect():0
  690. 18727:20140228:000430.051 Syncing ...
  691. 18727:20140228:000430.051 In DCsync_history() history_first:0 history_num:0
  692. 18727:20140228:000430.051 history syncer #3 spent 0.000098 seconds while processing 0 items
  693. 18727:20140228:000430.051 sleeping for 5 seconds
  694. 18728:20140228:000430.051 query [txnlev:0] [PRAGMA temp_store = 2]
  695. 18728:20140228:000430.051 query [txnlev:0] [PRAGMA temp_store_directory = '/var/lib/zabbix/']
  696. 18728:20140228:000430.051 End of DBconnect():0
  697. 18728:20140228:000430.051 Syncing ...
  698. 18728:20140228:000430.051 In DCsync_history() history_first:0 history_num:0
  699. 18728:20140228:000430.051 history syncer #4 spent 0.000104 seconds while processing 0 items
  700. 18728:20140228:000430.051 sleeping for 5 seconds
  701. 18709:20140228:000431.050 In host_availability_sender()
  702. 18709:20140228:000431.051 In get_host_availability_data()
  703. 18709:20140228:000431.051 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  704. 18709:20140228:000431.051 End of get_host_availability_data():FAIL
  705. 18709:20140228:000431.051 End of host_availability_sender()
  706. 18709:20140228:000431.051 In history_sender()
  707. 18709:20140228:000431.051 In proxy_get_history_data() table:'proxy_history'
  708. 18709:20140228:000431.051 In proxy_get_lastid() [proxy_history.history_lastid]
  709. 18709:20140228:000431.051 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  710. 18709:20140228:000431.051 End of proxy_get_lastid():0
  711. 18709:20140228:000431.051 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  712. 18709:20140228:000431.052 End of proxy_get_history_data():0 lastid:0
  713. 18709:20140228:000431.052 End of history_sender()
  714. 18709:20140228:000431.052 In history_sender()
  715. 18709:20140228:000431.052 In proxy_get_history_data() table:'proxy_dhistory'
  716. 18709:20140228:000431.052 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  717. 18709:20140228:000431.052 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  718. 18709:20140228:000431.052 End of proxy_get_lastid():0
  719. 18709:20140228:000431.052 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  720. 18709:20140228:000431.052 End of proxy_get_history_data():0 lastid:0
  721. 18709:20140228:000431.052 End of history_sender()
  722. 18709:20140228:000431.052 In history_sender()
  723. 18709:20140228:000431.053 In proxy_get_history_data() table:'proxy_autoreg_host'
  724. 18709:20140228:000431.053 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  725. 18709:20140228:000431.053 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  726. 18709:20140228:000431.053 End of proxy_get_lastid():146
  727. 18709:20140228:000431.053 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  728. 18709:20140228:000431.053 End of proxy_get_history_data():0 lastid:0
  729. 18709:20140228:000431.053 End of history_sender()
  730. 18709:20140228:000431.053 Datasender spent 0.002808 seconds while processing 0 values.
  731. 18709:20140228:000431.053 sleeping for 1 seconds
  732. 18709:20140228:000432.053 In host_availability_sender()
  733. 18709:20140228:000432.054 In get_host_availability_data()
  734. 18709:20140228:000432.054 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  735. 18709:20140228:000432.054 End of get_host_availability_data():FAIL
  736. 18709:20140228:000432.054 End of host_availability_sender()
  737. 18709:20140228:000432.054 In history_sender()
  738. 18709:20140228:000432.054 In proxy_get_history_data() table:'proxy_history'
  739. 18709:20140228:000432.054 In proxy_get_lastid() [proxy_history.history_lastid]
  740. 18709:20140228:000432.054 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  741. 18709:20140228:000432.054 End of proxy_get_lastid():0
  742. 18709:20140228:000432.054 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  743. 18709:20140228:000432.055 End of proxy_get_history_data():0 lastid:0
  744. 18709:20140228:000432.055 End of history_sender()
  745. 18709:20140228:000432.055 In history_sender()
  746. 18709:20140228:000432.055 In proxy_get_history_data() table:'proxy_dhistory'
  747. 18709:20140228:000432.055 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  748. 18709:20140228:000432.055 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  749. 18709:20140228:000432.055 End of proxy_get_lastid():0
  750. 18709:20140228:000432.055 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  751. 18709:20140228:000432.055 End of proxy_get_history_data():0 lastid:0
  752. 18709:20140228:000432.055 End of history_sender()
  753. 18709:20140228:000432.055 In history_sender()
  754. 18709:20140228:000432.055 In proxy_get_history_data() table:'proxy_autoreg_host'
  755. 18709:20140228:000432.055 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  756. 18709:20140228:000432.056 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  757. 18709:20140228:000432.056 End of proxy_get_lastid():146
  758. 18709:20140228:000432.056 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  759. 18709:20140228:000432.056 End of proxy_get_history_data():0 lastid:0
  760. 18709:20140228:000432.056 End of history_sender()
  761. 18709:20140228:000432.056 Datasender spent 0.002618 seconds while processing 0 values.
  762. 18709:20140228:000432.056 sleeping for 1 seconds
  763. 18709:20140228:000433.056 In host_availability_sender()
  764. 18709:20140228:000433.056 In get_host_availability_data()
  765. 18709:20140228:000433.056 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  766. 18709:20140228:000433.057 End of get_host_availability_data():FAIL
  767. 18709:20140228:000433.057 End of host_availability_sender()
  768. 18709:20140228:000433.057 In history_sender()
  769. 18709:20140228:000433.057 In proxy_get_history_data() table:'proxy_history'
  770. 18709:20140228:000433.057 In proxy_get_lastid() [proxy_history.history_lastid]
  771. 18709:20140228:000433.057 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  772. 18709:20140228:000433.057 End of proxy_get_lastid():0
  773. 18709:20140228:000433.057 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  774. 18709:20140228:000433.057 End of proxy_get_history_data():0 lastid:0
  775. 18709:20140228:000433.057 End of history_sender()
  776. 18709:20140228:000433.058 In history_sender()
  777. 18709:20140228:000433.058 In proxy_get_history_data() table:'proxy_dhistory'
  778. 18709:20140228:000433.058 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  779. 18709:20140228:000433.058 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  780. 18709:20140228:000433.058 End of proxy_get_lastid():0
  781. 18709:20140228:000433.058 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  782. 18709:20140228:000433.058 End of proxy_get_history_data():0 lastid:0
  783. 18709:20140228:000433.058 End of history_sender()
  784. 18709:20140228:000433.058 In history_sender()
  785. 18709:20140228:000433.058 In proxy_get_history_data() table:'proxy_autoreg_host'
  786. 18709:20140228:000433.058 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  787. 18709:20140228:000433.058 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  788. 18709:20140228:000433.058 End of proxy_get_lastid():146
  789. 18709:20140228:000433.058 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  790. 18709:20140228:000433.059 End of proxy_get_history_data():0 lastid:0
  791. 18709:20140228:000433.059 End of history_sender()
  792. 18709:20140228:000433.059 Datasender spent 0.002510 seconds while processing 0 values.
  793. 18709:20140228:000433.059 sleeping for 1 seconds
  794. 18709:20140228:000434.059 In host_availability_sender()
  795. 18709:20140228:000434.059 In get_host_availability_data()
  796. 18709:20140228:000434.059 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  797. 18709:20140228:000434.059 End of get_host_availability_data():FAIL
  798. 18709:20140228:000434.060 End of host_availability_sender()
  799. 18709:20140228:000434.060 In history_sender()
  800. 18709:20140228:000434.060 In proxy_get_history_data() table:'proxy_history'
  801. 18709:20140228:000434.060 In proxy_get_lastid() [proxy_history.history_lastid]
  802. 18709:20140228:000434.060 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  803. 18709:20140228:000434.060 End of proxy_get_lastid():0
  804. 18709:20140228:000434.060 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  805. 18709:20140228:000434.060 End of proxy_get_history_data():0 lastid:0
  806. 18709:20140228:000434.060 End of history_sender()
  807. 18709:20140228:000434.060 In history_sender()
  808. 18709:20140228:000434.060 In proxy_get_history_data() table:'proxy_dhistory'
  809. 18709:20140228:000434.060 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  810. 18709:20140228:000434.060 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  811. 18709:20140228:000434.061 End of proxy_get_lastid():0
  812. 18709:20140228:000434.061 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  813. 18709:20140228:000434.061 End of proxy_get_history_data():0 lastid:0
  814. 18709:20140228:000434.061 End of history_sender()
  815. 18709:20140228:000434.061 In history_sender()
  816. 18709:20140228:000434.061 In proxy_get_history_data() table:'proxy_autoreg_host'
  817. 18709:20140228:000434.061 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  818. 18709:20140228:000434.061 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  819. 18709:20140228:000434.061 End of proxy_get_lastid():146
  820. 18709:20140228:000434.061 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  821. 18709:20140228:000434.061 End of proxy_get_history_data():0 lastid:0
  822. 18709:20140228:000434.061 End of history_sender()
  823. 18709:20140228:000434.062 Datasender spent 0.002562 seconds while processing 0 values.
  824. 18709:20140228:000434.062 sleeping for 1 seconds
  825. 18710:20140228:000434.998 In get_values()
  826. 18710:20140228:000434.998 In DCconfig_get_poller_items() poller_type:0
  827. 18710:20140228:000434.998 End of DCconfig_get_poller_items():0
  828. 18710:20140228:000434.998 End of get_values():0
  829. 18710:20140228:000434.998 poller #1 spent 0.000434 seconds while updating 0 values
  830. 18710:20140228:000434.998 In DCconfig_get_poller_nextcheck() poller_type:0
  831. 18710:20140228:000434.999 End of DCconfig_get_poller_nextcheck():-1
  832. 18710:20140228:000434.999 sleeping for 5 seconds
  833. 18711:20140228:000435.014 In get_values()
  834. 18711:20140228:000435.015 In DCconfig_get_poller_items() poller_type:0
  835. 18711:20140228:000435.015 End of DCconfig_get_poller_items():0
  836. 18711:20140228:000435.015 End of get_values():0
  837. 18711:20140228:000435.015 poller #2 spent 0.000407 seconds while updating 0 values
  838. 18711:20140228:000435.015 In DCconfig_get_poller_nextcheck() poller_type:0
  839. 18711:20140228:000435.015 End of DCconfig_get_poller_nextcheck():-1
  840. 18711:20140228:000435.015 sleeping for 5 seconds
  841. 18714:20140228:000435.018 In get_values()
  842. 18714:20140228:000435.018 In DCconfig_get_poller_items() poller_type:0
  843. 18714:20140228:000435.018 End of DCconfig_get_poller_items():0
  844. 18714:20140228:000435.018 End of get_values():0
  845. 18714:20140228:000435.019 poller #5 spent 0.000339 seconds while updating 0 values
  846. 18714:20140228:000435.019 In DCconfig_get_poller_nextcheck() poller_type:0
  847. 18714:20140228:000435.019 End of DCconfig_get_poller_nextcheck():-1
  848. 18714:20140228:000435.019 sleeping for 5 seconds
  849. 18713:20140228:000435.019 In get_values()
  850. 18713:20140228:000435.019 In DCconfig_get_poller_items() poller_type:0
  851. 18713:20140228:000435.019 End of DCconfig_get_poller_items():0
  852. 18713:20140228:000435.019 End of get_values():0
  853. 18713:20140228:000435.019 poller #4 spent 0.000296 seconds while updating 0 values
  854. 18713:20140228:000435.019 In DCconfig_get_poller_nextcheck() poller_type:0
  855. 18713:20140228:000435.019 End of DCconfig_get_poller_nextcheck():-1
  856. 18713:20140228:000435.019 sleeping for 5 seconds
  857. 18712:20140228:000435.022 In get_values()
  858. 18712:20140228:000435.022 In DCconfig_get_poller_items() poller_type:0
  859. 18712:20140228:000435.022 End of DCconfig_get_poller_items():0
  860. 18712:20140228:000435.022 End of get_values():0
  861. 18712:20140228:000435.022 poller #3 spent 0.000236 seconds while updating 0 values
  862. 18712:20140228:000435.022 In DCconfig_get_poller_nextcheck() poller_type:0
  863. 18712:20140228:000435.022 End of DCconfig_get_poller_nextcheck():-1
  864. 18712:20140228:000435.022 sleeping for 5 seconds
  865. 18715:20140228:000435.037 In get_values()
  866. 18715:20140228:000435.037 In DCconfig_get_poller_items() poller_type:1
  867. 18715:20140228:000435.037 End of DCconfig_get_poller_items():0
  868. 18715:20140228:000435.037 End of get_values():0
  869. 18715:20140228:000435.037 unreachable poller #1 spent 0.000334 seconds while updating 0 values
  870. 18715:20140228:000435.037 In DCconfig_get_poller_nextcheck() poller_type:1
  871. 18715:20140228:000435.037 End of DCconfig_get_poller_nextcheck():-1
  872. 18715:20140228:000435.037 sleeping for 5 seconds
  873. 18726:20140228:000435.045 Syncing ...
  874. 18726:20140228:000435.045 In DCsync_history() history_first:0 history_num:0
  875. 18726:20140228:000435.045 history syncer #2 spent 0.000067 seconds while processing 0 items
  876. 18726:20140228:000435.045 sleeping for 5 seconds
  877. 18725:20140228:000435.045 Syncing ...
  878. 18725:20140228:000435.045 In DCsync_history() history_first:0 history_num:0
  879. 18725:20140228:000435.045 history syncer #1 spent 0.000055 seconds while processing 0 items
  880. 18725:20140228:000435.045 sleeping for 5 seconds
  881. 18723:20140228:000435.046 In process_httptests()
  882. 18723:20140228:000435.046 query [txnlev:0] [select t.httptestid,t.name,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<=1393545875 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  883. 18723:20140228:000435.047 End of process_httptests()
  884. 18723:20140228:000435.047 http poller #1 spent 0.000536 seconds while updating HTTP tests
  885. 18723:20140228:000435.047 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  886. 18723:20140228:000435.047 No httptests to process in get_minnextcheck.
  887. 18723:20140228:000435.047 sleeping for 5 seconds
  888. 18721:20140228:000435.050 In get_pinger_hosts()
  889. 18721:20140228:000435.050 In DCconfig_get_poller_items() poller_type:3
  890. 18721:20140228:000435.050 End of DCconfig_get_poller_items():0
  891. 18721:20140228:000435.050 End of get_pinger_hosts():0
  892. 18721:20140228:000435.050 In process_pinger_hosts()
  893. 18721:20140228:000435.050 End of process_pinger_hosts()
  894. 18721:20140228:000435.051 icmp pinger #1 spent 0.000299 seconds while processing 0 items
  895. 18721:20140228:000435.051 In DCconfig_get_poller_nextcheck() poller_type:3
  896. 18721:20140228:000435.051 End of DCconfig_get_poller_nextcheck():-1
  897. 18721:20140228:000435.051 sleeping for 5 seconds
  898. 18727:20140228:000435.053 Syncing ...
  899. 18727:20140228:000435.053 In DCsync_history() history_first:0 history_num:0
  900. 18727:20140228:000435.053 history syncer #3 spent 0.000060 seconds while processing 0 items
  901. 18727:20140228:000435.053 sleeping for 5 seconds
  902. 18728:20140228:000435.054 Syncing ...
  903. 18728:20140228:000435.054 In DCsync_history() history_first:0 history_num:0
  904. 18728:20140228:000435.054 history syncer #4 spent 0.000059 seconds while processing 0 items
  905. 18728:20140228:000435.054 sleeping for 5 seconds
  906. 18709:20140228:000435.062 In host_availability_sender()
  907. 18709:20140228:000435.062 In get_host_availability_data()
  908. 18709:20140228:000435.062 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  909. 18709:20140228:000435.062 End of get_host_availability_data():FAIL
  910. 18709:20140228:000435.062 End of host_availability_sender()
  911. 18709:20140228:000435.062 In history_sender()
  912. 18709:20140228:000435.062 In proxy_get_history_data() table:'proxy_history'
  913. 18709:20140228:000435.062 In proxy_get_lastid() [proxy_history.history_lastid]
  914. 18709:20140228:000435.062 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  915. 18709:20140228:000435.062 End of proxy_get_lastid():0
  916. 18709:20140228:000435.063 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  917. 18709:20140228:000435.063 End of proxy_get_history_data():0 lastid:0
  918. 18709:20140228:000435.063 End of history_sender()
  919. 18709:20140228:000435.063 In history_sender()
  920. 18709:20140228:000435.063 In proxy_get_history_data() table:'proxy_dhistory'
  921. 18709:20140228:000435.063 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  922. 18709:20140228:000435.063 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  923. 18709:20140228:000435.063 End of proxy_get_lastid():0
  924. 18709:20140228:000435.063 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  925. 18709:20140228:000435.064 End of proxy_get_history_data():0 lastid:0
  926. 18709:20140228:000435.064 End of history_sender()
  927. 18709:20140228:000435.064 In history_sender()
  928. 18709:20140228:000435.064 In proxy_get_history_data() table:'proxy_autoreg_host'
  929. 18709:20140228:000435.064 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  930. 18709:20140228:000435.064 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  931. 18709:20140228:000435.064 End of proxy_get_lastid():146
  932. 18709:20140228:000435.064 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  933. 18709:20140228:000435.064 End of proxy_get_history_data():0 lastid:0
  934. 18709:20140228:000435.065 End of history_sender()
  935. 18709:20140228:000435.065 Datasender spent 0.002904 seconds while processing 0 values.
  936. 18709:20140228:000435.065 sleeping for 1 seconds
  937. 18709:20140228:000436.065 In host_availability_sender()
  938. 18709:20140228:000436.065 In get_host_availability_data()
  939. 18709:20140228:000436.065 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  940. 18709:20140228:000436.065 End of get_host_availability_data():FAIL
  941. 18709:20140228:000436.065 End of host_availability_sender()
  942. 18709:20140228:000436.065 In history_sender()
  943. 18709:20140228:000436.066 In proxy_get_history_data() table:'proxy_history'
  944. 18709:20140228:000436.066 In proxy_get_lastid() [proxy_history.history_lastid]
  945. 18709:20140228:000436.066 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  946. 18709:20140228:000436.066 End of proxy_get_lastid():0
  947. 18709:20140228:000436.066 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  948. 18709:20140228:000436.066 End of proxy_get_history_data():0 lastid:0
  949. 18709:20140228:000436.066 End of history_sender()
  950. 18709:20140228:000436.066 In history_sender()
  951. 18709:20140228:000436.066 In proxy_get_history_data() table:'proxy_dhistory'
  952. 18709:20140228:000436.066 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  953. 18709:20140228:000436.066 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  954. 18709:20140228:000436.066 End of proxy_get_lastid():0
  955. 18709:20140228:000436.067 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  956. 18709:20140228:000436.067 End of proxy_get_history_data():0 lastid:0
  957. 18709:20140228:000436.067 End of history_sender()
  958. 18709:20140228:000436.067 In history_sender()
  959. 18709:20140228:000436.067 In proxy_get_history_data() table:'proxy_autoreg_host'
  960. 18709:20140228:000436.067 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  961. 18709:20140228:000436.067 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  962. 18709:20140228:000436.067 End of proxy_get_lastid():146
  963. 18709:20140228:000436.067 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  964. 18709:20140228:000436.068 End of proxy_get_history_data():0 lastid:0
  965. 18709:20140228:000436.068 End of history_sender()
  966. 18709:20140228:000436.068 Datasender spent 0.002837 seconds while processing 0 values.
  967. 18709:20140228:000436.068 sleeping for 1 seconds
  968. 18709:20140228:000437.068 In host_availability_sender()
  969. 18709:20140228:000437.068 In get_host_availability_data()
  970. 18709:20140228:000437.068 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  971. 18709:20140228:000437.069 End of get_host_availability_data():FAIL
  972. 18709:20140228:000437.069 End of host_availability_sender()
  973. 18709:20140228:000437.069 In history_sender()
  974. 18709:20140228:000437.069 In proxy_get_history_data() table:'proxy_history'
  975. 18709:20140228:000437.069 In proxy_get_lastid() [proxy_history.history_lastid]
  976. 18709:20140228:000437.069 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  977. 18709:20140228:000437.069 End of proxy_get_lastid():0
  978. 18709:20140228:000437.069 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  979. 18709:20140228:000437.069 End of proxy_get_history_data():0 lastid:0
  980. 18709:20140228:000437.069 End of history_sender()
  981. 18709:20140228:000437.069 In history_sender()
  982. 18709:20140228:000437.069 In proxy_get_history_data() table:'proxy_dhistory'
  983. 18709:20140228:000437.069 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  984. 18709:20140228:000437.069 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  985. 18709:20140228:000437.070 End of proxy_get_lastid():0
  986. 18709:20140228:000437.070 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  987. 18709:20140228:000437.070 End of proxy_get_history_data():0 lastid:0
  988. 18709:20140228:000437.070 End of history_sender()
  989. 18709:20140228:000437.070 In history_sender()
  990. 18709:20140228:000437.070 In proxy_get_history_data() table:'proxy_autoreg_host'
  991. 18709:20140228:000437.070 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  992. 18709:20140228:000437.070 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  993. 18709:20140228:000437.070 End of proxy_get_lastid():146
  994. 18709:20140228:000437.070 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  995. 18709:20140228:000437.070 End of proxy_get_history_data():0 lastid:0
  996. 18709:20140228:000437.071 End of history_sender()
  997. 18709:20140228:000437.071 Datasender spent 0.002599 seconds while processing 0 values.
  998. 18709:20140228:000437.071 sleeping for 1 seconds
  999. 18709:20140228:000438.071 In host_availability_sender()
  1000. 18709:20140228:000438.087 In get_host_availability_data()
  1001. 18709:20140228:000438.087 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1002. 18709:20140228:000438.087 End of get_host_availability_data():FAIL
  1003. 18709:20140228:000438.087 End of host_availability_sender()
  1004. 18709:20140228:000438.087 In history_sender()
  1005. 18709:20140228:000438.087 In proxy_get_history_data() table:'proxy_history'
  1006. 18709:20140228:000438.087 In proxy_get_lastid() [proxy_history.history_lastid]
  1007. 18709:20140228:000438.087 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1008. 18709:20140228:000438.087 End of proxy_get_lastid():0
  1009. 18709:20140228:000438.087 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1010. 18709:20140228:000438.088 End of proxy_get_history_data():0 lastid:0
  1011. 18709:20140228:000438.088 End of history_sender()
  1012. 18709:20140228:000438.088 In history_sender()
  1013. 18709:20140228:000438.088 In proxy_get_history_data() table:'proxy_dhistory'
  1014. 18709:20140228:000438.088 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1015. 18709:20140228:000438.088 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1016. 18709:20140228:000438.088 End of proxy_get_lastid():0
  1017. 18709:20140228:000438.088 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1018. 18709:20140228:000438.088 End of proxy_get_history_data():0 lastid:0
  1019. 18709:20140228:000438.088 End of history_sender()
  1020. 18709:20140228:000438.088 In history_sender()
  1021. 18709:20140228:000438.088 In proxy_get_history_data() table:'proxy_autoreg_host'
  1022. 18709:20140228:000438.088 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1023. 18709:20140228:000438.089 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1024. 18709:20140228:000438.089 End of proxy_get_lastid():146
  1025. 18709:20140228:000438.089 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  1026. 18709:20140228:000438.089 End of proxy_get_history_data():0 lastid:0
  1027. 18709:20140228:000438.089 End of history_sender()
  1028. 18709:20140228:000438.089 Datasender spent 0.018209 seconds while processing 0 values.
  1029. 18709:20140228:000438.089 sleeping for 1 seconds
  1030. 18709:20140228:000439.089 In host_availability_sender()
  1031. 18709:20140228:000439.089 In get_host_availability_data()
  1032. 18709:20140228:000439.090 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1033. 18709:20140228:000439.090 End of get_host_availability_data():FAIL
  1034. 18709:20140228:000439.090 End of host_availability_sender()
  1035. 18709:20140228:000439.090 In history_sender()
  1036. 18709:20140228:000439.090 In proxy_get_history_data() table:'proxy_history'
  1037. 18709:20140228:000439.090 In proxy_get_lastid() [proxy_history.history_lastid]
  1038. 18709:20140228:000439.090 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1039. 18709:20140228:000439.090 End of proxy_get_lastid():0
  1040. 18709:20140228:000439.091 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1041. 18709:20140228:000439.091 End of proxy_get_history_data():0 lastid:0
  1042. 18709:20140228:000439.091 End of history_sender()
  1043. 18709:20140228:000439.091 In history_sender()
  1044. 18709:20140228:000439.091 In proxy_get_history_data() table:'proxy_dhistory'
  1045. 18709:20140228:000439.091 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1046. 18709:20140228:000439.091 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1047. 18709:20140228:000439.091 End of proxy_get_lastid():0
  1048. 18709:20140228:000439.092 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1049. 18709:20140228:000439.092 End of proxy_get_history_data():0 lastid:0
  1050. 18709:20140228:000439.092 End of history_sender()
  1051. 18709:20140228:000439.092 In history_sender()
  1052. 18709:20140228:000439.092 In proxy_get_history_data() table:'proxy_autoreg_host'
  1053. 18709:20140228:000439.092 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1054. 18709:20140228:000439.092 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1055. 18709:20140228:000439.092 End of proxy_get_lastid():146
  1056. 18709:20140228:000439.092 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  1057. 18709:20140228:000439.093 End of proxy_get_history_data():0 lastid:0
  1058. 18709:20140228:000439.093 End of history_sender()
  1059. 18709:20140228:000439.093 Datasender spent 0.003530 seconds while processing 0 values.
  1060. 18709:20140228:000439.093 sleeping for 1 seconds
  1061. 18720:20140228:000439.664 Trapper got [{
  1062. "request":"active checks",
  1063. "host":"prodBETA-mon-master"}] len 60
  1064. 18720:20140228:000439.664 In send_list_of_active_checks_json()
  1065. 18720:20140228:000439.664 In get_hostid_by_host() host:'prodBETA-mon-master'
  1066. 18720:20140228:000439.664 query [txnlev:0] [select hostid,status from hosts where host='prodBETA-mon-master' and status in (0,1) and proxy_hostid is null]
  1067. 18720:20140228:000439.667 query [txnlev:1] [begin;]
  1068. 18720:20140228:000439.667 query [txnlev:1] [insert into proxy_autoreg_host (clock,host,listen_ip,listen_dns,listen_port) values (1393545879,'prodBETA-mon-master','10.185.3.248','ip-10-185-3-248.ec2.internal',10050)]
  1069. 18720:20140228:000439.667 query [txnlev:1] [commit;]
  1070. 18720:20140228:000439.667 End of get_hostid_by_host():FAIL
  1071. 18720:20140228:000439.667 cannot send list of active checks to [10.185.3.248]: host [prodBETA-mon-master] not found
  1072. 18720:20140228:000439.667 send_list_of_active_checks_json() sending [{
  1073. "response":"failed",
  1074. "info":"host [prodBETA-mon-master] not found"}]
  1075. 18720:20140228:000439.668 End of send_list_of_active_checks_json():SUCCEED
  1076. 18710:20140228:000439.999 In get_values()
  1077. 18710:20140228:000439.999 In DCconfig_get_poller_items() poller_type:0
  1078. 18710:20140228:000439.999 End of DCconfig_get_poller_items():0
  1079. 18710:20140228:000439.999 End of get_values():0
  1080. 18710:20140228:000440.000 poller #1 spent 0.000329 seconds while updating 0 values
  1081. 18710:20140228:000440.000 In DCconfig_get_poller_nextcheck() poller_type:0
  1082. 18710:20140228:000440.000 End of DCconfig_get_poller_nextcheck():-1
  1083. 18710:20140228:000440.000 sleeping for 5 seconds
  1084. 18711:20140228:000440.016 In get_values()
  1085. 18711:20140228:000440.016 In DCconfig_get_poller_items() poller_type:0
  1086. 18711:20140228:000440.016 End of DCconfig_get_poller_items():0
  1087. 18711:20140228:000440.016 End of get_values():0
  1088. 18711:20140228:000440.016 poller #2 spent 0.000315 seconds while updating 0 values
  1089. 18711:20140228:000440.016 In DCconfig_get_poller_nextcheck() poller_type:0
  1090. 18711:20140228:000440.016 End of DCconfig_get_poller_nextcheck():-1
  1091. 18711:20140228:000440.016 sleeping for 5 seconds
  1092. 18714:20140228:000440.019 In get_values()
  1093. 18714:20140228:000440.019 In DCconfig_get_poller_items() poller_type:0
  1094. 18714:20140228:000440.019 End of DCconfig_get_poller_items():0
  1095. 18714:20140228:000440.019 End of get_values():0
  1096. 18714:20140228:000440.019 poller #5 spent 0.000209 seconds while updating 0 values
  1097. 18714:20140228:000440.020 In DCconfig_get_poller_nextcheck() poller_type:0
  1098. 18714:20140228:000440.020 End of DCconfig_get_poller_nextcheck():-1
  1099. 18714:20140228:000440.020 sleeping for 5 seconds
  1100. 18713:20140228:000440.020 In get_values()
  1101. 18713:20140228:000440.020 In DCconfig_get_poller_items() poller_type:0
  1102. 18713:20140228:000440.020 End of DCconfig_get_poller_items():0
  1103. 18713:20140228:000440.020 End of get_values():0
  1104. 18713:20140228:000440.020 poller #4 spent 0.000206 seconds while updating 0 values
  1105. 18713:20140228:000440.020 In DCconfig_get_poller_nextcheck() poller_type:0
  1106. 18713:20140228:000440.020 End of DCconfig_get_poller_nextcheck():-1
  1107. 18713:20140228:000440.020 sleeping for 5 seconds
  1108. 18712:20140228:000440.023 In get_values()
  1109. 18712:20140228:000440.023 In DCconfig_get_poller_items() poller_type:0
  1110. 18712:20140228:000440.023 End of DCconfig_get_poller_items():0
  1111. 18712:20140228:000440.023 End of get_values():0
  1112. 18712:20140228:000440.023 poller #3 spent 0.000209 seconds while updating 0 values
  1113. 18712:20140228:000440.023 In DCconfig_get_poller_nextcheck() poller_type:0
  1114. 18712:20140228:000440.023 End of DCconfig_get_poller_nextcheck():-1
  1115. 18712:20140228:000440.023 sleeping for 5 seconds
  1116. 18715:20140228:000440.038 In get_values()
  1117. 18715:20140228:000440.038 In DCconfig_get_poller_items() poller_type:1
  1118. 18715:20140228:000440.038 End of DCconfig_get_poller_items():0
  1119. 18715:20140228:000440.038 End of get_values():0
  1120. 18715:20140228:000440.038 unreachable poller #1 spent 0.000240 seconds while updating 0 values
  1121. 18715:20140228:000440.038 In DCconfig_get_poller_nextcheck() poller_type:1
  1122. 18715:20140228:000440.038 End of DCconfig_get_poller_nextcheck():-1
  1123. 18715:20140228:000440.038 sleeping for 5 seconds
  1124. 18726:20140228:000440.046 Syncing ...
  1125. 18726:20140228:000440.046 In DCsync_history() history_first:0 history_num:0
  1126. 18726:20140228:000440.046 history syncer #2 spent 0.000057 seconds while processing 0 items
  1127. 18726:20140228:000440.046 sleeping for 5 seconds
  1128. 18725:20140228:000440.046 Syncing ...
  1129. 18725:20140228:000440.046 In DCsync_history() history_first:0 history_num:0
  1130. 18725:20140228:000440.046 history syncer #1 spent 0.000060 seconds while processing 0 items
  1131. 18725:20140228:000440.046 sleeping for 5 seconds
  1132. 18723:20140228:000440.047 In process_httptests()
  1133. 18723:20140228:000440.048 query [txnlev:0] [select t.httptestid,t.name,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<=1393545880 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  1134. 18723:20140228:000440.048 End of process_httptests()
  1135. 18723:20140228:000440.048 http poller #1 spent 0.000513 seconds while updating HTTP tests
  1136. 18723:20140228:000440.048 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  1137. 18723:20140228:000440.048 No httptests to process in get_minnextcheck.
  1138. 18723:20140228:000440.048 sleeping for 5 seconds
  1139. 18721:20140228:000440.053 In get_pinger_hosts()
  1140. 18721:20140228:000440.053 In DCconfig_get_poller_items() poller_type:3
  1141. 18721:20140228:000440.053 End of DCconfig_get_poller_items():0
  1142. 18721:20140228:000440.053 End of get_pinger_hosts():0
  1143. 18721:20140228:000440.053 In process_pinger_hosts()
  1144. 18721:20140228:000440.053 End of process_pinger_hosts()
  1145. 18721:20140228:000440.053 icmp pinger #1 spent 0.000406 seconds while processing 0 items
  1146. 18721:20140228:000440.053 In DCconfig_get_poller_nextcheck() poller_type:3
  1147. 18721:20140228:000440.053 End of DCconfig_get_poller_nextcheck():-1
  1148. 18721:20140228:000440.053 sleeping for 5 seconds
  1149. 18727:20140228:000440.054 Syncing ...
  1150. 18727:20140228:000440.054 In DCsync_history() history_first:0 history_num:0
  1151. 18727:20140228:000440.054 history syncer #3 spent 0.000051 seconds while processing 0 items
  1152. 18727:20140228:000440.054 sleeping for 5 seconds
  1153. 18728:20140228:000440.054 Syncing ...
  1154. 18728:20140228:000440.054 In DCsync_history() history_first:0 history_num:0
  1155. 18728:20140228:000440.054 history syncer #4 spent 0.000047 seconds while processing 0 items
  1156. 18728:20140228:000440.054 sleeping for 5 seconds
  1157. 18709:20140228:000440.093 In host_availability_sender()
  1158. 18709:20140228:000440.093 In get_host_availability_data()
  1159. 18709:20140228:000440.093 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1160. 18709:20140228:000440.093 End of get_host_availability_data():FAIL
  1161. 18709:20140228:000440.094 End of host_availability_sender()
  1162. 18709:20140228:000440.094 In history_sender()
  1163. 18709:20140228:000440.094 In proxy_get_history_data() table:'proxy_history'
  1164. 18709:20140228:000440.094 In proxy_get_lastid() [proxy_history.history_lastid]
  1165. 18709:20140228:000440.094 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1166. 18709:20140228:000440.094 End of proxy_get_lastid():0
  1167. 18709:20140228:000440.094 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1168. 18709:20140228:000440.094 End of proxy_get_history_data():0 lastid:0
  1169. 18709:20140228:000440.094 End of history_sender()
  1170. 18709:20140228:000440.094 In history_sender()
  1171. 18709:20140228:000440.094 In proxy_get_history_data() table:'proxy_dhistory'
  1172. 18709:20140228:000440.094 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1173. 18709:20140228:000440.094 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1174. 18709:20140228:000440.095 End of proxy_get_lastid():0
  1175. 18709:20140228:000440.095 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1176. 18709:20140228:000440.097 End of proxy_get_history_data():0 lastid:0
  1177. 18709:20140228:000440.097 End of history_sender()
  1178. 18709:20140228:000440.098 In history_sender()
  1179. 18709:20140228:000440.098 In proxy_get_history_data() table:'proxy_autoreg_host'
  1180. 18709:20140228:000440.098 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1181. 18709:20140228:000440.098 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1182. 18709:20140228:000440.099 End of proxy_get_lastid():146
  1183. 18709:20140228:000440.099 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>146 order by p.id limit 1000]
  1184. 18709:20140228:000440.099 End of proxy_get_history_data():1 lastid:147
  1185. 18709:20140228:000440.100 In connect_to_server() [10.168.24.153]:10051 [timeout:600]
  1186. 18709:20140228:000440.101 In put_data_to_server() datalen:241
  1187. 18709:20140228:000440.102 In send_data_to_server() [{
  1188. "request":"auto registration",
  1189. "host":"prodBETA-mon-master",
  1190. "data":[
  1191. {
  1192. "clock":1393545879,
  1193. "host":"prodBETA-mon-master",
  1194. "ip":"10.185.3.248",
  1195. "dns":"ip-10-185-3-248.ec2.internal",
  1196. "port":"10050"}],
  1197. "clock":1393545880}]
  1198. 18709:20140228:000440.102 In zbx_recv_response()
  1199. 18709:20140228:000440.170 zbx_recv_response() '{
  1200. "response":"success"}'
  1201. 18709:20140228:000440.170 End of zbx_recv_response():SUCCEED
  1202. 18709:20140228:000440.171 End of put_data_to_server():SUCCEED
  1203. 18709:20140228:000440.171 query [txnlev:1] [begin;]
  1204. 18709:20140228:000440.171 In proxy_set_lastid() [proxy_autoreg_host.autoreg_host_lastid:147]
  1205. 18709:20140228:000440.172 query [txnlev:1] [select 1 from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1206. 18709:20140228:000440.172 query [txnlev:1] [update ids set nextid=147 where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1207. 18709:20140228:000440.172 End of proxy_set_lastid()
  1208. 18709:20140228:000440.173 query [txnlev:1] [commit;]
  1209. 18709:20140228:000440.173 End of history_sender()
  1210. 18709:20140228:000440.173 Datasender spent 0.080257 seconds while processing 1 values.
  1211. 18709:20140228:000440.174 sleeping for 1 seconds
  1212. 18709:20140228:000441.174 In host_availability_sender()
  1213. 18709:20140228:000441.174 In get_host_availability_data()
  1214. 18709:20140228:000441.175 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1215. 18709:20140228:000441.175 End of get_host_availability_data():FAIL
  1216. 18709:20140228:000441.175 End of host_availability_sender()
  1217. 18709:20140228:000441.176 In history_sender()
  1218. 18709:20140228:000441.176 In proxy_get_history_data() table:'proxy_history'
  1219. 18709:20140228:000441.176 In proxy_get_lastid() [proxy_history.history_lastid]
  1220. 18709:20140228:000441.176 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1221. 18709:20140228:000441.177 End of proxy_get_lastid():0
  1222. 18709:20140228:000441.177 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1223. 18709:20140228:000441.177 End of proxy_get_history_data():0 lastid:0
  1224. 18709:20140228:000441.178 End of history_sender()
  1225. 18709:20140228:000441.178 In history_sender()
  1226. 18709:20140228:000441.178 In proxy_get_history_data() table:'proxy_dhistory'
  1227. 18709:20140228:000441.178 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1228. 18709:20140228:000441.178 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1229. 18709:20140228:000441.179 End of proxy_get_lastid():0
  1230. 18709:20140228:000441.179 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1231. 18709:20140228:000441.179 End of proxy_get_history_data():0 lastid:0
  1232. 18709:20140228:000441.180 End of history_sender()
  1233. 18709:20140228:000441.180 In history_sender()
  1234. 18709:20140228:000441.180 In proxy_get_history_data() table:'proxy_autoreg_host'
  1235. 18709:20140228:000441.180 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1236. 18709:20140228:000441.180 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1237. 18709:20140228:000441.181 End of proxy_get_lastid():147
  1238. 18709:20140228:000441.181 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>147 order by p.id limit 1000]
  1239. 18709:20140228:000441.181 End of proxy_get_history_data():0 lastid:0
  1240. 18709:20140228:000441.182 End of history_sender()
  1241. 18709:20140228:000441.182 Datasender spent 0.007780 seconds while processing 0 values.
  1242. 18709:20140228:000441.182 sleeping for 1 seconds
  1243. 18709:20140228:000442.182 In host_availability_sender()
  1244. 18709:20140228:000442.183 In get_host_availability_data()
  1245. 18709:20140228:000442.183 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1246. 18709:20140228:000442.183 End of get_host_availability_data():FAIL
  1247. 18709:20140228:000442.184 End of host_availability_sender()
  1248. 18709:20140228:000442.184 In history_sender()
  1249. 18709:20140228:000442.184 In proxy_get_history_data() table:'proxy_history'
  1250. 18709:20140228:000442.184 In proxy_get_lastid() [proxy_history.history_lastid]
  1251. 18709:20140228:000442.184 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1252. 18709:20140228:000442.185 End of proxy_get_lastid():0
  1253. 18709:20140228:000442.185 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1254. 18709:20140228:000442.186 End of proxy_get_history_data():0 lastid:0
  1255. 18709:20140228:000442.186 End of history_sender()
  1256. 18709:20140228:000442.186 In history_sender()
  1257. 18709:20140228:000442.186 In proxy_get_history_data() table:'proxy_dhistory'
  1258. 18709:20140228:000442.187 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1259. 18709:20140228:000442.187 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1260. 18709:20140228:000442.187 End of proxy_get_lastid():0
  1261. 18709:20140228:000442.187 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1262. 18709:20140228:000442.188 End of proxy_get_history_data():0 lastid:0
  1263. 18709:20140228:000442.188 End of history_sender()
  1264. 18709:20140228:000442.188 In history_sender()
  1265. 18709:20140228:000442.188 In proxy_get_history_data() table:'proxy_autoreg_host'
  1266. 18709:20140228:000442.188 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1267. 18709:20140228:000442.189 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1268. 18709:20140228:000442.189 End of proxy_get_lastid():147
  1269. 18709:20140228:000442.189 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>147 order by p.id limit 1000]
  1270. 18709:20140228:000442.190 End of proxy_get_history_data():0 lastid:0
  1271. 18709:20140228:000442.190 End of history_sender()
  1272. 18709:20140228:000442.190 Datasender spent 0.007655 seconds while processing 0 values.
  1273. 18709:20140228:000442.190 sleeping for 1 seconds
  1274. 18709:20140228:000443.191 In host_availability_sender()
  1275. 18709:20140228:000443.203 In get_host_availability_data()
  1276. 18709:20140228:000443.203 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1277. 18709:20140228:000443.204 End of get_host_availability_data():FAIL
  1278. 18709:20140228:000443.204 End of host_availability_sender()
  1279. 18709:20140228:000443.204 In history_sender()
  1280. 18709:20140228:000443.204 In proxy_get_history_data() table:'proxy_history'
  1281. 18709:20140228:000443.205 In proxy_get_lastid() [proxy_history.history_lastid]
  1282. 18709:20140228:000443.205 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1283. 18709:20140228:000443.205 End of proxy_get_lastid():0
  1284. 18709:20140228:000443.206 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1285. 18709:20140228:000443.206 End of proxy_get_history_data():0 lastid:0
  1286. 18709:20140228:000443.206 End of history_sender()
  1287. 18709:20140228:000443.206 In history_sender()
  1288. 18709:20140228:000443.207 In proxy_get_history_data() table:'proxy_dhistory'
  1289. 18709:20140228:000443.207 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1290. 18709:20140228:000443.207 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1291. 18709:20140228:000443.207 End of proxy_get_lastid():0
  1292. 18709:20140228:000443.208 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1293. 18709:20140228:000443.208 End of proxy_get_history_data():0 lastid:0
  1294. 18709:20140228:000443.208 End of history_sender()
  1295. 18709:20140228:000443.208 In history_sender()
  1296. 18709:20140228:000443.209 In proxy_get_history_data() table:'proxy_autoreg_host'
  1297. 18709:20140228:000443.209 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1298. 18709:20140228:000443.209 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1299. 18709:20140228:000443.209 End of proxy_get_lastid():147
  1300. 18709:20140228:000443.210 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>147 order by p.id limit 1000]
  1301. 18709:20140228:000443.210 End of proxy_get_history_data():0 lastid:0
  1302. 18709:20140228:000443.210 End of history_sender()
  1303. 18709:20140228:000443.210 Datasender spent 0.019881 seconds while processing 0 values.
  1304. 18709:20140228:000443.211 sleeping for 1 seconds
  1305. 18709:20140228:000444.211 In host_availability_sender()
  1306. 18709:20140228:000444.211 In get_host_availability_data()
  1307. 18709:20140228:000444.212 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1308. 18709:20140228:000444.212 End of get_host_availability_data():FAIL
  1309. 18709:20140228:000444.212 End of host_availability_sender()
  1310. 18709:20140228:000444.213 In history_sender()
  1311. 18709:20140228:000444.213 In proxy_get_history_data() table:'proxy_history'
  1312. 18709:20140228:000444.213 In proxy_get_lastid() [proxy_history.history_lastid]
  1313. 18709:20140228:000444.213 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1314. 18709:20140228:000444.214 End of proxy_get_lastid():0
  1315. 18709:20140228:000444.214 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1316. 18709:20140228:000444.214 End of proxy_get_history_data():0 lastid:0
  1317. 18709:20140228:000444.215 End of history_sender()
  1318. 18709:20140228:000444.215 In history_sender()
  1319. 18709:20140228:000444.215 In proxy_get_history_data() table:'proxy_dhistory'
  1320. 18709:20140228:000444.215 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1321. 18709:20140228:000444.216 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1322. 18709:20140228:000444.216 End of proxy_get_lastid():0
  1323. 18709:20140228:000444.216 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1324. 18709:20140228:000444.216 End of proxy_get_history_data():0 lastid:0
  1325. 18709:20140228:000444.217 End of history_sender()
  1326. 18709:20140228:000444.217 In history_sender()
  1327. 18709:20140228:000444.217 In proxy_get_history_data() table:'proxy_autoreg_host'
  1328. 18709:20140228:000444.217 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1329. 18709:20140228:000444.217 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1330. 18709:20140228:000444.218 End of proxy_get_lastid():147
  1331. 18709:20140228:000444.218 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>147 order by p.id limit 1000]
  1332. 18709:20140228:000444.218 End of proxy_get_history_data():0 lastid:0
  1333. 18709:20140228:000444.219 End of history_sender()
  1334. 18709:20140228:000444.219 Datasender spent 0.007868 seconds while processing 0 values.
  1335. 18709:20140228:000444.219 sleeping for 1 seconds
  1336. 18710:20140228:000445.000 In get_values()
  1337. 18710:20140228:000445.001 In DCconfig_get_poller_items() poller_type:0
  1338. 18710:20140228:000445.001 End of DCconfig_get_poller_items():0
  1339. 18710:20140228:000445.001 End of get_values():0
  1340. 18710:20140228:000445.002 poller #1 spent 0.001363 seconds while updating 0 values
  1341. 18710:20140228:000445.002 In DCconfig_get_poller_nextcheck() poller_type:0
  1342. 18710:20140228:000445.002 End of DCconfig_get_poller_nextcheck():-1
  1343. 18710:20140228:000445.003 sleeping for 5 seconds
  1344. 18711:20140228:000445.017 In get_values()
  1345. 18711:20140228:000445.017 In DCconfig_get_poller_items() poller_type:0
  1346. 18711:20140228:000445.017 End of DCconfig_get_poller_items():0
  1347. 18711:20140228:000445.018 End of get_values():0
  1348. 18711:20140228:000445.018 poller #2 spent 0.001076 seconds while updating 0 values
  1349. 18711:20140228:000445.018 In DCconfig_get_poller_nextcheck() poller_type:0
  1350. 18711:20140228:000445.018 End of DCconfig_get_poller_nextcheck():-1
  1351. 18711:20140228:000445.018 sleeping for 5 seconds
  1352. 18714:20140228:000445.020 In get_values()
  1353. 18714:20140228:000445.020 In DCconfig_get_poller_items() poller_type:0
  1354. 18714:20140228:000445.021 End of DCconfig_get_poller_items():0
  1355. 18713:20140228:000445.021 In get_values()
  1356. 18713:20140228:000445.021 In DCconfig_get_poller_items() poller_type:0
  1357. 18713:20140228:000445.021 End of DCconfig_get_poller_items():0
  1358. 18713:20140228:000445.021 End of get_values():0
  1359. 18714:20140228:000445.022 End of get_values():0
  1360. 18713:20140228:000445.022 poller #4 spent 0.001039 seconds while updating 0 values
  1361. 18714:20140228:000445.022 poller #5 spent 0.001884 seconds while updating 0 values
  1362. 18713:20140228:000445.022 In DCconfig_get_poller_nextcheck() poller_type:0
  1363. 18714:20140228:000445.022 In DCconfig_get_poller_nextcheck() poller_type:0
  1364. 18713:20140228:000445.023 End of DCconfig_get_poller_nextcheck():-1
  1365. 18714:20140228:000445.023 End of DCconfig_get_poller_nextcheck():-1
  1366. 18713:20140228:000445.023 sleeping for 5 seconds
  1367. 18714:20140228:000445.023 sleeping for 5 seconds
  1368. 18712:20140228:000445.023 In get_values()
  1369. 18712:20140228:000445.024 In DCconfig_get_poller_items() poller_type:0
  1370. 18712:20140228:000445.024 End of DCconfig_get_poller_items():0
  1371. 18712:20140228:000445.024 End of get_values():0
  1372. 18712:20140228:000445.024 poller #3 spent 0.000804 seconds while updating 0 values
  1373. 18712:20140228:000445.024 In DCconfig_get_poller_nextcheck() poller_type:0
  1374. 18712:20140228:000445.025 End of DCconfig_get_poller_nextcheck():-1
  1375. 18712:20140228:000445.025 sleeping for 5 seconds
  1376. 18715:20140228:000445.039 In get_values()
  1377. 18715:20140228:000445.039 In DCconfig_get_poller_items() poller_type:1
  1378. 18715:20140228:000445.039 End of DCconfig_get_poller_items():0
  1379. 18715:20140228:000445.040 End of get_values():0
  1380. 18715:20140228:000445.040 unreachable poller #1 spent 0.000919 seconds while updating 0 values
  1381. 18715:20140228:000445.040 In DCconfig_get_poller_nextcheck() poller_type:1
  1382. 18715:20140228:000445.040 End of DCconfig_get_poller_nextcheck():-1
  1383. 18715:20140228:000445.040 sleeping for 5 seconds
  1384. 18726:20140228:000445.046 Syncing ...
  1385. 18726:20140228:000445.047 In DCsync_history() history_first:0 history_num:0
  1386. 18725:20140228:000445.047 Syncing ...
  1387. 18725:20140228:000445.047 In DCsync_history() history_first:0 history_num:0
  1388. 18725:20140228:000445.047 history syncer #1 spent 0.000205 seconds while processing 0 items
  1389. 18726:20140228:000445.047 history syncer #2 spent 0.000832 seconds while processing 0 items
  1390. 18725:20140228:000445.048 sleeping for 5 seconds
  1391. 18726:20140228:000445.048 sleeping for 5 seconds
  1392. 18723:20140228:000445.049 In process_httptests()
  1393. 18723:20140228:000445.049 query [txnlev:0] [select t.httptestid,t.name,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<=1393545885 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  1394. 18723:20140228:000445.050 End of process_httptests()
  1395. 18723:20140228:000445.050 http poller #1 spent 0.001040 seconds while updating HTTP tests
  1396. 18723:20140228:000445.050 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  1397. 18723:20140228:000445.051 No httptests to process in get_minnextcheck.
  1398. 18723:20140228:000445.051 sleeping for 5 seconds
  1399. 18721:20140228:000445.054 In get_pinger_hosts()
  1400. 18721:20140228:000445.054 In DCconfig_get_poller_items() poller_type:3
  1401. 18721:20140228:000445.054 End of DCconfig_get_poller_items():0
  1402. 18727:20140228:000445.055 Syncing ...
  1403. 18727:20140228:000445.055 In DCsync_history() history_first:0 history_num:0
  1404. 18728:20140228:000445.055 Syncing ...
  1405. 18728:20140228:000445.055 In DCsync_history() history_first:0 history_num:0
  1406. 18728:20140228:000445.055 history syncer #4 spent 0.000203 seconds while processing 0 items
  1407. 18727:20140228:000445.056 history syncer #3 spent 0.000821 seconds while processing 0 items
  1408. 18728:20140228:000445.056 sleeping for 5 seconds
  1409. 18727:20140228:000445.056 sleeping for 5 seconds
  1410. 18721:20140228:000445.056 End of get_pinger_hosts():0
  1411. 18721:20140228:000445.057 In process_pinger_hosts()
  1412. 18721:20140228:000445.057 End of process_pinger_hosts()
  1413. 18721:20140228:000445.057 icmp pinger #1 spent 0.002978 seconds while processing 0 items
  1414. 18721:20140228:000445.057 In DCconfig_get_poller_nextcheck() poller_type:3
  1415. 18721:20140228:000445.057 End of DCconfig_get_poller_nextcheck():-1
  1416. 18721:20140228:000445.058 sleeping for 5 seconds
  1417. 18709:20140228:000445.219 In host_availability_sender()
  1418. 18709:20140228:000445.220 In get_host_availability_data()
  1419. 18709:20140228:000445.220 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1420. 18709:20140228:000445.221 End of get_host_availability_data():FAIL
  1421. 18709:20140228:000445.221 End of host_availability_sender()
  1422. 18709:20140228:000445.221 In history_sender()
  1423. 18709:20140228:000445.221 In proxy_get_history_data() table:'proxy_history'
  1424. 18709:20140228:000445.222 In proxy_get_lastid() [proxy_history.history_lastid]
  1425. 18709:20140228:000445.222 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1426. 18709:20140228:000445.222 End of proxy_get_lastid():0
  1427. 18709:20140228:000445.223 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1428. 18709:20140228:000445.223 End of proxy_get_history_data():0 lastid:0
  1429. 18709:20140228:000445.223 End of history_sender()
  1430. 18709:20140228:000445.224 In history_sender()
  1431. 18709:20140228:000445.224 In proxy_get_history_data() table:'proxy_dhistory'
  1432. 18709:20140228:000445.224 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1433. 18709:20140228:000445.224 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1434. 18709:20140228:000445.225 End of proxy_get_lastid():0
  1435. 18709:20140228:000445.225 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1436. 18709:20140228:000445.225 End of proxy_get_history_data():0 lastid:0
  1437. 18709:20140228:000445.226 End of history_sender()
  1438. 18709:20140228:000445.226 In history_sender()
  1439. 18709:20140228:000445.226 In proxy_get_history_data() table:'proxy_autoreg_host'
  1440. 18709:20140228:000445.226 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1441. 18709:20140228:000445.226 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1442. 18709:20140228:000445.227 End of proxy_get_lastid():147
  1443. 18709:20140228:000445.227 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>147 order by p.id limit 1000]
  1444. 18709:20140228:000445.227 End of proxy_get_history_data():0 lastid:0
  1445. 18709:20140228:000445.227 End of history_sender()
  1446. 18709:20140228:000445.228 Datasender spent 0.008337 seconds while processing 0 values.
  1447. 18709:20140228:000445.228 sleeping for 1 seconds
  1448. 18709:20140228:000446.228 In host_availability_sender()
  1449. 18709:20140228:000446.229 In get_host_availability_data()
  1450. 18709:20140228:000446.229 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1451. 18709:20140228:000446.229 End of get_host_availability_data():FAIL
  1452. 18709:20140228:000446.230 End of host_availability_sender()
  1453. 18709:20140228:000446.230 In history_sender()
  1454. 18709:20140228:000446.230 In proxy_get_history_data() table:'proxy_history'
  1455. 18709:20140228:000446.230 In proxy_get_lastid() [proxy_history.history_lastid]
  1456. 18709:20140228:000446.230 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1457. 18709:20140228:000446.231 End of proxy_get_lastid():0
  1458. 18709:20140228:000446.231 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1459. 18709:20140228:000446.231 End of proxy_get_history_data():0 lastid:0
  1460. 18709:20140228:000446.232 End of history_sender()
  1461. 18709:20140228:000446.232 In history_sender()
  1462. 18709:20140228:000446.232 In proxy_get_history_data() table:'proxy_dhistory'
  1463. 18709:20140228:000446.232 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1464. 18709:20140228:000446.232 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1465. 18709:20140228:000446.233 End of proxy_get_lastid():0
  1466. 18709:20140228:000446.233 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1467. 18709:20140228:000446.233 End of proxy_get_history_data():0 lastid:0
  1468. 18709:20140228:000446.234 End of history_sender()
  1469. 18709:20140228:000446.234 In history_sender()
  1470. 18709:20140228:000446.234 In proxy_get_history_data() table:'proxy_autoreg_host'
  1471. 18709:20140228:000446.234 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1472. 18709:20140228:000446.235 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1473. 18709:20140228:000446.235 End of proxy_get_lastid():147
  1474. 18709:20140228:000446.235 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>147 order by p.id limit 1000]
  1475. 18709:20140228:000446.236 End of proxy_get_history_data():0 lastid:0
  1476. 18709:20140228:000446.236 End of history_sender()
  1477. 18709:20140228:000446.236 Datasender spent 0.007762 seconds while processing 0 values.
  1478. 18709:20140228:000446.236 sleeping for 1 seconds
  1479. 18720:20140228:000446.978 Trapper got [{
  1480. "request":"active checks",
  1481. "host":"prodBETA-lb-0"}] len 54
  1482. 18720:20140228:000446.979 In send_list_of_active_checks_json()
  1483. 18720:20140228:000446.979 In get_hostid_by_host() host:'prodBETA-lb-0'
  1484. 18720:20140228:000446.979 query [txnlev:0] [select hostid,status from hosts where host='prodBETA-lb-0' and status in (0,1) and proxy_hostid is null]
  1485. 18720:20140228:000446.980 query [txnlev:1] [begin;]
  1486. 18720:20140228:000446.980 query [txnlev:1] [insert into proxy_autoreg_host (clock,host,listen_ip,listen_dns,listen_port) values (1393545886,'prodBETA-lb-0','10.164.38.249','ip-10-164-38-249.ec2.internal',10050)]
  1487. 18720:20140228:000446.981 query [txnlev:1] [commit;]
  1488. 18720:20140228:000446.981 End of get_hostid_by_host():FAIL
  1489. 18720:20140228:000446.982 cannot send list of active checks to [10.164.38.249]: host [prodBETA-lb-0] not found
  1490. 18720:20140228:000446.982 send_list_of_active_checks_json() sending [{
  1491. "response":"failed",
  1492. "info":"host [prodBETA-lb-0] not found"}]
  1493. 18720:20140228:000446.982 End of send_list_of_active_checks_json():SUCCEED
  1494. 18709:20140228:000447.237 In host_availability_sender()
  1495. 18709:20140228:000447.237 In get_host_availability_data()
  1496. 18709:20140228:000447.237 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1497. 18709:20140228:000447.238 End of get_host_availability_data():FAIL
  1498. 18709:20140228:000447.238 End of host_availability_sender()
  1499. 18709:20140228:000447.238 In history_sender()
  1500. 18709:20140228:000447.238 In proxy_get_history_data() table:'proxy_history'
  1501. 18709:20140228:000447.239 In proxy_get_lastid() [proxy_history.history_lastid]
  1502. 18709:20140228:000447.239 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1503. 18709:20140228:000447.239 End of proxy_get_lastid():0
  1504. 18709:20140228:000447.239 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1505. 18709:20140228:000447.240 End of proxy_get_history_data():0 lastid:0
  1506. 18709:20140228:000447.240 End of history_sender()
  1507. 18709:20140228:000447.240 In history_sender()
  1508. 18709:20140228:000447.241 In proxy_get_history_data() table:'proxy_dhistory'
  1509. 18709:20140228:000447.241 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1510. 18709:20140228:000447.241 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1511. 18709:20140228:000447.241 End of proxy_get_lastid():0
  1512. 18709:20140228:000447.242 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1513. 18709:20140228:000447.242 End of proxy_get_history_data():0 lastid:0
  1514. 18709:20140228:000447.242 End of history_sender()
  1515. 18709:20140228:000447.242 In history_sender()
  1516. 18709:20140228:000447.243 In proxy_get_history_data() table:'proxy_autoreg_host'
  1517. 18709:20140228:000447.243 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1518. 18709:20140228:000447.243 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1519. 18709:20140228:000447.243 End of proxy_get_lastid():147
  1520. 18709:20140228:000447.244 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>147 order by p.id limit 1000]
  1521. 18709:20140228:000447.244 End of proxy_get_history_data():1 lastid:148
  1522. 18709:20140228:000447.244 In connect_to_server() [10.168.24.153]:10051 [timeout:600]
  1523. 18709:20140228:000447.245 In put_data_to_server() datalen:237
  1524. 18709:20140228:000447.246 In send_data_to_server() [{
  1525. "request":"auto registration",
  1526. "host":"prodBETA-mon-master",
  1527. "data":[
  1528. {
  1529. "clock":1393545886,
  1530. "host":"prodBETA-lb-0",
  1531. "ip":"10.164.38.249",
  1532. "dns":"ip-10-164-38-249.ec2.internal",
  1533. "port":"10050"}],
  1534. "clock":1393545887}]
  1535. 18709:20140228:000447.246 In zbx_recv_response()
  1536. 18709:20140228:000447.252 zbx_recv_response() '{
  1537. "response":"success"}'
  1538. 18709:20140228:000447.252 End of zbx_recv_response():SUCCEED
  1539. 18709:20140228:000447.252 End of put_data_to_server():SUCCEED
  1540. 18709:20140228:000447.253 query [txnlev:1] [begin;]
  1541. 18709:20140228:000447.253 In proxy_set_lastid() [proxy_autoreg_host.autoreg_host_lastid:148]
  1542. 18709:20140228:000447.253 query [txnlev:1] [select 1 from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1543. 18709:20140228:000447.253 query [txnlev:1] [update ids set nextid=148 where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1544. 18709:20140228:000447.254 End of proxy_set_lastid()
  1545. 18709:20140228:000447.254 query [txnlev:1] [commit;]
  1546. 18709:20140228:000447.254 End of history_sender()
  1547. 18709:20140228:000447.254 Datasender spent 0.017978 seconds while processing 1 values.
  1548. 18709:20140228:000447.255 sleeping for 1 seconds
  1549. 18709:20140228:000448.255 In host_availability_sender()
  1550. 18709:20140228:000448.255 In get_host_availability_data()
  1551. 18709:20140228:000448.256 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1552. 18709:20140228:000448.256 End of get_host_availability_data():FAIL
  1553. 18709:20140228:000448.256 End of host_availability_sender()
  1554. 18709:20140228:000448.257 In history_sender()
  1555. 18709:20140228:000448.257 In proxy_get_history_data() table:'proxy_history'
  1556. 18709:20140228:000448.257 In proxy_get_lastid() [proxy_history.history_lastid]
  1557. 18709:20140228:000448.257 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1558. 18709:20140228:000448.258 End of proxy_get_lastid():0
  1559. 18709:20140228:000448.258 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1560. 18709:20140228:000448.258 End of proxy_get_history_data():0 lastid:0
  1561. 18709:20140228:000448.258 End of history_sender()
  1562. 18709:20140228:000448.259 In history_sender()
  1563. 18709:20140228:000448.259 In proxy_get_history_data() table:'proxy_dhistory'
  1564. 18709:20140228:000448.259 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1565. 18709:20140228:000448.259 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1566. 18709:20140228:000448.260 End of proxy_get_lastid():0
  1567. 18709:20140228:000448.260 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1568. 18709:20140228:000448.260 End of proxy_get_history_data():0 lastid:0
  1569. 18709:20140228:000448.260 End of history_sender()
  1570. 18709:20140228:000448.261 In history_sender()
  1571. 18709:20140228:000448.261 In proxy_get_history_data() table:'proxy_autoreg_host'
  1572. 18709:20140228:000448.261 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1573. 18709:20140228:000448.261 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1574. 18709:20140228:000448.261 End of proxy_get_lastid():148
  1575. 18709:20140228:000448.262 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>148 order by p.id limit 1000]
  1576. 18709:20140228:000448.262 End of proxy_get_history_data():0 lastid:0
  1577. 18709:20140228:000448.262 End of history_sender()
  1578. 18709:20140228:000448.263 Datasender spent 0.007499 seconds while processing 0 values.
  1579. 18709:20140228:000448.263 sleeping for 1 seconds
  1580. 18709:20140228:000449.263 In host_availability_sender()
  1581. 18709:20140228:000449.263 In get_host_availability_data()
  1582. 18709:20140228:000449.263 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1583. 18709:20140228:000449.263 End of get_host_availability_data():FAIL
  1584. 18709:20140228:000449.264 End of host_availability_sender()
  1585. 18709:20140228:000449.264 In history_sender()
  1586. 18709:20140228:000449.264 In proxy_get_history_data() table:'proxy_history'
  1587. 18709:20140228:000449.264 In proxy_get_lastid() [proxy_history.history_lastid]
  1588. 18709:20140228:000449.264 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1589. 18709:20140228:000449.264 End of proxy_get_lastid():0
  1590. 18709:20140228:000449.264 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1591. 18709:20140228:000449.264 End of proxy_get_history_data():0 lastid:0
  1592. 18709:20140228:000449.264 End of history_sender()
  1593. 18709:20140228:000449.264 In history_sender()
  1594. 18709:20140228:000449.264 In proxy_get_history_data() table:'proxy_dhistory'
  1595. 18709:20140228:000449.264 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1596. 18709:20140228:000449.264 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1597. 18709:20140228:000449.265 End of proxy_get_lastid():0
  1598. 18709:20140228:000449.265 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1599. 18709:20140228:000449.265 End of proxy_get_history_data():0 lastid:0
  1600. 18709:20140228:000449.265 End of history_sender()
  1601. 18709:20140228:000449.265 In history_sender()
  1602. 18709:20140228:000449.265 In proxy_get_history_data() table:'proxy_autoreg_host'
  1603. 18709:20140228:000449.265 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1604. 18709:20140228:000449.265 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1605. 18709:20140228:000449.265 End of proxy_get_lastid():148
  1606. 18709:20140228:000449.265 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>148 order by p.id limit 1000]
  1607. 18709:20140228:000449.265 End of proxy_get_history_data():0 lastid:0
  1608. 18709:20140228:000449.266 End of history_sender()
  1609. 18709:20140228:000449.266 Datasender spent 0.002567 seconds while processing 0 values.
  1610. 18709:20140228:000449.266 sleeping for 1 seconds
  1611. 18710:20140228:000450.004 In get_values()
  1612. 18710:20140228:000450.004 In DCconfig_get_poller_items() poller_type:0
  1613. 18710:20140228:000450.004 End of DCconfig_get_poller_items():0
  1614. 18710:20140228:000450.004 End of get_values():0
  1615. 18710:20140228:000450.004 poller #1 spent 0.000333 seconds while updating 0 values
  1616. 18710:20140228:000450.004 In DCconfig_get_poller_nextcheck() poller_type:0
  1617. 18710:20140228:000450.004 End of DCconfig_get_poller_nextcheck():-1
  1618. 18710:20140228:000450.004 sleeping for 5 seconds
  1619. 18711:20140228:000450.019 In get_values()
  1620. 18711:20140228:000450.019 In DCconfig_get_poller_items() poller_type:0
  1621. 18711:20140228:000450.019 End of DCconfig_get_poller_items():0
  1622. 18711:20140228:000450.019 End of get_values():0
  1623. 18711:20140228:000450.019 poller #2 spent 0.000237 seconds while updating 0 values
  1624. 18711:20140228:000450.019 In DCconfig_get_poller_nextcheck() poller_type:0
  1625. 18711:20140228:000450.019 End of DCconfig_get_poller_nextcheck():-1
  1626. 18711:20140228:000450.019 sleeping for 5 seconds
  1627. 18712:20140228:000450.026 In get_values()
  1628. 18712:20140228:000450.026 In DCconfig_get_poller_items() poller_type:0
  1629. 18712:20140228:000450.026 End of DCconfig_get_poller_items():0
  1630. 18712:20140228:000450.026 End of get_values():0
  1631. 18712:20140228:000450.026 poller #3 spent 0.000243 seconds while updating 0 values
  1632. 18712:20140228:000450.026 In DCconfig_get_poller_nextcheck() poller_type:0
  1633. 18712:20140228:000450.026 End of DCconfig_get_poller_nextcheck():-1
  1634. 18712:20140228:000450.026 sleeping for 5 seconds
  1635. 18713:20140228:000450.026 In get_values()
  1636. 18713:20140228:000450.026 In DCconfig_get_poller_items() poller_type:0
  1637. 18713:20140228:000450.026 End of DCconfig_get_poller_items():0
  1638. 18713:20140228:000450.026 End of get_values():0
  1639. 18713:20140228:000450.026 poller #4 spent 0.000278 seconds while updating 0 values
  1640. 18713:20140228:000450.026 In DCconfig_get_poller_nextcheck() poller_type:0
  1641. 18713:20140228:000450.026 End of DCconfig_get_poller_nextcheck():-1
  1642. 18713:20140228:000450.026 sleeping for 5 seconds
  1643. 18714:20140228:000450.027 In get_values()
  1644. 18714:20140228:000450.027 In DCconfig_get_poller_items() poller_type:0
  1645. 18714:20140228:000450.027 End of DCconfig_get_poller_items():0
  1646. 18714:20140228:000450.027 End of get_values():0
  1647. 18714:20140228:000450.027 poller #5 spent 0.000195 seconds while updating 0 values
  1648. 18714:20140228:000450.027 In DCconfig_get_poller_nextcheck() poller_type:0
  1649. 18714:20140228:000450.027 End of DCconfig_get_poller_nextcheck():-1
  1650. 18714:20140228:000450.027 sleeping for 5 seconds
  1651. 18715:20140228:000450.041 In get_values()
  1652. 18715:20140228:000450.041 In DCconfig_get_poller_items() poller_type:1
  1653. 18715:20140228:000450.041 End of DCconfig_get_poller_items():0
  1654. 18715:20140228:000450.041 End of get_values():0
  1655. 18715:20140228:000450.041 unreachable poller #1 spent 0.000298 seconds while updating 0 values
  1656. 18715:20140228:000450.041 In DCconfig_get_poller_nextcheck() poller_type:1
  1657. 18715:20140228:000450.042 End of DCconfig_get_poller_nextcheck():-1
  1658. 18715:20140228:000450.042 sleeping for 5 seconds
  1659. 18725:20140228:000450.049 Syncing ...
  1660. 18725:20140228:000450.049 In DCsync_history() history_first:0 history_num:0
  1661. 18725:20140228:000450.049 history syncer #1 spent 0.000051 seconds while processing 0 items
  1662. 18725:20140228:000450.049 sleeping for 5 seconds
  1663. 18726:20140228:000450.049 Syncing ...
  1664. 18726:20140228:000450.049 In DCsync_history() history_first:0 history_num:0
  1665. 18726:20140228:000450.049 history syncer #2 spent 0.000075 seconds while processing 0 items
  1666. 18726:20140228:000450.049 sleeping for 5 seconds
  1667. 18723:20140228:000450.051 In process_httptests()
  1668. 18723:20140228:000450.051 query [txnlev:0] [select t.httptestid,t.name,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<=1393545890 and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  1669. 18723:20140228:000450.052 End of process_httptests()
  1670. 18723:20140228:000450.052 http poller #1 spent 0.000509 seconds while updating HTTP tests
  1671. 18723:20140228:000450.052 query [txnlev:0] [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.httptestid%1=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0)]
  1672. 18723:20140228:000450.052 No httptests to process in get_minnextcheck.
  1673. 18723:20140228:000450.052 sleeping for 5 seconds
  1674. 18728:20140228:000450.057 Syncing ...
  1675. 18728:20140228:000450.057 In DCsync_history() history_first:0 history_num:0
  1676. 18728:20140228:000450.057 history syncer #4 spent 0.000049 seconds while processing 0 items
  1677. 18728:20140228:000450.057 sleeping for 5 seconds
  1678. 18727:20140228:000450.057 Syncing ...
  1679. 18727:20140228:000450.057 In DCsync_history() history_first:0 history_num:0
  1680. 18727:20140228:000450.057 history syncer #3 spent 0.000047 seconds while processing 0 items
  1681. 18727:20140228:000450.057 sleeping for 5 seconds
  1682. 18721:20140228:000450.058 In get_pinger_hosts()
  1683. 18721:20140228:000450.058 In DCconfig_get_poller_items() poller_type:3
  1684. 18721:20140228:000450.058 End of DCconfig_get_poller_items():0
  1685. 18721:20140228:000450.058 End of get_pinger_hosts():0
  1686. 18721:20140228:000450.058 In process_pinger_hosts()
  1687. 18721:20140228:000450.058 End of process_pinger_hosts()
  1688. 18721:20140228:000450.058 icmp pinger #1 spent 0.000299 seconds while processing 0 items
  1689. 18721:20140228:000450.059 In DCconfig_get_poller_nextcheck() poller_type:3
  1690. 18721:20140228:000450.059 End of DCconfig_get_poller_nextcheck():-1
  1691. 18721:20140228:000450.059 sleeping for 5 seconds
  1692. 18709:20140228:000450.266 In host_availability_sender()
  1693. 18709:20140228:000450.266 In get_host_availability_data()
  1694. 18709:20140228:000450.266 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1695. 18709:20140228:000450.266 End of get_host_availability_data():FAIL
  1696. 18709:20140228:000450.266 End of host_availability_sender()
  1697. 18709:20140228:000450.267 In history_sender()
  1698. 18709:20140228:000450.267 In proxy_get_history_data() table:'proxy_history'
  1699. 18709:20140228:000450.267 In proxy_get_lastid() [proxy_history.history_lastid]
  1700. 18709:20140228:000450.267 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1701. 18709:20140228:000450.267 End of proxy_get_lastid():0
  1702. 18709:20140228:000450.267 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1703. 18709:20140228:000450.267 End of proxy_get_history_data():0 lastid:0
  1704. 18709:20140228:000450.267 End of history_sender()
  1705. 18709:20140228:000450.267 In history_sender()
  1706. 18709:20140228:000450.267 In proxy_get_history_data() table:'proxy_dhistory'
  1707. 18709:20140228:000450.267 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1708. 18709:20140228:000450.267 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1709. 18709:20140228:000450.268 End of proxy_get_lastid():0
  1710. 18709:20140228:000450.268 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1711. 18709:20140228:000450.268 End of proxy_get_history_data():0 lastid:0
  1712. 18709:20140228:000450.268 End of history_sender()
  1713. 18709:20140228:000450.268 In history_sender()
  1714. 18709:20140228:000450.268 In proxy_get_history_data() table:'proxy_autoreg_host'
  1715. 18709:20140228:000450.268 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1716. 18709:20140228:000450.268 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1717. 18709:20140228:000450.268 End of proxy_get_lastid():148
  1718. 18709:20140228:000450.268 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>148 order by p.id limit 1000]
  1719. 18709:20140228:000450.269 End of proxy_get_history_data():0 lastid:0
  1720. 18709:20140228:000450.269 End of history_sender()
  1721. 18709:20140228:000450.269 Datasender spent 0.002940 seconds while processing 0 values.
  1722. 18709:20140228:000450.269 sleeping for 1 seconds
  1723. 18709:20140228:000451.269 In host_availability_sender()
  1724. 18709:20140228:000451.269 In get_host_availability_data()
  1725. 18709:20140228:000451.269 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1726. 18709:20140228:000451.270 End of get_host_availability_data():FAIL
  1727. 18709:20140228:000451.270 End of host_availability_sender()
  1728. 18709:20140228:000451.270 In history_sender()
  1729. 18709:20140228:000451.270 In proxy_get_history_data() table:'proxy_history'
  1730. 18709:20140228:000451.270 In proxy_get_lastid() [proxy_history.history_lastid]
  1731. 18709:20140228:000451.270 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1732. 18709:20140228:000451.270 End of proxy_get_lastid():0
  1733. 18709:20140228:000451.270 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1734. 18709:20140228:000451.270 End of proxy_get_history_data():0 lastid:0
  1735. 18709:20140228:000451.270 End of history_sender()
  1736. 18709:20140228:000451.271 In history_sender()
  1737. 18709:20140228:000451.271 In proxy_get_history_data() table:'proxy_dhistory'
  1738. 18709:20140228:000451.271 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1739. 18709:20140228:000451.271 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1740. 18709:20140228:000451.271 End of proxy_get_lastid():0
  1741. 18709:20140228:000451.271 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1742. 18709:20140228:000451.271 End of proxy_get_history_data():0 lastid:0
  1743. 18709:20140228:000451.271 End of history_sender()
  1744. 18709:20140228:000451.271 In history_sender()
  1745. 18709:20140228:000451.271 In proxy_get_history_data() table:'proxy_autoreg_host'
  1746. 18709:20140228:000451.272 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1747. 18709:20140228:000451.272 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1748. 18709:20140228:000451.272 End of proxy_get_lastid():148
  1749. 18709:20140228:000451.272 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>148 order by p.id limit 1000]
  1750. 18709:20140228:000451.272 End of proxy_get_history_data():0 lastid:0
  1751. 18709:20140228:000451.272 End of history_sender()
  1752. 18709:20140228:000451.272 Datasender spent 0.003096 seconds while processing 0 values.
  1753. 18709:20140228:000451.272 sleeping for 1 seconds
  1754. 18709:20140228:000452.273 In host_availability_sender()
  1755. 18709:20140228:000452.273 In get_host_availability_data()
  1756. 18709:20140228:000452.273 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1757. 18709:20140228:000452.273 End of get_host_availability_data():FAIL
  1758. 18709:20140228:000452.273 End of host_availability_sender()
  1759. 18709:20140228:000452.273 In history_sender()
  1760. 18709:20140228:000452.273 In proxy_get_history_data() table:'proxy_history'
  1761. 18709:20140228:000452.273 In proxy_get_lastid() [proxy_history.history_lastid]
  1762. 18709:20140228:000452.273 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1763. 18709:20140228:000452.273 End of proxy_get_lastid():0
  1764. 18709:20140228:000452.274 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1765. 18709:20140228:000452.274 End of proxy_get_history_data():0 lastid:0
  1766. 18709:20140228:000452.274 End of history_sender()
  1767. 18709:20140228:000452.274 In history_sender()
  1768. 18709:20140228:000452.274 In proxy_get_history_data() table:'proxy_dhistory'
  1769. 18709:20140228:000452.274 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1770. 18709:20140228:000452.274 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1771. 18709:20140228:000452.274 End of proxy_get_lastid():0
  1772. 18709:20140228:000452.274 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1773. 18709:20140228:000452.274 End of proxy_get_history_data():0 lastid:0
  1774. 18709:20140228:000452.274 End of history_sender()
  1775. 18709:20140228:000452.275 In history_sender()
  1776. 18709:20140228:000452.275 In proxy_get_history_data() table:'proxy_autoreg_host'
  1777. 18709:20140228:000452.275 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1778. 18709:20140228:000452.275 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1779. 18709:20140228:000452.275 End of proxy_get_lastid():148
  1780. 18709:20140228:000452.275 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>148 order by p.id limit 1000]
  1781. 18709:20140228:000452.275 End of proxy_get_history_data():0 lastid:0
  1782. 18709:20140228:000452.275 End of history_sender()
  1783. 18709:20140228:000452.275 Datasender spent 0.002566 seconds while processing 0 values.
  1784. 18709:20140228:000452.275 sleeping for 1 seconds
  1785. 18709:20140228:000453.275 In host_availability_sender()
  1786. 18709:20140228:000453.290 In get_host_availability_data()
  1787. 18709:20140228:000453.290 query [txnlev:0] [select hostid,available,error,snmp_available,snmp_error,ipmi_available,ipmi_error,jmx_available,jmx_error from hosts]
  1788. 18709:20140228:000453.290 End of get_host_availability_data():FAIL
  1789. 18709:20140228:000453.290 End of host_availability_sender()
  1790. 18709:20140228:000453.290 In history_sender()
  1791. 18709:20140228:000453.290 In proxy_get_history_data() table:'proxy_history'
  1792. 18709:20140228:000453.290 In proxy_get_lastid() [proxy_history.history_lastid]
  1793. 18709:20140228:000453.290 query [txnlev:0] [select nextid from ids where table_name='proxy_history' and field_name='history_lastid']
  1794. 18709:20140228:000453.290 End of proxy_get_lastid():0
  1795. 18709:20140228:000453.291 query [txnlev:0] [select p.id,h.host,i.key_,p.clock,p.ns,p.timestamp,p.source,p.severity,p.value,p.logeventid,p.status from hosts h,items i,proxy_history p where h.hostid=i.hostid and i.itemid=p.itemid and p.id>0 order by p.id limit 1000]
  1796. 18709:20140228:000453.291 End of proxy_get_history_data():0 lastid:0
  1797. 18709:20140228:000453.291 End of history_sender()
  1798. 18709:20140228:000453.291 In history_sender()
  1799. 18709:20140228:000453.291 In proxy_get_history_data() table:'proxy_dhistory'
  1800. 18709:20140228:000453.291 In proxy_get_lastid() [proxy_dhistory.dhistory_lastid]
  1801. 18709:20140228:000453.291 query [txnlev:0] [select nextid from ids where table_name='proxy_dhistory' and field_name='dhistory_lastid']
  1802. 18709:20140228:000453.291 End of proxy_get_lastid():0
  1803. 18709:20140228:000453.291 query [txnlev:0] [select p.id,p.clock,p.druleid,p.dcheckid,p.type,p.ip,p.dns,p.port,p.key_,p.value,p.status from proxy_dhistory p where p.id>0 order by p.id limit 1000]
  1804. 18709:20140228:000453.291 End of proxy_get_history_data():0 lastid:0
  1805. 18709:20140228:000453.291 End of history_sender()
  1806. 18709:20140228:000453.291 In history_sender()
  1807. 18709:20140228:000453.292 In proxy_get_history_data() table:'proxy_autoreg_host'
  1808. 18709:20140228:000453.292 In proxy_get_lastid() [proxy_autoreg_host.autoreg_host_lastid]
  1809. 18709:20140228:000453.292 query [txnlev:0] [select nextid from ids where table_name='proxy_autoreg_host' and field_name='autoreg_host_lastid']
  1810. 18709:20140228:000453.292 End of proxy_get_lastid():148
  1811. 18709:20140228:000453.292 query [txnlev:0] [select p.id,p.clock,p.host,p.listen_ip,p.listen_dns,p.listen_port from proxy_autoreg_host p where p.id>148 order by p.id limit 1000]
  1812. 18709:20140228:000453.292 End of proxy_get_history_data():0 lastid:0
  1813. 18709:20140228:000453.292 End of history_sender()
  1814. 18709:20140228:000453.292 Datasender spent 0.016773 seconds while processing 0 values.
  1815. 18709:20140228:000453.292 sleeping for 1 seconds
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!