5881:20150206:100603.430 trapper got '{"request":"proxy config","data":{"globalmacro":{"fields":["globalmacroid","macro","value"],"data":[]},"hosts":{"fields":["hostid","host","status","ipmi_authtype","ipmi_privilege","ipmi_username","ipmi_password","name"],"data":[[10328,"Template_Ping2",3,0,2,"","","Template_Ping2"],[11104,"nlb.zumis.lt",0,-1,2,"","","nlb"]]},"interface":{"fields":["interfaceid","hostid","main","type","useip","ip","dns","port","bulk"],"data":[[32249,11104,1,1,1,"10.25.2.48","nlb.zumis.lt","10050",1]]},"hosts_templates":{"fields":["hosttemplateid","hostid","templateid"],"data":[[1310,11104,10328]]},"hostmacro":{"fields":["hostmacroid","hostid","macro","value"],"data":[]},"items":{"fields":["itemid","type","snmp_community","snmp_oid","hostid","key_","delay","status","value_type","trapper_hosts","snmpv3_securityname","snmpv3_securitylevel","snmpv3_authpassphrase","snmpv3_privpassphrase","logtimefmt","delay_flex","params","ipmi_sensor","data_type","authtype","username","password","publickey","privatekey","flags","interfaceid","port","snmpv3_authprotocol","snmpv3_privprotocol","snmpv3_contextname"],"data":[[104424,3,"public","interfaces.ifTable.ifEntry.ifInOctets.1",11104,"icmpping",300,0,3,"","",0,"","","","","DSN=<database source name>\\nuser=<user name>\\npassword=<password>\\nsql=<query>","",0,0,"","","","",0,32249,"",0,0,""],[104425,3,"public","interfaces.ifTable.ifEntry.ifInOctets.1",11104,"icmppingsec",300,0,0,"","",0,"","","","","DSN=<database source name>\\nuser=<user name>\\npassword=<password>\\nsql=<query>","",0,0,"","","","",0,32249,"",0,0,""]]},"drules":{"fields":["druleid","name","iprange","delay"],"data":[]},"dchecks":{"fields":["dcheckid","druleid","type","key_","snmp_community","ports","snmpv3_securityname","snmpv3_securitylevel","snmpv3_authpassphrase","snmpv3_privpassphrase","uniq","snmpv3_authprotocol","snmpv3_privprotocol","snmpv3_contextname"],"data":[]},"regexps":{"fields":["regexpid","name"],"data":[]},"expressions":{"fields":["expressionid","regexpid","expression","expression_type","exp_delimiter","case_sensitive"],"data":[]},"groups":{"fields":["groupid"],"data":[]},"config":{"fields":["configid","refresh_unsupported","discovery_groupid","snmptrap_logging"],"data":[[1,600,0,1]]},"httptest":{"fields":["httptestid","name","delay","variables","agent","authentication","http_user","http_password","hostid","http_proxy","retries","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host","headers"],"data":[]},"httptestitem":{"fields":["httptestitemid","httptestid","itemid","type"],"data":[]},"httpstep":{"fields":["httpstepid","httptestid","name","no","url","timeout","posts","required","status_codes","variables","follow_redirects","retrieve_mode","headers"],"data":[]},"httpstepitem":{"fields":["httpstepitemid","httpstepid","itemid","type"],"data":[]}}}'
  5881:20150206:100603.430 received configuration data from server, datalen 2816
  5881:20150206:100603.430 In recv_proxyconfig()
  5881:20150206:100603.430 In process_proxyconfig()
  5881:20150206:100603.430 query [txnlev:1] [begin;]
  5881:20150206:100603.430 In process_proxyconfig_table() table:'globalmacro'
  5881:20150206:100603.431 query [txnlev:1] [select globalmacroid,macro,value from globalmacro]
  5881:20150206:100603.431 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.431 In process_proxyconfig_table() table:'hosts'
  5881:20150206:100603.432 query [txnlev:1] [select hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name from hosts]
  5881:20150206:100603.432 query [txnlev:1] [insert into hosts (hostid,host,status,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,name,description) values (10328,'Template_Ping2',3,0,2,'','','Template_Ping2',''),(11104,'nlb.zumis.lt',0,-1,2,'','','nlb','');
]
  5881:20150206:100603.433 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.433 In process_proxyconfig_table() table:'interface'
  5881:20150206:100603.433 query [txnlev:1] [select interfaceid,hostid,main,type,useip,ip,dns,port,bulk from interface]
  5881:20150206:100603.434 query [txnlev:1] [insert into interface (interfaceid,hostid,main,type,useip,ip,dns,port,bulk) values (32249,11104,1,1,1,'10.25.2.48','nlb.zumis.lt','10050',1);
]
  5881:20150206:100603.434 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.434 In process_proxyconfig_table() table:'hosts_templates'
  5881:20150206:100603.435 query [txnlev:1] [select hosttemplateid,hostid,templateid from hosts_templates]
  5881:20150206:100603.435 query [txnlev:1] [insert into hosts_templates (hosttemplateid,hostid,templateid) values (1310,11104,10328);
]
  5881:20150206:100603.435 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.435 In process_proxyconfig_table() table:'hostmacro'
  5881:20150206:100603.436 query [txnlev:1] [select hostmacroid,hostid,macro,value from hostmacro]
  5881:20150206:100603.436 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.436 In process_proxyconfig_table() table:'items'
  5881:20150206:100603.436 query [txnlev:1] [select itemid,type,snmp_community,snmp_oid,hostid,key_,delay,status,value_type,trapper_hosts,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,logtimefmt,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,interfaceid,port,snmpv3_authprotocol,snmpv3_privprotocol,snmpv3_contextname from items]
  5881:20150206:100603.437 query [txnlev:1] [insert into items (itemid,type,snmp_community,snmp_oid,hostid,key_,delay,status,value_type,trapper_hosts,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,logtimefmt,delay_flex,params,ipmi_sensor,data_type,authtype,username,password,publickey,privatekey,flags,interfaceid,port,snmpv3_authprotocol,snmpv3_privprotocol,snmpv3_contextname,description) values (104424,3,'public','interfaces.ifTable.ifEntry.ifInOctets.1',11104,'icmpping',300,0,3,'','',0,'','','','','DSN=<database source name>\\nuser=<user name>\\npassword=<password>\\nsql=<query>','',0,0,'','','','',0,32249,'',0,0,'',''),(104425,3,'public','interfaces.ifTable.ifEntry.ifInOctets.1',11104,'icmppingsec',300,0,0,'','',0,'','','','','DSN=<database source name>\\nuser=<user name>\\npassword=<password>\\nsql=<query>','',0,0,'','','','',0,32249,'',0,0,'','');
]
  5881:20150206:100603.438 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.438 In process_proxyconfig_table() table:'drules'
  5881:20150206:100603.438 query [txnlev:1] [select druleid,name,iprange,delay from drules]
  5881:20150206:100603.438 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.439 In process_proxyconfig_table() table:'dchecks'
  5881:20150206:100603.439 query [txnlev:1] [select dcheckid,druleid,type,key_,snmp_community,ports,snmpv3_securityname,snmpv3_securitylevel,snmpv3_authpassphrase,snmpv3_privpassphrase,uniq,snmpv3_authprotocol,snmpv3_privprotocol,snmpv3_contextname from dchecks]
  5881:20150206:100603.439 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.439 In process_proxyconfig_table() table:'regexps'
  5881:20150206:100603.439 query [txnlev:1] [select regexpid,name from regexps]
  5881:20150206:100603.440 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.440 In process_proxyconfig_table() table:'expressions'
  5881:20150206:100603.440 query [txnlev:1] [select expressionid,regexpid,expression,expression_type,exp_delimiter,case_sensitive from expressions]
  5881:20150206:100603.441 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.441 In process_proxyconfig_table() table:'groups'
  5881:20150206:100603.441 query [txnlev:1] [select groupid from groups]
  5881:20150206:100603.441 End of process_proxyconfig_table():SUCCEED
  5881:20150206:100603.441 In process_proxyconfig_table() table:'config'
  5881:20150206:100603.441 query [txnlev:1] [select configid,refresh_unsupported,discovery_groupid,snmptrap_logging from config]
  5881:20150206:100603.442 query [txnlev:1] [insert into config (configid,refresh_unsupported,discovery_groupid,snmptrap_logging) values (1,600,null,1);
]
  5881:20150206:100603.442 [Z3005] query failed: [1048] Column 'discovery_groupid' cannot be null [insert into config (configid,refresh_unsupported,discovery_groupid,snmptrap_logging) values (1,600,null,1);
]
  5881:20150206:100603.442 query [insert into config (configid,refresh_unsupported,discovery_groupid,snmptrap_logging) values (1,600,null,1);
] failed, setting transaction as failed
  5881:20150206:100603.442 End of process_proxyconfig_table():FAIL
  5881:20150206:100603.442 query [txnlev:1] [rollback;]
  5881:20150206:100603.443 failed to update local proxy configuration copy: database error
  5881:20150206:100603.444 End of process_proxyconfig()