--- Debug level 4 --- --- First move: TestPool -> Unassigned --- 20239:20181015:133706.526 trapper got '{"request":"proxy data","host":"zbxprox231","history data":[{"itemid":83944,"clock":1539603425,"ns":38289675,"value":"0"},{"itemid":49925,"clock":1539603425,"ns":392384149,"value":"0.44800937175751"},{"itemid":39071,"clock":1539603425,"ns":552433999,"value":"{\"data\":[{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.50.53.10.80.47.c7.c0.4f.53.47.32\",\"{#OVMM_SERVER_NAME}\":\"ovm08\",\"{#OVMM_SERVER_IP}\":\"143.169.231.21\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm08.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900008f68a4d47a7c2fdb\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm08.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.51.47.10.80.4d.c3.c0.4f.51.35.32\",\"{#OVMM_SERVER_NAME}\":\"ovm02\",\"{#OVMM_SERVER_IP}\":\"143.169.231.8\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm02.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000a84fc28506e67b9f\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"TestPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000c3ea53b6e46077c0\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm02.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.31.38.10.80.39.c3.c0.4f.43.39.32\",\"{#OVMM_SERVER_NAME}\":\"ovm05\",\"{#OVMM_SERVER_IP}\":\"143.169.231.14\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm05\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000033040738f684ffd9\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm05\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.5a.57.10.80.39.c4.c0.4f.58.50.32\",\"{#OVMM_SERVER_NAME}\":\"ovm15\",\"{#OVMM_SERVER_IP}\":\"143.169.231.33\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm15\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000aad807043dbe1ac4\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"WebPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900003b25a691ee945f48\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm15\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.37.48.10.80.48.b8.c0.4f.53.47.32\",\"{#OVMM_SERVER_NAME}\":\"ovm09\",\"{#OVMM_SERVER_IP}\":\"143.169.231.23\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm09\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000057bf7362c3fd0299\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm09\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a\",\"{#OVMM_SERVER_NAME}\":\"ovm01\",\"{#OVMM_SERVER_IP}\":\"143.169.231.31\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm01.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"Unassigned\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"Unassigned\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900001a95d04b1b89d455\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm01.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.46.38.10.80.59.b3.c0.4f.57.44.32\",\"{#OVMM_SERVER_NAME}\":\"ovm07\",\"{#OVMM_SERVER_IP}\":\"143.169.231.18\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm07\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000033d74b120dbb8354\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm07\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.51.34.10.80.50.c2.c0.4f.43.4d.32\",\"{#OVMM_SERVER_NAME}\":\"ovm13\",\"{#OVMM_SERVER_IP}\":\"143.169.231.29\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm13.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900006a3bc9210dccdfac\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm13.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.47.10.80.4a.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm12\",\"{#OVMM_SERVER_IP}\":\"143.169.231.28\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm12.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000071573072d52cf926\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm12.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4d.35.10.80.38.c3.c0.4f.43.39.32\",\"{#OVMM_SERVER_NAME}\":\"ovm04\",\"{#OVMM_SERVER_IP}\":\"143.169.231.13\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm04.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900000b30f10c393cd228\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm04.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.48.10.80.52.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm11\",\"{#OVMM_SERVER_IP}\":\"143.169.231.27\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm11.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000066c1bd1256cddfd5\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm11.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.53.46.10.80.4e.c8.c0.4f.51.35.32\",\"{#OVMM_SERVER_NAME}\":\"ovm03\",\"{#OVMM_SERVER_IP}\":\"143.169.231.9\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm03.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000286ddc4708165bf8\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm03.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.5a.57.10.80.37.c4.c0.4f.58.50.32\",\"{#OVMM_SERVER_NAME}\":\"ovm14\",\"{#OVMM_SERVER_IP}\":\"143.169.231.32\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm14\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000aad807043dbe1ac4\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"WebPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000bb2d953243166cb2\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm14\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.48.10.80.53.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm10\",\"{#OVMM_SERVER_IP}\":\"143.169.231.26\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm10.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000d39a80dc14baabde\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm10.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.46.37.10.80.5a.b3.c0.4f.57.44.32\",\"{#OVMM_SERVER_NAME}\":\"ovm06\",\"{#OVMM_SERVER_IP}\":\"143.169.231.17\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm06.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000086d3ddce73bf53d6\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm06.uantwerpen.be\"}]}"}],"version":"3.4.12","clock":1539603426,"ns":522135212}' 20239:20181015:133706.526 In zbx_recv_proxy_data() 20239:20181015:133706.526 query [txnlev:1] [begin;] 20239:20181015:133706.526 query [txnlev:1] [update hosts set lastaccess=1539603426 where hostid=10255;] 20239:20181015:133706.527 query [txnlev:1] [commit;] 20239:20181015:133706.528 In process_proxy_data() ... 20239:20181015:133706.536 In lld_host_make() 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20239:20181015:133706.536 In substitute_lld_macros() data:'{#OVMM_SERVER_NAME}' 20239:20181015:133706.536 End of substitute_lld_macros():SUCCEED data:'ovm01' 20239:20181015:133706.536 End of lld_host_make():0x5582d33f94c0 20239:20181015:133706.536 In lld_groups_make() 20239:20181015:133706.537 In lld_group_make() 20239:20181015:133706.537 In substitute_lld_macros() data:'Oracle VM/ServerPools/{#OVMM_SERVER_SERVERPOOL_NAME}' 20239:20181015:133706.537 End of substitute_lld_macros():SUCCEED data:'Oracle VM/ServerPools/Unassigned' 20239:20181015:133706.537 In substitute_lld_macros() data:'Oracle VM/ServerPools/{#OVMM_SERVER_SERVERPOOL_NAME}' 20239:20181015:133706.537 End of substitute_lld_macros():SUCCEED data:'Oracle VM/ServerPools/Unassigned' 20239:20181015:133706.537 End of lld_group_make():0x5582d33f6e50 20239:20181015:133706.537 End of lld_groups_make() ... 20239:20181015:133706.540 In lld_groups_validate() 20239:20181015:133706.540 End of lld_groups_validate() 20239:20181015:133706.540 In lld_hosts_validate() 20239:20181015:133706.540 End of lld_hosts_validate() 20239:20181015:133706.540 In lld_interfaces_make() 20239:20181015:133706.540 query [txnlev:0] [select hi.hostid,id.parent_interfaceid,hi.interfaceid,hi.type,hi.main,hi.useip,hi.ip,hi.dns,hi.port,hi.bulk from interface hi left join interface_discovery id on hi.interfaceid=id.interfaceid where (hi.hostid between 10281 and 10288 or hi.hostid in (10401,10403,10473,10474,10506,10515,10577))] 20239:20181015:133706.540 End of lld_interfaces_make() 20239:20181015:133706.540 In lld_interfaces_validate() 20239:20181015:133706.540 End of lld_interfaces_validate() 20239:20181015:133706.540 In lld_hostgroups_make() 20239:20181015:133706.540 query [txnlev:0] [select hostid,groupid,hostgroupid from hosts_groups where (hostid between 10281 and 10288 or hostid in (10401,10403,10473,10474,10506,10515,10577))] 20239:20181015:133706.541 End of lld_hostgroups_make() 20239:20181015:133706.541 In lld_templates_make() 20239:20181015:133706.541 query [txnlev:0] [select templateid from hosts_templates where hostid=10278] 20239:20181015:133706.541 query [txnlev:0] [select hostid,templateid from hosts_templates where (hostid between 10281 and 10288 or hostid in (10401,10403,10473,10474,10506,10515,10577))] 20239:20181015:133706.541 End of lld_templates_make() 20239:20181015:133706.541 In lld_hostmacros_make() 20239:20181015:133706.541 query [txnlev:0] [select hostmacroid,hostid,macro,value from hostmacro where (hostid between 10281 and 10288 or hostid in (10401,10403,10473,10474,10506,10515,10577))] 20239:20181015:133706.541 End of lld_hostmacros_make() 20239:20181015:133706.541 In lld_groups_save() 20239:20181015:133706.541 End of lld_groups_save() 20239:20181015:133706.541 In lld_hosts_save() 20239:20181015:133706.541 query [txnlev:1] [begin;] 20239:20181015:133706.542 In DBget_nextid() tablename:'hosts_groups' 20239:20181015:133706.542 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 20239:20181015:133706.542 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='hosts_groups' and field_name='hostgroupid'] 20239:20181015:133706.542 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 20239:20181015:133706.542 End of DBget_nextid():1019 table:'hosts_groups' recid:'hostgroupid' 20239:20181015:133706.542 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (1019,10577,70);] 20239:20181015:133706.542 query [txnlev:1] [delete from hosts_groups where hostgroupid=937;] 20239:20181015:133706.542 query [txnlev:1] [commit;] 20239:20181015:133706.545 End of lld_hosts_save() 20239:20181015:133706.545 In lld_templates_link() 20239:20181015:133706.545 End of lld_templates_link() 20239:20181015:133706.545 query [txnlev:1] [begin;] 20239:20181015:133706.545 query [txnlev:1] [update host_discovery set lastcheck=1539603426 where (hostid between 10281 and 10288 or hostid in (10401,10403,10473,10474,10506,10515,10577));] 20239:20181015:133706.545 query [txnlev:1] [commit;] 20239:20181015:133706.548 query [txnlev:1] [begin;] 20239:20181015:133706.548 query [txnlev:1] [update group_discovery set lastcheck=1539603426 where groupid in (24,25,26,69,70);update group_discovery set ts_delete=0 where groupid=70;] 20239:20181015:133706.548 query [txnlev:1] [commit;] 20239:20181015:133706.550 End of lld_update_hosts() 20239:20181015:133706.550 End of lld_process_discovery_rule() --- Second move: Unassigned -> Testpool --- 20240:20181015:133740.540 trapper got '{"request":"proxy data","host":"zbxprox231","history data":[{"itemid":39071,"clock":1539603456,"ns":179456066,"value":"{\"data\":[{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.50.53.10.80.47.c7.c0.4f.53.47.32\",\"{#OVMM_SERVER_NAME}\":\"ovm08\",\"{#OVMM_SERVER_IP}\":\"143.169.231.21\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm08.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900008f68a4d47a7c2fdb\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm08.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.51.47.10.80.4d.c3.c0.4f.51.35.32\",\"{#OVMM_SERVER_NAME}\":\"ovm02\",\"{#OVMM_SERVER_IP}\":\"143.169.231.8\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm02.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000a84fc28506e67b9f\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"TestPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000c3ea53b6e46077c0\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm02.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.31.38.10.80.39.c3.c0.4f.43.39.32\",\"{#OVMM_SERVER_NAME}\":\"ovm05\",\"{#OVMM_SERVER_IP}\":\"143.169.231.14\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm05\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000033040738f684ffd9\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm05\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.5a.57.10.80.39.c4.c0.4f.58.50.32\",\"{#OVMM_SERVER_NAME}\":\"ovm15\",\"{#OVMM_SERVER_IP}\":\"143.169.231.33\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm15\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000aad807043dbe1ac4\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"WebPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900003b25a691ee945f48\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm15\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.37.48.10.80.48.b8.c0.4f.53.47.32\",\"{#OVMM_SERVER_NAME}\":\"ovm09\",\"{#OVMM_SERVER_IP}\":\"143.169.231.23\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm09\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000057bf7362c3fd0299\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm09\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a\",\"{#OVMM_SERVER_NAME}\":\"ovm01\",\"{#OVMM_SERVER_IP}\":\"143.169.231.31\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm01.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000a84fc28506e67b9f\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"TestPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900001a95d04b1b89d455\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm01.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.46.38.10.80.59.b3.c0.4f.57.44.32\",\"{#OVMM_SERVER_NAME}\":\"ovm07\",\"{#OVMM_SERVER_IP}\":\"143.169.231.18\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm07\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000033d74b120dbb8354\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm07\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.51.34.10.80.50.c2.c0.4f.43.4d.32\",\"{#OVMM_SERVER_NAME}\":\"ovm13\",\"{#OVMM_SERVER_IP}\":\"143.169.231.29\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm13.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900006a3bc9210dccdfac\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm13.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.47.10.80.4a.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm12\",\"{#OVMM_SERVER_IP}\":\"143.169.231.28\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm12.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000071573072d52cf926\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm12.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4d.35.10.80.38.c3.c0.4f.43.39.32\",\"{#OVMM_SERVER_NAME}\":\"ovm04\",\"{#OVMM_SERVER_IP}\":\"143.169.231.13\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm04.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900000b30f10c393cd228\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm04.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.48.10.80.52.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm11\",\"{#OVMM_SERVER_IP}\":\"143.169.231.27\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm11.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000066c1bd1256cddfd5\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm11.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.53.46.10.80.4e.c8.c0.4f.51.35.32\",\"{#OVMM_SERVER_NAME}\":\"ovm03\",\"{#OVMM_SERVER_IP}\":\"143.169.231.9\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm03.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000286ddc4708165bf8\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm03.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.5a.57.10.80.37.c4.c0.4f.58.50.32\",\"{#OVMM_SERVER_NAME}\":\"ovm14\",\"{#OVMM_SERVER_IP}\":\"143.169.231.32\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm14\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000aad807043dbe1ac4\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"WebPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000bb2d953243166cb2\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm14\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.48.10.80.53.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm10\",\"{#OVMM_SERVER_IP}\":\"143.169.231.26\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm10.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000d39a80dc14baabde\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm10.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.46.37.10.80.5a.b3.c0.4f.57.44.32\",\"{#OVMM_SERVER_NAME}\":\"ovm06\",\"{#OVMM_SERVER_IP}\":\"143.169.231.17\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm06.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000086d3ddce73bf53d6\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm06.uantwerpen.be\"}]}"},{"itemid":35539,"clock":1539603456,"ns":182603910,"value":"198"},{"itemid":35541,"clock":1539603456,"ns":182671483,"value":"16455098505"},{"itemid":35542,"clock":1539603456,"ns":182723467,"value":"0.582500"},{"itemid":35543,"clock":1539603456,"ns":182737408,"value":"0.540000"},{"itemid":35544,"clock":1539603456,"ns":182748562,"value":"0.592500"},{"itemid":35545,"clock":1539603456,"ns":182792201,"value":"27252748842"},{"itemid":35546,"clock":1539603456,"ns":182797879,"value":"45.383908"},{"itemid":35547,"clock":1539603456,"ns":182800107,"value":"0.000000"},{"itemid":35548,"clock":1539603456,"ns":182801999,"value":"4.540897"},{"itemid":35549,"clock":1539603456,"ns":182803946,"value":"0.000000"},{"itemid":35550,"clock":1539603456,"ns":182806316,"value":"0.417746"},{"itemid":35551,"clock":1539603456,"ns":182808476,"value":"0.000000"},{"itemid":35552,"clock":1539603456,"ns":182810907,"value":"4.215056"},{"itemid":35553,"clock":1539603456,"ns":182813629,"value":"45.442393"},{"itemid":35555,"clock":1539603456,"ns":182815367,"value":"1539603456"},{"itemid":35556,"clock":1539603456,"ns":182821396,"value":"1480916992"},{"itemid":35557,"clock":1539603456,"ns":182825625,"value":"86.169363"},{"itemid":49959,"clock":1539603459,"ns":399207323,"value":"966502907904"},{"itemid":82839,"clock":1539603459,"ns":410880141,"value":"0.60423904657364"}],"version":"3.4.12","clock":1539603460,"ns":535779702}' 20240:20181015:133740.540 In zbx_recv_proxy_data() 20240:20181015:133740.540 In process_proxy_data() 20240:20181015:133740.540 In process_proxy_history_data_33() 20240:20181015:133740.540 In parse_history_data_33() 20240:20181015:133740.541 End of parse_history_data_33():SUCCEED processed:20/20 20240:20181015:133740.541 In process_history_data() 20240:20181015:133740.541 In zbx_preprocess_item_value() 20240:20181015:133740.541 In lld_process_discovery_rule() itemid:39071 20240:20181015:133740.541 query [txnlev:0] [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=39071] 20240:20181015:133740.541 In substitute_simple_macros() data:'30d' 20240:20181015:133740.541 query [txnlev:0] [select item_conditionid,macro,value from item_condition where itemid=39071] ... 20240:20181015:133740.545 In lld_hosts_get() 20240:20181015:133740.545 query [txnlev:0] [select hd.hostid,hd.host,hd.lastcheck,hd.ts_delete,h.host,h.name,h.proxy_hostid,h.ipmi_authtype,h.ipmi_privilege,h.ipmi_username,h.ipmi_password,hi.inventory_mode,h.tls_connect,h.tls_accept,h.tls_issuer,h.tls_subject,h.tls_psk_identity,h.tls_psk from host_discovery hd join hosts h on hd.hostid=h.hostid left join host_inventory hi on hd.hostid=hi.hostid where hd.parent_hostid=10278] 20240:20181015:133740.546 End of lld_hosts_get() 20240:20181015:133740.546 query [txnlev:0] [select groupid from group_prototype where groupid is not null and hostid=10278] 20240:20181015:133740.546 In lld_group_prototypes_get() 20240:20181015:133740.546 query [txnlev:0] [select group_prototypeid,name from group_prototype where groupid is null and hostid=10278] 20240:20181015:133740.546 End of lld_group_prototypes_get() 20238:20181015:133740.546 End of parse_history_data():SUCCEED processed:250/250 20240:20181015:133740.547 In lld_groups_get() 20240:20181015:133740.547 query [txnlev:0] [select gd.groupid,gp.group_prototypeid,gd.name,gd.lastcheck,gd.ts_delete,g.name from group_prototype gp,group_discovery gd join groups g on gd.groupid=g.groupid where gp.group_prototypeid=gd.parent_group_prototypeid and gp.hostid=10278] 20240:20181015:133740.547 End of lld_groups_get() ... 20238:20181015:133740.565 In zbx_preprocess_item_value() 20240:20181015:133740.566 In lld_host_make() 20238:20181015:133740.566 End of zbx_preprocess_item_value() 20240:20181015:133740.566 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.566 In zbx_preprocess_item_value() 20240:20181015:133740.566 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.566 End of zbx_preprocess_item_value() 20240:20181015:133740.566 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.566 In zbx_preprocess_item_value() 20240:20181015:133740.566 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.566 End of zbx_preprocess_item_value() 20240:20181015:133740.566 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.566 In zbx_preprocess_item_value() 20240:20181015:133740.567 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.567 End of zbx_preprocess_item_value() 20240:20181015:133740.567 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.567 In zbx_preprocess_item_value() 20240:20181015:133740.567 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.567 End of zbx_preprocess_item_value() 20240:20181015:133740.567 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.567 In zbx_preprocess_item_value() 20240:20181015:133740.567 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.567 End of zbx_preprocess_item_value() 20240:20181015:133740.567 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.567 In zbx_preprocess_item_value() 20240:20181015:133740.567 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.568 End of zbx_preprocess_item_value() 20240:20181015:133740.568 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.568 In zbx_preprocess_item_value() 20240:20181015:133740.568 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.568 End of zbx_preprocess_item_value() 20240:20181015:133740.568 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.568 In zbx_preprocess_item_value() 20240:20181015:133740.568 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.568 End of zbx_preprocess_item_value() 20240:20181015:133740.568 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.568 In zbx_preprocess_item_value() 20240:20181015:133740.568 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.569 End of zbx_preprocess_item_value() 20240:20181015:133740.569 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 20238:20181015:133740.569 In zbx_preprocess_item_value() 20240:20181015:133740.569 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 20238:20181015:133740.569 End of zbx_preprocess_item_value() 20240:20181015:133740.569 In substitute_lld_macros() data:'{#OVMM_SERVER_NAME}' 20238:20181015:133740.569 In zbx_preprocess_item_value() 20240:20181015:133740.569 End of substitute_lld_macros():SUCCEED data:'ovm01' 20238:20181015:133740.569 End of zbx_preprocess_item_value() 20240:20181015:133740.569 End of lld_host_make():0x5582d2ec7490 20238:20181015:133740.569 In zbx_preprocess_item_value() 20240:20181015:133740.569 In lld_groups_make() 20238:20181015:133740.569 End of zbx_preprocess_item_value() 20240:20181015:133740.569 In lld_group_make() 20238:20181015:133740.569 In zbx_preprocess_item_value() 20240:20181015:133740.570 In substitute_lld_macros() data:'Oracle VM/ServerPools/{#OVMM_SERVER_SERVERPOOL_NAME}' 20238:20181015:133740.570 End of zbx_preprocess_item_value() 20240:20181015:133740.570 End of substitute_lld_macros():SUCCEED data:'Oracle VM/ServerPools/TestPool' 20238:20181015:133740.570 In zbx_preprocess_item_value() 20240:20181015:133740.570 In substitute_lld_macros() data:'Oracle VM/ServerPools/{#OVMM_SERVER_SERVERPOOL_NAME}' 20238:20181015:133740.570 End of zbx_preprocess_item_value() 20240:20181015:133740.570 End of substitute_lld_macros():SUCCEED data:'Oracle VM/ServerPools/TestPool' 20238:20181015:133740.570 In zbx_preprocess_item_value() 20240:20181015:133740.570 End of lld_group_make():0x5582d2ec25f0 20238:20181015:133740.570 End of zbx_preprocess_item_value() 20240:20181015:133740.570 End of lld_groups_make() ... 20240:20181015:133740.597 In lld_groups_save() 20238:20181015:133740.597 In zbx_preprocess_item_value() 20240:20181015:133740.597 End of lld_groups_save() 20238:20181015:133740.597 End of zbx_preprocess_item_value() 20240:20181015:133740.597 In lld_hosts_save() 20238:20181015:133740.597 In zbx_preprocess_item_value() 20240:20181015:133740.597 query [txnlev:1] [begin;] 20238:20181015:133740.597 End of zbx_preprocess_item_value() 20238:20181015:133740.597 In zbx_preprocess_item_value() 20238:20181015:133740.597 End of zbx_preprocess_item_value() 20238:20181015:133740.597 In zbx_preprocess_item_value() 20238:20181015:133740.597 End of zbx_preprocess_item_value() 20238:20181015:133740.597 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20240:20181015:133740.598 In DBget_nextid() tablename:'hosts_groups' 20238:20181015:133740.598 In zbx_preprocess_item_value() 20240:20181015:133740.598 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20240:20181015:133740.598 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='hosts_groups' and field_name='hostgroupid'] 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20238:20181015:133740.598 End of zbx_preprocess_item_value() 20238:20181015:133740.598 In zbx_preprocess_item_value() 20240:20181015:133740.598 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 20238:20181015:133740.599 End of zbx_preprocess_item_value() 20238:20181015:133740.599 In zbx_preprocess_item_value() 20238:20181015:133740.599 End of zbx_preprocess_item_value() 20238:20181015:133740.599 In zbx_preprocess_item_value() 20238:20181015:133740.599 End of zbx_preprocess_item_value() 20238:20181015:133740.599 In zbx_preprocess_item_value() 20238:20181015:133740.599 End of zbx_preprocess_item_value() 20238:20181015:133740.599 In zbx_preprocess_item_value() 20238:20181015:133740.599 End of zbx_preprocess_item_value() 20238:20181015:133740.599 In zbx_preprocess_item_value() 20238:20181015:133740.599 End of zbx_preprocess_item_value() 20240:20181015:133740.599 End of DBget_nextid():1020 table:'hosts_groups' recid:'hostgroupid' 20238:20181015:133740.599 In zbx_preprocess_item_value() 20240:20181015:133740.599 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (1020,10577,37),(1021,10577,25); ... 20240:20181015:133740.648 [Z3005] query failed: [1062] Duplicate entry '10577-37' for key 'hosts_groups_1' [insert into hosts_groups (hostgroupid,hostid,groupid) values (1020,10577,37),(1021,10577,25);] 20240:20181015:133740.649 query [insert into hosts_groups (hostgroupid,hostid,groupid) values (1020,10577,37),(1021,10577,25);] failed, setting transaction as failed 20240:20181015:133740.649 ignoring query [txnlev:1] [delete from hosts_groups where hostgroupid in (936,1019);] within failed transaction 20240:20181015:133740.649 commit called on failed transaction, doing a rollback instead 20240:20181015:133740.649 query [txnlev:1] [rollback;] 20240:20181015:133740.651 End of lld_hosts_save() 20240:20181015:133740.651 In lld_templates_link() 20240:20181015:133740.651 End of lld_templates_link() 20240:20181015:133740.651 query [txnlev:1] [begin;] 20240:20181015:133740.651 query [txnlev:1] [update host_discovery set lastcheck=1539603460 where (hostid between 10281 and 10288 or hostid in (10401,10403,10473,10474,10506,10515,10577));] 20240:20181015:133740.651 query [txnlev:1] [commit;] 20240:20181015:133740.653 query [txnlev:1] [begin;] 20240:20181015:133740.653 query [txnlev:1] [update group_discovery set ts_delete=1542195426 where groupid=70;update group_discovery set lastcheck=1539603460 where groupid in (24,25,26,69);] 20240:20181015:133740.653 query [txnlev:1] [commit;] 20240:20181015:133740.654 End of lld_update_hosts() 20240:20181015:133740.654 End of lld_process_discovery_rule() --- Debug level 5---- --- First move: TestPool -> Unassigned --- 12795:20181015:145056.610 trapper got '{"request":"proxy data","host":"zbxprox231","history data":[{"itemid":52315,"clock":1539607855,"ns":649498446,"value":"0"},{"itemid":39071,"clock":1539607856,"ns":323826065,"value":"{\"data\":[{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.50.53.10.80.47.c7.c0.4f.53.47.32\",\"{#OVMM_SERVER_NAME}\":\"ovm08\",\"{#OVMM_SERVER_IP}\":\"143.169.231.21\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm08.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900008f68a4d47a7c2fdb\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm08.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.51.47.10.80.4d.c3.c0.4f.51.35.32\",\"{#OVMM_SERVER_NAME}\":\"ovm02\",\"{#OVMM_SERVER_IP}\":\"143.169.231.8\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm02.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000a84fc28506e67b9f\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"TestPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000c3ea53b6e46077c0\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm02.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.31.38.10.80.39.c3.c0.4f.43.39.32\",\"{#OVMM_SERVER_NAME}\":\"ovm05\",\"{#OVMM_SERVER_IP}\":\"143.169.231.14\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm05\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000033040738f684ffd9\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm05\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.5a.57.10.80.39.c4.c0.4f.58.50.32\",\"{#OVMM_SERVER_NAME}\":\"ovm15\",\"{#OVMM_SERVER_IP}\":\"143.169.231.33\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm15\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000aad807043dbe1ac4\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"WebPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900003b25a691ee945f48\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm15\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.37.48.10.80.48.b8.c0.4f.53.47.32\",\"{#OVMM_SERVER_NAME}\":\"ovm09\",\"{#OVMM_SERVER_IP}\":\"143.169.231.23\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm09\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000057bf7362c3fd0299\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm09\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a\",\"{#OVMM_SERVER_NAME}\":\"ovm01\",\"{#OVMM_SERVER_IP}\":\"143.169.231.31\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm01.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"Unassigned\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"Unassigned\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900001a95d04b1b89d455\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm01.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.46.38.10.80.59.b3.c0.4f.57.44.32\",\"{#OVMM_SERVER_NAME}\":\"ovm07\",\"{#OVMM_SERVER_IP}\":\"143.169.231.18\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm07\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000033d74b120dbb8354\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm07\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.51.34.10.80.50.c2.c0.4f.43.4d.32\",\"{#OVMM_SERVER_NAME}\":\"ovm13\",\"{#OVMM_SERVER_IP}\":\"143.169.231.29\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm13.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900006a3bc9210dccdfac\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm13.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.47.10.80.4a.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm12\",\"{#OVMM_SERVER_IP}\":\"143.169.231.28\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm12.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000071573072d52cf926\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm12.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4d.35.10.80.38.c3.c0.4f.43.39.32\",\"{#OVMM_SERVER_NAME}\":\"ovm04\",\"{#OVMM_SERVER_IP}\":\"143.169.231.13\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm04.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900000b30f10c393cd228\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm04.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.48.10.80.52.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm11\",\"{#OVMM_SERVER_IP}\":\"143.169.231.27\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm11.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000066c1bd1256cddfd5\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm11.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.53.46.10.80.4e.c8.c0.4f.51.35.32\",\"{#OVMM_SERVER_NAME}\":\"ovm03\",\"{#OVMM_SERVER_IP}\":\"143.169.231.9\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm03.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000286ddc4708165bf8\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm03.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.5a.57.10.80.37.c4.c0.4f.58.50.32\",\"{#OVMM_SERVER_NAME}\":\"ovm14\",\"{#OVMM_SERVER_IP}\":\"143.169.231.32\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm14\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000aad807043dbe1ac4\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"WebPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000bb2d953243166cb2\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm14\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.48.10.80.53.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm10\",\"{#OVMM_SERVER_IP}\":\"143.169.231.26\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm10.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000d39a80dc14baabde\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm10.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.46.37.10.80.5a.b3.c0.4f.57.44.32\",\"{#OVMM_SERVER_NAME}\":\"ovm06\",\"{#OVMM_SERVER_IP}\":\"143.169.231.17\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm06.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000086d3ddce73bf53d6\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm06.uantwerpen.be\"}]}"}],"version":"3.4.12","clock":1539607856,"ns":606893663}' 12795:20181015:145056.610 In zbx_recv_proxy_data() 12795:20181015:145056.611 In process_proxy_data() 12795:20181015:145056.611 In process_proxy_history_data_33() 12795:20181015:145056.611 In parse_history_data_33() 12795:20181015:145056.611 End of parse_history_data_33():SUCCEED processed:2/2 12795:20181015:145056.611 In process_history_data() 12795:20181015:145056.611 In zbx_preprocess_item_value() 12795:20181015:145056.611 End of zbx_preprocess_item_value() 12795:20181015:145056.611 In zbx_preprocess_item_value() 12795:20181015:145056.611 In lld_process_discovery_rule() itemid:39071 12795:20181015:145056.611 query [txnlev:0] [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=39071] 12795:20181015:145056.611 In substitute_simple_macros() data:'30d' 12795:20181015:145056.611 query [txnlev:0] [select item_conditionid,macro,value from item_condition where itemid=39071] ... 12795:20181015:145056.617 In lld_host_make() 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12795:20181015:145056.617 In substitute_lld_macros() data:'{#OVMM_SERVER_NAME}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'ovm01' 12795:20181015:145056.617 End of lld_host_make():0x5564f361c2c0 12795:20181015:145056.617 In lld_groups_make() 12795:20181015:145056.617 In lld_group_make() 12795:20181015:145056.617 In substitute_lld_macros() data:'Oracle VM/ServerPools/{#OVMM_SERVER_SERVERPOOL_NAME}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'Oracle VM/ServerPools/Unassigned' 12795:20181015:145056.617 In substitute_lld_macros() data:'Oracle VM/ServerPools/{#OVMM_SERVER_SERVERPOOL_NAME}' 12795:20181015:145056.617 End of substitute_lld_macros():SUCCEED data:'Oracle VM/ServerPools/Unassigned' 12795:20181015:145056.617 End of lld_group_make():0x5564f361cb10 12795:20181015:145056.617 End of lld_groups_make() ... 12795:20181015:145056.621 In lld_hosts_save() 12795:20181015:145056.621 query [txnlev:1] [begin;] 12795:20181015:145056.621 In DBget_nextid() tablename:'hosts_groups' 12795:20181015:145056.621 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 12795:20181015:145056.621 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='hosts_groups' and field_name='hostgroupid'] 12795:20181015:145056.621 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 12795:20181015:145056.621 End of DBget_nextid():1023 table:'hosts_groups' recid:'hostgroupid' ... 12795:20181015:145056.622 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (1023,10669,70);] 12795:20181015:145056.622 query [txnlev:1] [delete from hosts_groups where hostgroupid=1021;] 12795:20181015:145056.622 query [txnlev:1] [commit;] 12795:20181015:145056.623 End of lld_hosts_save() 12795:20181015:145056.623 In lld_templates_link() 12795:20181015:145056.623 End of lld_templates_link() 12795:20181015:145056.623 query [txnlev:1] [begin;] 12795:20181015:145056.623 query [txnlev:1] [update host_discovery set lastcheck=1539607856 where (hostid between 10281 and 10288 or hostid in (10401,10403,10473,10474,10506,10515,10669));] 12795:20181015:145056.624 query [txnlev:1] [commit;] 12795:20181015:145056.625 query [txnlev:1] [begin;] 12795:20181015:145056.625 query [txnlev:1] [update group_discovery set lastcheck=1539607856 where groupid in (24,25,26,69,70);update group_discovery set ts_delete=0 where groupid=70;] 12795:20181015:145056.625 query [txnlev:1] [commit;] 12795:20181015:145056.627 End of lld_update_hosts() 12795:20181015:145056.627 End of lld_process_discovery_rule() --- Second move: Unassigned -> Testpool --- 12792:20181015:145129.107 trapper got '{"request":"proxy data","host":"zbxprox231","history data":[{"itemid":39071,"clock":1539607886,"ns":962869240,"value":"{\"data\":[{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.50.53.10.80.47.c7.c0.4f.53.47.32\",\"{#OVMM_SERVER_NAME}\":\"ovm08\",\"{#OVMM_SERVER_IP}\":\"143.169.231.21\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm08.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900008f68a4d47a7c2fdb\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm08.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.51.47.10.80.4d.c3.c0.4f.51.35.32\",\"{#OVMM_SERVER_NAME}\":\"ovm02\",\"{#OVMM_SERVER_IP}\":\"143.169.231.8\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm02.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000a84fc28506e67b9f\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"TestPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000c3ea53b6e46077c0\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm02.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.31.38.10.80.39.c3.c0.4f.43.39.32\",\"{#OVMM_SERVER_NAME}\":\"ovm05\",\"{#OVMM_SERVER_IP}\":\"143.169.231.14\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm05\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000033040738f684ffd9\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm05\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.5a.57.10.80.39.c4.c0.4f.58.50.32\",\"{#OVMM_SERVER_NAME}\":\"ovm15\",\"{#OVMM_SERVER_IP}\":\"143.169.231.33\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm15\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000aad807043dbe1ac4\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"WebPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900003b25a691ee945f48\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm15\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.37.48.10.80.48.b8.c0.4f.53.47.32\",\"{#OVMM_SERVER_NAME}\":\"ovm09\",\"{#OVMM_SERVER_IP}\":\"143.169.231.23\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm09\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000057bf7362c3fd0299\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm09\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a\",\"{#OVMM_SERVER_NAME}\":\"ovm01\",\"{#OVMM_SERVER_IP}\":\"143.169.231.31\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm01.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000a84fc28506e67b9f\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"TestPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900001a95d04b1b89d455\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm01.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.46.38.10.80.59.b3.c0.4f.57.44.32\",\"{#OVMM_SERVER_NAME}\":\"ovm07\",\"{#OVMM_SERVER_IP}\":\"143.169.231.18\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm07\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000033d74b120dbb8354\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm07\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.51.34.10.80.50.c2.c0.4f.43.4d.32\",\"{#OVMM_SERVER_NAME}\":\"ovm13\",\"{#OVMM_SERVER_IP}\":\"143.169.231.29\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm13.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900006a3bc9210dccdfac\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm13.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.47.10.80.4a.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm12\",\"{#OVMM_SERVER_IP}\":\"143.169.231.28\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm12.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000071573072d52cf926\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm12.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4d.35.10.80.38.c3.c0.4f.43.39.32\",\"{#OVMM_SERVER_NAME}\":\"ovm04\",\"{#OVMM_SERVER_IP}\":\"143.169.231.13\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm04.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb00000900000b30f10c393cd228\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm04.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.48.10.80.52.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm11\",\"{#OVMM_SERVER_IP}\":\"143.169.231.27\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm11.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000066c1bd1256cddfd5\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm11.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.53.46.10.80.4e.c8.c0.4f.51.35.32\",\"{#OVMM_SERVER_NAME}\":\"ovm03\",\"{#OVMM_SERVER_IP}\":\"143.169.231.9\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm03.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000286ddc4708165bf8\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm03.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.5a.57.10.80.37.c4.c0.4f.58.50.32\",\"{#OVMM_SERVER_NAME}\":\"ovm14\",\"{#OVMM_SERVER_IP}\":\"143.169.231.32\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm14\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb0000020000aad807043dbe1ac4\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"WebPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000bb2d953243166cb2\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm14\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.4e.48.10.80.53.b9.c0.4f.59.4a.32\",\"{#OVMM_SERVER_NAME}\":\"ovm10\",\"{#OVMM_SERVER_IP}\":\"143.169.231.26\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm10.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb000002000087bc2a148f2c6961\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"DevPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb0000090000d39a80dc14baabde\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm10.uantwerpen.be\"},{\"{#OVMM_SERVER_ID}\":\"4c.4c.45.44.00.46.37.10.80.5a.b3.c0.4f.57.44.32\",\"{#OVMM_SERVER_NAME}\":\"ovm06\",\"{#OVMM_SERVER_IP}\":\"143.169.231.17\",\"{#OVMM_SERVER_HOSTNAME}\":\"ovm06.uantwerpen.be\",\"{#OVMM_SERVER_SERVERPOOL_ID}\":\"0004fb00000200006c9e1f55a97fdcdd\",\"{#OVMM_SERVER_SERVERPOOL_NAME}\":\"SysPool\",\"{#OVMM_SERVER_LOCAL_FILESERVER_ID}\":\"0004fb000009000086d3ddce73bf53d6\",\"{#OVMM_SERVER_LOCAL_FILESERVER_NAME}\":\"Local FS ovm06.uantwerpen.be\"}]}"},{"itemid":49887,"clock":1539607887,"ns":484160151,"value":"0"},{"itemid":28287,"clock":1539607887,"ns":484229376,"value":"99.999428"}],"version":"3.4.12","clock":1539607889,"ns":103451530}' 12792:20181015:145129.107 In zbx_recv_proxy_data() 12792:20181015:145129.107 In process_proxy_data() 12792:20181015:145129.107 In process_proxy_history_data_33() 12792:20181015:145129.107 In parse_history_data_33() 12792:20181015:145129.108 End of parse_history_data_33():SUCCEED processed:3/3 12792:20181015:145129.108 In process_history_data() 12792:20181015:145129.108 In zbx_preprocess_item_value() 12792:20181015:145129.108 In lld_process_discovery_rule() itemid:39071 12792:20181015:145129.108 query [txnlev:0] [select hostid,key_,state,evaltype,formula,error,lifetime from items where itemid=39071] 12792:20181015:145129.108 In substitute_simple_macros() data:'30d' 12792:20181015:145129.108 query [txnlev:0] [select item_conditionid,macro,value from item_condition where itemid=39071] ... 12792:20181015:145129.114 In lld_host_make() 12792:20181015:145129.114 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_ID}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'4c.4c.45.44.00.4b.36.10.80.58.c2.c0.4f.43.35.4a' 12792:20181015:145129.115 In substitute_lld_macros() data:'{#OVMM_SERVER_NAME}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'ovm01' 12792:20181015:145129.115 End of lld_host_make():0x5564f3617ac0 12792:20181015:145129.115 In lld_groups_make() 12792:20181015:145129.115 In lld_group_make() 12792:20181015:145129.115 In substitute_lld_macros() data:'Oracle VM/ServerPools/{#OVMM_SERVER_SERVERPOOL_NAME}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'Oracle VM/ServerPools/TestPool' 12792:20181015:145129.115 In substitute_lld_macros() data:'Oracle VM/ServerPools/{#OVMM_SERVER_SERVERPOOL_NAME}' 12792:20181015:145129.115 End of substitute_lld_macros():SUCCEED data:'Oracle VM/ServerPools/TestPool' 12792:20181015:145129.115 End of lld_group_make():0x5564f3620aa0 12792:20181015:145129.115 End of lld_groups_make() ... 12792:20181015:145129.120 In lld_groups_save() 12792:20181015:145129.120 End of lld_groups_save() 12792:20181015:145129.120 In lld_hosts_save() 12792:20181015:145129.120 query [txnlev:1] [begin;] 12792:20181015:145129.120 In DBget_nextid() tablename:'hosts_groups' 12792:20181015:145129.120 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 12792:20181015:145129.120 query [txnlev:1] [update ids set nextid=nextid+2 where table_name='hosts_groups' and field_name='hostgroupid'] 12792:20181015:145129.120 query [txnlev:1] [select nextid from ids where table_name='hosts_groups' and field_name='hostgroupid'] 12792:20181015:145129.120 End of DBget_nextid():1024 table:'hosts_groups' recid:'hostgroupid' 12792:20181015:145129.120 query [txnlev:1] [insert into hosts_groups (hostgroupid,hostid,groupid) values (1024,10669,37),(1025,10669,25);] 12792:20181015:145129.120 [Z3005] query failed: [1062] Duplicate entry '10669-37' for key 'hosts_groups_1' [insert into hosts_groups (hostgroupid,hostid,groupid) values (1024,10669,37),(1025,10669,25);] 12792:20181015:145129.120 query [insert into hosts_groups (hostgroupid,hostid,groupid) values (1024,10669,37),(1025,10669,25);] failed, setting transaction as failed 12792:20181015:145129.120 ignoring query [txnlev:1] [delete from hosts_groups where hostgroupid in (1020,1023);] within failed transaction 12792:20181015:145129.120 commit called on failed transaction, doing a rollback instead 12792:20181015:145129.120 query [txnlev:1] [rollback;] 12792:20181015:145129.122 End of lld_hosts_save() 12792:20181015:145129.122 In lld_templates_link() 12792:20181015:145129.122 End of lld_templates_link() 12792:20181015:145129.122 query [txnlev:1] [begin;] 12792:20181015:145129.122 query [txnlev:1] [update host_discovery set lastcheck=1539607889 where (hostid between 10281 and 10288 or hostid in (10401,10403,10473,10474,10506,10515,10669));] 12792:20181015:145129.123 query [txnlev:1] [commit;] 12792:20181015:145129.124 query [txnlev:1] [begin;] 12792:20181015:145129.124 query [txnlev:1] [update group_discovery set ts_delete=1542199856 where groupid=70;update group_discovery set lastcheck=1539607889 where groupid in (24,25,26,69);] 12792:20181015:145129.124 query [txnlev:1] [commit;] 12792:20181015:145129.127 End of lld_update_hosts() 12792:20181015:145129.127 End of lld_process_discovery_rule()