-
Incident report
-
Resolution: Unresolved
-
Major
-
None
-
None
-
None
-
Red Hat Enterprise Linux Server release 7.3 (Maipo)
Hi.
After fresh installation zabbix proxy, we have error after add proxy server in web interface Administration -> Proxies -> Create Proxy
in log /tmp/zabbix_proxy.log we see
83065:20170719:151612.072 query without transaction detected 83065:20170719:151612.072 query [txnlev:0] [alter session set nls_numeric_characters='. '] 83065:20170719:151612.072 End of DBconnect():0 83065:20170719:151612.072 __zbx_zbx_setproctitle() title:'configuration syncer [loading configuration]' 83065:20170719:151612.072 In process_configuration_sync() 83065:20170719:151612.073 In connect_to_server() [kzlzabbix01.eub.kz]:10051 [timeout:600] 83065:20170719:151612.075 In get_data_from_server() request:'proxy config' 83065:20170719:151612.086 Received [{"globalmacro":{"fields":["globalmacroid","macro","value"],"data":[[2,"{$SNMP_COMMUNITY}","public"]]},"hosts":{"fields":["hostid","host","status","ipmi_authtype","ip mi_privilege","ipmi_username","ipmi_password","name","tls_connect","tls_accept","tls_issuer","tls_subject","tls_psk_identity","tls_psk"],"data":[]},"interface":{"fields":["interfaceid","hostid","main"," type","useip","ip","dns","port","bulk"],"data":[]},"hosts_templates":{"fields":["hosttemplateid","hostid","templateid"],"data":[]},"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","snmp v3_privpassphrase","lastlogsize","logtimefmt","delay_flex","params","ipmi_sensor","data_type","authtype","username","password","publickey","privatekey","mtime","flags","interfaceid","port","snmpv3_authp rotocol","snmpv3_privprotocol","snmpv3_contextname"],"data":[]},"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":{"fie lds":["regexpid","name"],"data":[[1,"File systems for discovery"],[2,"Network interfaces for discovery"],[3,"Storage devices for SNMP discovery"],[4,"Windows service names for discovery"],[5,"Windows se rvice startup states for discovery"]]},"expressions":{"fields":["expressionid","regexpid","expression","expression_type","exp_delimiter","case_sensitive"],"data":[[1,1,"^(btrfs|ext2|ext3|ext4|jfs|reiser |xfs|ffs|ufs|jfs|jfs2|vxfs|hfs|refs|ntfs|fat32|zfs)$",3,",",0],[2,2,"^lo$",4,",",1],[3,3,"^(Physical memory|Virtual memory|Memory buffers|Cached memory|Swap space)$",4,",",1],[4,2,"^Software Loopback In terface",4,",",1],[5,4,"^(MMCSS|gupdate|SysmonLog|clr_optimization_v2.0.50727_32|clr_optimization_v4.0.30319_32)$",4,",",1],[6,5,"^(automatic|automatic delayed)$",3,",",1],[7,2,"^WAN Miniport",4,",",1], [8,2,"^Microsoft ISATAP",4,",",0],[9,2,"^RAS Async Adapter",4,",",0],[10,2,"^Microsoft Kernel Debug Network Adapter",4,",",0],[11,2,"^Microsoft Teredo Tunneling Adapter",4,",",0],[12,2,"^Default Minipor t",4,",",0],[13,2,"QoS Packet Scheduler",2,",",0],[14,2,"LightWeight Filter",2,",",0],[15,2,"Light-Weight Filter",2,",",0],[16,2,"^Teredo Tunneling",4,",",0],[17,2,"Default Miniport",2,",",0],[18,2,"^is atap",4,",",0],[19,4,"MSSQL|SQLAgent|SQLS|ReportServer|SMSGate",3,",",0],[22,4,"SQLAgent$SQLEXPRESS",2,",",0]]},"groups":{"fields":["groupid"],"data":[[5]]},"config":{"fields":["configid","refresh_unsup ported","discovery_groupid","snmptrap_logging"],"data":[[1,600,5,1]]},"httptest":{"fields":["httptestid","name","delay","variables","agent","authentication","http_user","http_password","hostid","http_pr oxy","retries","ssl_cert_file","ssl_key_file","ssl_key_password","verify_peer","verify_host","headers"],"data":[]},"httptestitem":{"fields":["httptestitemid","httptestid","itemid","type"],"data":[]},"ht tpstep":{"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":[]}}] from server 83065:20170719:151612.087 End of get_data_from_server():SUCCEED 83065:20170719:151612.087 received configuration data from server at "kzlzabbix01.eub.kz", datalen 3455 83065:20170719:151612.087 In process_proxyconfig() 83065:20170719:151612.087 In process_proxyconfig_table() table:'globalmacro' 83065:20170719:151612.087 query [txnlev:1] [select globalmacroid,macro,value from globalmacro] 83065:20170719:151612.088 query [txnlev:1] [insert into globalmacro (globalmacroid,macro,value) values (:1,:2,:3)] 83065:20170719:151612.088 insert [txnlev:1] [2,'{$SNMP_COMMUNITY}','public'] 83065:20170719:151612.090 zbx_db_statement_execute():1 83065:20170719:151612.090 End of process_proxyconfig_table():FAIL 83065:20170719:151612.093 failed to update local proxy configuration copy: database error 83065:20170719:151612.093 End of process_proxyconfig() 83065:20170719:151612.093 End of process_configuration_sync()
- duplicates
-
ZBX-12142 Zabbix database upgrade from 3.0.3 to 3.2.5 fails with oracle db backend in use
- Closed