Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-12395

failed to update local proxy configuration copy: database error

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Proxy (P)
    • Labels:
      None
    • Environment:
      Red Hat Enterprise Linux Server release 7.3 (Maipo)

      Description

      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()
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              andrey.balagansky Andrey
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: