Ad Widget

Collapse

Critical: After upgrade zabbix proxy isn't updating configs from server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zabbixfk
    Senior Member
    • Jun 2013
    • 256

    #1

    Critical: After upgrade zabbix proxy isn't updating configs from server

    Hello All,

    Recently i had upgraded zabbix instances from 2.0.6 to 2.2.12. Upgrade went smoother, no issues at all, followed the guide and all was fine.
    Now there seems to be a strange behaviour from existing zabbix proxy instances. It's just not updating the configs received by the server. Its not even adding new configs. I can see in the server logs that configs are sent via json and i can see that proxy recieves these configs, but in the json array 'sending data to server' it still uses old enters to send.
    For example:
    - i have a n/w devices ( example router) - which had configured with interface port6 to be monitored, so oid for incoming traffic looks like
    Code:
    .1.3.6.1.2.1.2.2.1.10.515
    considering 515 is my SNMP Index number. Now for some reason i wanted it to changed to port7, so SNMP index becomes 516, and so is OID. When i change this from the Zabbix Server UI, it changes and sits in db. And changed config gets sent using
    Code:
    18128:20160510:174112.574 sending configuration data to proxy "zbx-proxy2", datalen 1190436
    also changed config gets received on the proxy under
    Code:
    12333:20160510:174011.893 Received [{
        "globalmacro":{
    - But i fail to understand why config changes are not getting applied?
    - In proxy db, i still see older entries and they are gone in server.
    - As proxy still has older entries, it still sends data using older index ( as that index does not exists since port changed, it sends no such instance exists in this OID , which is ok)
    - Even if i delete that interface from the template, it immediately reflects in server , but its stays in proxy.
    - When i add new item entry in template, it reflects in server, but proxy still has entry which got deleted in server, and misses new entry which added in server ( though config is sent by server/received by proxy).
    - Untouched configs from server is working via proxy though. That means, proxy seems to be working, but its failing to update the configs passed from server thus monitoring is gone for toss

    This is critical as when i update something in server its not getting reflected in proxy ( so is delete / addition of new items/templates) etc - which tosses up existing monitoring environment.

    Please help me. Throw me some pointers.

    Here are the details.
    - Server :
    Code:
    2.6.32-279.el6.x86_64  , CentOS 6.3, 64G, 24Core
    MySql: 5.1.73-log, httpd : Apache/2.2.15
    Server config zabbix_server.conf:
    Code:
    LogFile=/var/log/zabbix/zabbix_server.log
    LogFileSize=500
    DebugLevel=4
    PidFile=/var/run/zabbix/zabbix_server.pid
    DBName=zabbix
    DBUser=zabbix
    DBPassword=zabbix
    StartPollers=130
    StartPollersUnreachable=45
    StartTrappers=60
    StartPingers=90
    StartDiscoverers=1
    StartSNMPTrapper=1
    ListenIP=0.0.0.0
    HousekeepingFrequency=2
    MaxHousekeeperDelete=300
    SenderFrequency=360
    CacheSize=1G
    CacheUpdateFrequency=300
    StartDBSyncers=13
    HistoryCacheSize=256M
    TrendCacheSize=1G
    HistoryTextCacheSize=256M
    Timeout=30
    TrapperTimeout=180
    UnreachablePeriod=600
    UnavailableDelay=120
    AlertScriptsPath=/etc/zabbix/alert.d/
    FpingLocation=/usr/local/sbin/fping
    LogSlowQueries=5
    ProxyDataFrequency=180
    Server MySql config:
    Code:
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    symbolic-links=0
    slow_query_log_file=/var/log/mysql/slow-query.log
    long_query_time = 10
    log-queries-not-using-indexes=YES
    innodb_lock_wait_timeout=500
    innodb_locks_unsafe_for_binlog=1
    expire_logs_days=5
    max_binlog_size=100M
    innodb_file_per_table
    innodb_flush_method=O_DIRECT
    innodb_log_file_size=1G
    innodb_buffer_pool_size=24G
    innodb_file_per_table
    max_allowed_packet = 64M
    innodb_additional_mem_pool_size = 30M
    innodb_thread_concurrency = 8
    key_buffer_size = 60M
    max_connections=375
    table_cache=4096
    query_cache_size = 96M
    tmp_table_size = 32M
    thread_cache_size = 64
    sort_buffer_size = 12M
    query_cache_limit=64M
    thread_cache_size=512
    read_buffer_size=2M
    read_rnd_buffer_size=8M
    join_buffer_size=8M
    log-bin=/var/log/mysql/mysql-bin.log
    binlog-do-db=zabbix
    server-id=3
    [mysqld_safe]
    log-error=/var/log/mysql/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    Proxy config:
    Code:
    2.6.32-279.el6.x86_64 , CentOS 6.3, 10G Ram, 6core CPU
    MySqld: 5.1.73
    Proxy config zabbix_proxy.conf
    Code:
    Server=netmon.internal.com
    Hostname=zbx-proxy2
    LogFile=/var/log/zabbix/zabbix_proxy.log
    LogFileSize=325
    DebugLevel=4
    PidFile=/var/run/zabbix/zabbix_proxy.pid
    DBName=zabbix
    DBUser=zabbix
    DBPassword=zabbix
    ProxyLocalBuffer=4
    ProxyOfflineBuffer=12
    ConfigFrequency=60
    DataSenderFrequency=10
    StartPollers=182
    StartPollersUnreachable=75
    StartTrappers=45
    StartPingers=95
    StartSNMPTrapper=1
    CacheSize=1G
    StartDBSyncers=45
    HistoryCacheSize=1G
    HistoryTextCacheSize=256M
    Timeout=30
    UnreachablePeriod=75
    FpingLocation=/usr/sbin/fping
    Fping6Location=/usr/sbin/fping6
    LogSlowQueries=3000
    In Administration ->DM -> Proxies
    Code:
    Name                Mode        LastSeen  HostCount   ItemCount  Required performance (vps)	
    zbx-proxy2	Active	10s	       976	        4781	          21.05
    In Administration->Queue
    Code:
    Proxy	       5 seconds	10 seconds	30 seconds	1 minute	5 minutes	More than 10 minutes
    zbx-proxy2	75	         115	            69	              366	      2         	25
    Please let me know if anything is missing / needed. Any pointers are greatly appreciated.

    Thanks.
  • zabbixfk
    Senior Member
    • Jun 2013
    • 256

    #2
    Critical: After upgrade zabbix proxy isn't updating configs from server

    Update:
    I stopped zabbix proxy, truncated whole database, created from scratch. Added only schema.sql, and tried to bring up proxy, but its failing with multiple duplicate entry errors to items table, and its saying 'failed to update local proxy configuration copy: database error'
    Also i see host table, items table are blank.
    I can see server is sending configs, and proxy is receiving it, but its not able to apply. I fail to understand why its saying duplicate entry or any database error when its a blank database.

    This is critical issue. Basically without proxy instance i am totally out of monitoring, and i don't have old 2.0.6 backup of proxies. All the proxies are giving me duplicate entry errors, and 'failed, setting transaction as failed' error.
    Request your opinions.

    Thanks
    Last edited by zabbixfk; 11-05-2016, 08:38. Reason: added error sentence

    Comment

    • zabbixfk
      Senior Member
      • Jun 2013
      • 256

      #3
      Critical: After upgrade zabbix proxy isn't updating configs from server

      *bump* can somebody reply pls...

      Comment

      • zabbixfk
        Senior Member
        • Jun 2013
        • 256

        #4
        Critical: After upgrade zabbix proxy isn't updating configs from server

        *bump* again, can somebody look at this thread and reply please !!!

        Comment

        • zabbixfk
          Senior Member
          • Jun 2013
          • 256

          #5
          Critical: After upgrade zabbix proxy isn't updating configs from server

          *bump* - somebody pls reply.

          Comment

          • zabbixfk
            Senior Member
            • Jun 2013
            • 256

            #6
            Critical: After upgrade zabbix proxy isn't updating configs from server

            * Bump * again !!!!!

            Comment

            • LenR
              Senior Member
              • Sep 2009
              • 1005

              #7
              Just to verify, both your proxy and server are using "their" local mysql instance?

              Comment

              • zabbixfk
                Senior Member
                • Jun 2013
                • 256

                #8
                Critical: After upgrade zabbix proxy isn't updating configs from server

                Thanks for the reply.

                Yes. I have about 3 proxy instances and 1 server. All of them are using their local mysql instances. As of now, whatever the update with respect to proxy i do in server, is not reflecting in proxies as they are keep saying fail to update.

                - I even tried to truncate the db of one of the proxy instance and sourced new schema.sql and tried to see if things work, still its saying unable to update configs from server. It is receiveng them and its sending older data, but new data is not being applied on proxy and new data is not sent via proxy.

                - For example.
                Host_A is monitored by proxy_1 , and i have interface_1 to be monitored.
                Now interface_1 is no longer required ( down), and its to be changed as interface_2. If i change in the server UI, its getting changed, i can see the interface_2 is sent to proxy from the logs of both server and proxy_1, but inside proxy_1 db, its still interface_1 and new interface_2 is not applied

                Any pointers are greatly helpful.

                Thanks

                Comment

                • zabbixfk
                  Senior Member
                  • Jun 2013
                  • 256

                  #9
                  Critical: After upgrade zabbix proxy isn't updating configs from server

                  * bump * , still waiting for a clue.

                  Comment

                  • zabbixfk
                    Senior Member
                    • Jun 2013
                    • 256

                    #10
                    Critical: After upgrade zabbix proxy not working

                    *bump*

                    Is this is a limitation? Or is there any trick to by pass this? i don't see number of devices cap on the zabbix doc, thought only support was paid but looks like number devices cap seems to be exists (at least in my case).
                    I have done everything i could.
                    - removed the upgrade reverted back to old setup on both server and proxy
                    - blanked out proxy, waited for 3 days to let proxy get the details from server about the hosts to be monitored

                    still no success. Its just does not get any updates from server. So in my server ( using zabbix UI), if i update some host which is being monitored via proxy, proxy suppose to get that update and apply it. This doesn't happen.
                    In server if i say don't moniter interface 1, instead monitor 2 for a host, proxy should get that, this doesn't happen.

                    May be its time to call this as a limitation.
                    Any pointers greatly helpful

                    Thanks

                    Comment

                    • andris
                      Zabbix developer
                      • Feb 2012
                      • 228

                      #11
                      Hi!

                      Is your server and proxy of the same version ? And you are 100% sure that proxy does not connect to server database ?

                      You can set 'DebugLevel=4' in zabbix_proxy.conf and check how the config update goes. Look for lines:
                      Code:
                       29501:20160309:170424.741 proxy #1 started [configuration syncer #1]
                      ...
                       29501:20160309:170424.767 Received [{
                              "globalmacro":{
                      ...
                       29501:20160309:170424.767 received configuration data from server, datalen 22058
                       29501:20160309:170424.767 In process_proxyconfig()
                      ...
                       29501:20160309:170424.784 In DCsync_configuration()
                      ....
                       29501:20160309:170424.788 === memory statistics for configuration cache ===
                       29501:20160309:170424.788 free chunks of size >= 256 bytes:        1
                       29501:20160309:170424.788 min chunk size:    6751440 bytes
                       29501:20160309:170424.788 max chunk size:    6751440 bytes
                       29501:20160309:170424.788 memory of total size 7129936 bytes fragmented into 537 chunks
                       29501:20160309:170424.788 of those,    6751440 bytes are in        1 free chunks
                       29501:20160309:170424.788 of those,     369920 bytes are in      536 used chunks
                       29501:20160309:170424.788 ================================
                       29501:20160309:170424.788 === memory statistics for string pool ===
                       29501:20160309:170424.788 free chunks of size >= 256 bytes:        1
                       29501:20160309:170424.788 min chunk size:    1240424 bytes
                       29501:20160309:170424.788 max chunk size:    1240424 bytes
                       29501:20160309:170424.788 memory of total size 1257920 bytes fragmented into 131 chunks
                       29501:20160309:170424.788 of those,    1240424 bytes are in        1 free chunks
                       29501:20160309:170424.789 of those,      15416 bytes are in      130 used chunks
                       29501:20160309:170424.789 ================================
                       29501:20160309:170424.789 End of DCsync_configuration()
                       29501:20160309:170424.789 End of process_proxyconfig()
                       29501:20160309:170424.789 End of process_configuration_sync()
                      Any errors in zabbix_proxy.log while updating config ?

                      Comment

                      • zabbixfk
                        Senior Member
                        • Jun 2013
                        • 256

                        #12
                        Critical: After upgrade zabbix proxy not working

                        Hi,

                        Thank you very much for the reply.
                        Below are sample logs from one of the proxy which is failing ( i have about 4 proxy instances all are behaving same way)
                        Code:
                        20747:20160728:113931.727 Starting Zabbix Proxy (active) [zbx-proxy2]. Zabbix 2.2.12 (revision 59538).
                         20747:20160728:113931.728 **** Enabled features ****
                         20747:20160728:113931.728 SNMP monitoring:       YES
                         20747:20160728:113931.728 IPMI monitoring:       YES
                         20747:20160728:113931.728 WEB monitoring:        YES
                         20747:20160728:113931.728 VMware monitoring:      NO
                         20747:20160728:113931.728 ODBC:                   NO
                         20747:20160728:113931.728 SSH2 support:          YES
                         20747:20160728:113931.728 IPv6 support:          YES
                         20747:20160728:113931.728 **************************
                         20747:20160728:113931.728 using configuration file: /usr/local/etc/zabbix_proxy.conf
                         20747:20160728:113931.728 In load_modules()
                         20747:20160728:113931.728 End of load_modules():SUCCEED
                         20747:20160728:113931.728 In init_database_cache()
                         20747:20160728:113931.728 In zbx_mem_required_size() size:0 chunks_num:4 descr:'history cache' param:'HistoryCacheSize'
                         20747:20160728:113931.728 End of zbx_mem_required_size() size:543
                         20747:20160728:113931.728 In zbx_mem_create() descr:'history cache' param:'HistoryCacheSize' size:1073741807
                         20747:20160728:113931.729 valid user addresses: [0x7f574fddb170, 0x7f578fddafe0] total size: 1073741424
                         20747:20160728:113931.729 End of zbx_mem_create()
                         20747:20160728:113931.729 In zbx_mem_required_size() size:0 chunks_num:1 descr:'history text cache' param:'HistoryTextCacheSize'
                         20747:20160728:113931.729 End of zbx_mem_required_size() size:435
                         20747:20160728:113931.729 In zbx_mem_create() descr:'history text cache' param:'HistoryTextCacheSize' size:268435456
                         20747:20160728:113931.729 valid user addresses: [0x7f573fddb178, 0x7f574fddaff0] total size: 268435064
                         20747:20160728:113931.729 End of zbx_mem_create()
                         20747:20160728:113931.729 End of init_database_cache()
                         20747:20160728:113931.729 In init_configuration_cache() size:1073741824
                         20747:20160728:113931.729 In zbx_mem_create() descr:'configuration cache' param:'CacheSize' size:912680551
                         20747:20160728:113931.729 valid user addresses: [0x7f5709774170, 0x7f573fdda658] total size: 912680168
                         20747:20160728:113931.729 End of zbx_mem_create()
                         20747:20160728:113931.730 In zbx_strpool_create()
                         20747:20160728:113931.730 In zbx_mem_create() descr:'string pool' param:'CacheSize' size:161061273
                         20747:20160728:113931.730 valid user addresses: [0x7f56ffdda168, 0x7f5709773990] total size: 161060904
                         20747:20160728:113931.730 End of zbx_mem_create()
                         20747:20160728:113931.730 End of zbx_strpool_create()
                         20747:20160728:113931.730 End of init_configuration_cache()
                         20747:20160728:113931.730 In init_selfmon_collector()
                         20747:20160728:113931.730 init_selfmon_collector() size:125064
                         20747:20160728:113931.731 End of init_selfmon_collector() collector:0x7f56ffdbb000
                         20747:20160728:113931.731 In DBcheck_version()
                         20747:20160728:113931.731 In DBconnect() flag:0
                         20747:20160728:113931.743 query without transaction detected
                         20747:20160728:113931.743 query [txnlev:0] [set names utf8]
                         20747:20160728:113931.743 End of DBconnect():0
                         20747:20160728:113931.743 query [txnlev:0] [show tables like 'dbversion']
                         20747:20160728:113931.744 query [txnlev:0] [select mandatory,optional from dbversion]
                         20747:20160728:113931.745 current database version (mandatory/optional): 02020000/02020001
                         20747:20160728:113931.745 required mandatory version: 02020000
                         20747:20160728:113931.745 End of DBcheck_version():SUCCEED
                         20747:20160728:113931.745 In DBconnect() flag:0
                         20747:20160728:113931.746 query without transaction detected
                         20747:20160728:113931.746 query [txnlev:0] [set names utf8]
                         20747:20160728:113931.747 End of DBconnect():0
                         20747:20160728:113931.747 In DCsync_configuration()
                        20747:20160728:113931.883 In DCsync_items()
                         20747:20160728:113931.884 delay period [50/1-7,00:00-24:00]
                         20747:20160728:113931.884 50 sec at 1-7,00:00-24:00
                         20747:20160728:113931.884 In check_time_period() period:'1-7,00:00-24:00'
                         20747:20160728:113931.884 4,11:39
                         20747:20160728:113931.884 period [1-7,00:00-24:00]
                         20747:20160728:113931.884 1-7,0:0-24:0
                         20747:20160728:113931.884 End of check_time_period():SUCCEED
                        It has similar lines ( check_time_period ) for about 500+ lines then entries for memory utilisation
                        Code:
                        20747:20160728:113931.978 End of DCsync_items()
                         20747:20160728:113931.978 In DCsync_triggers()
                         20747:20160728:113931.978 End of DCsync_triggers()
                         20747:20160728:113931.978 In DCsync_trigdeps()
                         20747:20160728:113931.978 End of DCsync_trigdeps()
                         20747:20160728:113931.978 In DCsync_functions()
                         20747:20160728:113931.978 End of DCsync_functions()
                         20747:20160728:113931.978 In DCsync_host_inventory()
                         20747:20160728:113931.978 End of DCsync_host_inventory()
                         20747:20160728:113931.978 In DCsync_htmpls()
                         20747:20160728:113931.980 End of DCsync_htmpls()
                         20747:20160728:113931.980 In DCsync_gmacros()
                         20747:20160728:113931.980 End of DCsync_gmacros()
                         20747:20160728:113931.980 In DCsync_hmacros()
                         20747:20160728:113931.980 End of DCsync_hmacros()
                         20747:20160728:113931.980 In DCsync_interfaces()
                         20747:20160728:113931.984 End of DCsync_interfaces()
                         20747:20160728:113931.984 In DCsync_expressions()
                         20747:20160728:113931.984 End of DCsync_expressions()
                         20747:20160728:113931.984 DCsync_configuration() config     : sql:0.000686 sync:0.000228 sec.
                         20747:20160728:113931.984 DCsync_configuration() hosts      : sql:0.007759 sync:0.004543 sec.
                         20747:20160728:113931.984 DCsync_configuration() items      : sql:0.115151 sync:0.094525 sec.
                         20747:20160728:113931.984 DCsync_configuration() triggers   : sql:0.001124 sync:0.000105 sec.
                         20747:20160728:113931.984 DCsync_configuration() trigdeps   : sql:0.000485 sync:0.000090 sec.
                         20747:20160728:113931.984 DCsync_configuration() functions  : sql:0.000567 sync:0.000088 sec.
                         20747:20160728:113931.984 DCsync_configuration() host_invent: sql:0.000516 sync:0.000120 sec.
                         20747:20160728:113931.984 DCsync_configuration() templates  : sql:0.001370 sync:0.001349 sec.
                         20747:20160728:113931.984 DCsync_configuration() globmacros : sql:0.000347 sync:0.000149 sec.
                         20747:20160728:113931.984 DCsync_configuration() hostmacros : sql:0.000322 sync:0.000326 sec.
                         20747:20160728:113931.984 DCsync_configuration() interfaces : sql:0.002959 sync:0.003713 sec.
                         20747:20160728:113931.985 DCsync_configuration() expressions: sql:0.000572 sync:0.000122 sec.
                         20747:20160728:113931.985 DCsync_configuration() total sync : 0.105357 sec.
                         20747:20160728:113931.985 DCsync_configuration() total      : 0.237214 sec.
                         20747:20160728:113931.985 DCsync_configuration() proxies    : 0 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() hosts      : 957 (1523 slots)
                         20747:20160728:113931.985 DCsync_configuration() hosts_h    : 957 (1523 slots)
                         20747:20160728:113931.985 DCsync_configuration() ipmihosts  : 875 (1523 slots)
                         20747:20160728:113931.985 DCsync_configuration() items      : 6431 (11617 slots)
                         20747:20160728:113931.985 DCsync_configuration() items_hk   : 6431 (11617 slots)
                         20747:20160728:113931.985 DCsync_configuration() numitems   : 5058 (7741 slots)
                         20747:20160728:113931.985 DCsync_configuration() snmpitems  : 5162 (7741 slots)
                         20747:20160728:113931.985 DCsync_configuration() ipmiitems  : 0 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() flexitems  : 97 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() trapitems  : 0 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() logitems   : 0 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() dbitems    : 0 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() sshitems   : 0 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() telnetitems: 0 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() simpleitems: 970 (1523 slots)
                         20747:20160728:113931.985 DCsync_configuration() jmxitems   : 0 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() calcitems  : 0 (1009 slots)
                         20747:20160728:113931.985 DCsync_configuration() deltaitems : 0 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() functions  : 0 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() triggers   : 0 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() trigdeps   : 0 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() htmpls     : 935 (1523 slots)
                         20747:20160728:113931.986 DCsync_configuration() gmacros    : 1 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() gmacros_m  : 1 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() hmacros    : 17 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() hmacros_hm : 17 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() interfaces : 973 (1523 slots)
                         20747:20160728:113931.986 DCsync_configuration() interfac_ht: 958 (1523 slots)
                         20747:20160728:113931.986 DCsync_configuration() if_snmpitms: 0 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() if_snmpaddr: 876 (1523 slots)
                         20747:20160728:113931.986 DCsync_configuration() expressions: 4 (1009 slots)
                         20747:20160728:113931.986 DCsync_configuration() queue[0]   : 3856 (4144 allocated)
                         20747:20160728:113931.986 DCsync_configuration() queue[1]   : 0 (0 allocated)
                         20747:20160728:113931.986 DCsync_configuration() queue[2]   : 0 (0 allocated)
                         20747:20160728:113931.986 DCsync_configuration() queue[3]   : 890 (1228 allocated)
                         20747:20160728:113931.986 DCsync_configuration() queue[4]   : 0 (0 allocated)
                         20747:20160728:113931.986 DCsync_configuration() pqueue     : 0 (0 allocated)
                         20747:20160728:113931.986 DCsync_configuration() configfree : 99.550533%
                         20747:20160728:113931.986 DCsync_configuration() strings    : 2803 (5153 slots)
                         20747:20160728:113931.986 DCsync_configuration() strpoolfree: 99.866197%
                         20747:20160728:113931.987 === memory statistics for configuration cache ===
                         20747:20160728:113931.987 free chunks of size     24 bytes:        5
                         20747:20160728:113931.987 free chunks of size >= 256 bytes:        5
                         20747:20160728:113931.987 min chunk size:         24 bytes
                         20747:20160728:113931.987 max chunk size:  908537520 bytes
                         20747:20160728:113931.987 memory of total size 912680168 bytes fragmented into 33817 chunks
                         20747:20160728:113931.987 of those,  908578352 bytes are in       10 free chunks
                         20747:20160728:113931.987 of those,    3560760 bytes are in    33807 used chunks
                         20747:20160728:113931.987 ================================
                         20747:20160728:113931.987 === memory statistics for string pool ===
                         20747:20160728:113931.987 free chunks of size     24 bytes:        1
                         20747:20160728:113931.987 free chunks of size >= 256 bytes:        2
                         20747:20160728:113931.987 min chunk size:         24 bytes
                         20747:20160728:113931.987 max chunk size:  160821640 bytes
                         20747:20160728:113931.987 memory of total size 161060904 bytes fragmented into 2808 chunks
                         20747:20160728:113931.987 of those,  160845768 bytes are in        3 free chunks
                         20747:20160728:113931.987 of those,     170224 bytes are in     2805 used chunks
                         20747:20160728:113931.987 ================================
                         20747:20160728:113931.988 End of DCsync_configuration()
                         20751:20160728:113931.990 proxy #1 started [configuration syncer #1]
                         20751:20160728:113931.990 configuration syncer [connecting to the database]
                         20751:20160728:113931.990 In DBconnect() flag:0
                         20752:20160728:113931.991 proxy #2 started [heartbeat sender #1]
                         20752:20160728:113931.991 heartbeat sender [sending heartbeat message]
                         20752:20160728:113931.991 In send_heartbeat()
                         20751:20160728:113931.991 query without transaction detected
                         20754:20160728:113931.991 proxy #3 started [data sender #1]
                         20752:20160728:113931.992 In connect_to_server() [xx.xx.xx.xx]:10051 [timeout:60]
                         20751:20160728:113931.992 query [txnlev:0] [set names utf8]
                         20754:20160728:113931.992 data sender [connecting to the database]
                         20754:20160728:113931.992 In DBconnect() flag:0
                         20751:20160728:113931.992 End of DBconnect():0
                         20751:20160728:113931.992 configuration syncer [loading configuration]
                         20751:20160728:113931.992 In process_configuration_sync()
                         20751:20160728:113931.992 In connect_to_server() [xx.xx.xx.xx]:10051 [timeout:600]
                         20752:20160728:113931.993 In put_data_to_server() datalen:56
                         20752:20160728:113931.993 In send_data_to_server() [{
                        	"request":"proxy heartbeat",
                        	"host":"zbx-proxy2"}]
                         20754:20160728:113931.993 query without transaction detected
                         20751:20160728:113931.993 In get_data_from_server() request:'proxy config'
                         20752:20160728:113931.993 In zbx_recv_response()
                         20754:20160728:113931.993 query [txnlev:0] [set names utf8]
                         20751:20160728:113931.994 In send_data_to_server() [{
                        	"request":"proxy config",
                        	"host":"nm-zbx-proxy2"}]
                         20751:20160728:113931.994 In recv_data_from_server()
                         20754:20160728:113931.994 End of DBconnect():0
                         20754:20160728:113931.994 data sender [sent 0 values in 0.000000 sec, sending data]
                         20754:20160728:113931.994 In host_availability_sender()
                         20754:20160728:113931.994 In get_host_availability_data()
                         20754:20160728:113931.994 query [txnlev:0] [xxxxxx]
                         20754:20160728:113932.015 End of get_host_availability_data():SUCCEED
                         20754:20160728:113932.015 In connect_to_server() [xx.xx.xx.xx]:10051 [timeout:600]
                         20752:20160728:113932.016 zbx_recv_response() '{
                        	"response":"success"}'
                         20752:20160728:113932.016 End of zbx_recv_response():SUCCEED
                         20752:20160728:113932.016 End of put_data_to_server():SUCCEED
                         20752:20160728:113932.017 heartbeat sender [sending heartbeat message success in 0.025478 sec, idle 59 sec]
                         20754:20160728:113932.030 In put_data_to_server() datalen:182054
                         20754:20160728:113932.030 In send_data_to_server() [{
                        	"request":"host availability",
                        	"host":"zbx-proxy2",
                        	"data":[
                        		{
                        			"hostid":XXXX,
                        			"available":0,
                        			"snmp_available":1,
                        			"ipmi_available":0,
                        			"jmx_available":0,
                        			"error":"",
                        			"snmp_error":"",
                        			"ipmi_error":"",
                        			"jmx_error":""},
                        		{
                        Then it sends all the items , so another 7K+ lines on them. Then the entries for sending history data, another 4K+ lines. Now it receives data from server,
                        Code:
                        20754:20160728:113932.243 In zbx_recv_response()
                         20751:20160728:113932.494 Received [{
                        	"globalmacro":{
                        		"fields":["globalmacroid","macro","value"],
                        		"data":[
                        			[2,"{$SNMP_COMMUNITY}","public"]]},
                        	"hosts":{
                        Now after all these kind of lines,
                        Code:
                        20751:20160728:113943.678 failed to update local proxy configuration copy: database error
                        Digging deeper tells me some kind of duplicate entry error. Wow, debug=4 did work this time.
                        Code:
                        20751:20160728:114444.635 [Z3005] query failed: [1062] Duplicate entry '12606-ifAdminStatus[ssl.ROOT]' for key 'items_1' [insert into items
                        And in some other proxy it looks like this
                        Code:
                        2318361-  1822:20160728:125754.546 [Z3005] query failed: [1062] Duplicate entry '10163-ifAdminStatus[ssl.vdom1]' for key 'items_1' [insert into items
                        Is this is the reason its not able to apply specific update or all the updates?

                        Or is it possible that server keep sending updates and proxy looks at it and thinks i don't have this update, now its time to update and fails on duplicate entry ?

                        How come this duplicate entry error arrived all of sudden ( read after upgrade).

                        What should i do to fix this?

                        Thanks.
                        Last edited by zabbixfk; 28-07-2016, 09:30. Reason: added another proxy log

                        Comment

                        • andris
                          Zabbix developer
                          • Feb 2012
                          • 228

                          #13
                          Looks somewhat similar to bugs
                          ZBX-7470 Zabbix Server stopped with "[Z3005] query failed: [1062] Duplicate entry"
                          ZBX-6857 Query failed; Duplicate entry '10129-vfs.fs.size[C:,total]

                          Not sure how to fix it. These bugs are rare. Maybe newer version of server and proxy can solve it, also creating proxy DB from scratch.

                          Andris

                          Comment

                          • zabbixfk
                            Senior Member
                            • Jun 2013
                            • 256

                            #14
                            Critical: After upgrade zabbix proxy not working

                            Thanks for the reply.

                            Looks like first link seems to be the right one , as i am running 2.2.12. And this seems to be rare frekin bug. Bug report does not talk about fixes either.
                            Thanks for pointing out. Now i have to try the upgrade on different instances and see if that works.


                            Thanks.

                            Comment

                            • zabbixfk
                              Senior Member
                              • Jun 2013
                              • 256

                              #15
                              Critical: After upgrade zabbix proxy not working

                              Do you have any specic build number in mind for which i can upgrade to? I don't see that bug got fixed any of the subsequent builds.

                              Can somebody from zabbix team confirm on the fix of 7470 bug?

                              Thanks.

                              Comment

                              Working...