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

Zabbix Server Caching Issue of New Unsupported Items causing Queing

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • 3.0.0alpha3
    • Proxy (P), Server (S)
    • None
    • pre-zabbix-3.0.0alpha5-56596

      In a server/proxy setup, adding new templates to a host monitored by a proxy that have a lot of unsupported items causes queuing on the Zabbix server. Zabbix Server is trying to retrieve values for cache for the first time and scans the entire database. After all the unsupported items are processed to retrieve cache, zabbix server starts to process things normal. Having about 30 or 40 unsupported items causing queuing for over 30 minutes.

        2439:20151109:004113.625 slow query: 3.200867 sec, "select clock,ns,value from history_uint where itemid=49920 and clock<=1447043955 and clock>1446957555 order by clock desc limit 9"
  2442:20151109:004113.631 slow query: 3.195073 sec, "select clock,ns,value from history_uint where itemid=50051 and clock<=1447043957 and clock>1446957557 order by clock desc limit 1"
  2442:20151109:004124.706 slow query: 11.074959 sec, "select clock,ns,value from history_uint where itemid=50051 and clock<=1446957557 and clock>1446352757 order by clock desc limit 1"
  2439:20151109:004124.706 slow query: 11.080613 sec, "select clock,ns,value from history_uint where itemid=49920 and clock<=1446957555 and clock>1446352755 order by clock desc limit 9"
  2442:20151109:004134.264 slow query: 9.558351 sec, "select clock,ns,value from history_uint where itemid=50051 and clock<=1446352757 and clock>1443760757 order by clock desc limit 1"
  2439:20151109:004134.264 slow query: 9.558318 sec, "select clock,ns,value from history_uint where itemid=49920 and clock<=1446352755 and clock>1443760755 order by clock desc limit 9"
  2439:20151109:004140.675 slow query: 3.200069 sec, "select clock,ns,value from history_uint where itemid=49977 and clock<=1447043955 and clock>1446957555 order by clock desc limit 1"
  2442:20151109:004140.677 slow query: 3.202882 sec, "select clock,ns,value from history_uint where itemid=50049 and clock<=1447043957 and clock>1446957557 order by clock desc limit 9"
  2442:20151109:004151.735 slow query: 11.057315 sec, "select clock,ns,value from history_uint where itemid=50049 and clock<=1446957557 and clock>1446352757 order by clock desc limit 9"
  2439:20151109:004151.735 slow query: 11.060376 sec, "select clock,ns,value from history_uint where itemid=49977 and clock<=1446957555 and clock>1446352755 order by clock desc limit 1"
  2442:20151109:004201.285 slow query: 9.549839 sec, "select clock,ns,value from history_uint where itemid=50049 and clock<=1446352757 and clock>1443760757 order by clock desc limit 9"
  2439:20151109:004201.285 slow query: 9.549614 sec, "select clock,ns,value from history_uint where itemid=49977 and clock<=1446352755 and clock>1443760755 order by clock desc limit 1"
  2442:20151109:004207.564 slow query: 3.119583 sec, "select clock,ns,value from history where itemid=50058 and clock<=1447043957 and clock>1446957557 order by clock desc limit 9"
  2439:20151109:004207.702 slow query: 3.203791 sec, "select clock,ns,value from history_uint where itemid=49933 and clock<=1447043955 and clock>1446957555 order by clock desc limit 9"
  2442:20151109:004218.657 slow query: 11.092807 sec, "select clock,ns,value from history where itemid=50058 and clock<=1446957557 and clock>1446352757 order by clock desc limit 9"
  2439:20151109:004218.794 slow query: 11.091753 sec, "select clock,ns,value from history_uint where itemid=49933 and clock<=1446957555 and clock>1446352755 order by clock desc limit 9"
  2442:20151109:004228.143 slow query: 9.485291 sec, "select clock,ns,value from history where itemid=50058 and clock<=1446352757 and clock>1443760757 order by clock desc limit 9"
  2439:20151109:004228.364 slow query: 9.569832 sec, "select clock,ns,value from history_uint where itemid=49933 and clock<=1446352755 and clock>1443760755 order by clock desc limit 9"
  2442:20151109:004234.550 slow query: 3.223907 sec, "select clock,ns,value from history_uint where itemid=50052 and clock<=1447043957 and clock>1446957557 order by clock desc limit 9"
  2439:20151109:004234.786 slow query: 3.208124 sec, "select clock,ns,value from history_uint where itemid=49923 and clock<=1447043955 and clock>1446957555 order by clock desc limit 9"
  2442:20151109:004245.629 slow query: 11.078849 sec, "select clock,ns,value from history_uint where itemid=50052 and clock<=1446957557 and clock>1446352757 order by clock desc limit 9"
  2439:20151109:004245.863 slow query: 11.077394 sec, "select clock,ns,value from history_uint where itemid=49923 and clock<=1446957555 and clock>1446352755 order by clock desc limit 9"
  2442:20151109:004255.229 slow query: 9.599728 sec, "select clock,ns,value from history_uint where itemid=50052 and clock<=1446352757 and clock>1443760757 order by clock desc limit 9"
  2439:20151109:004255.428 slow query: 9.564944 sec, "select clock,ns,value from history_uint where itemid=49923 and clock<=1446352755 and clock>1443760755 order by clock desc limit 9"
  2442:20151109:004301.695 slow query: 3.235566 sec, "select clock,ns,value from history_uint where itemid=50057 and clock<=1447043957 and clock>1446957557 order by clock desc limit 9"
  2439:20151109:004301.850 slow query: 3.207687 sec, "select clock,ns,value from history_uint where itemid=49938 and clock<=1447043955 and clock>1446957555 order by clock desc limit 1"
  2442:20151109:004312.836 slow query: 11.141588 sec, "select clock,ns,value from history_uint where itemid=50057 and clock<=1446957557 and clock>1446352757 order by clock desc limit 9"
  2439:20151109:004312.943 slow query: 11.092860 sec, "select clock,ns,value from history_uint where itemid=49938 and clock<=1446957555 and clock>1446352755 order by clock desc limit 1"
  2442:20151109:004322.445 slow query: 9.608494 sec, "select clock,ns,value from history_uint where itemid=50057 and clock<=1446352757 and clock>1443760757 order by clock desc limit 9"
  2439:20151109:004322.494 slow query: 9.550972 sec, "select clock,ns,value from history_uint where itemid=49938 and clock<=1446352755 and clock>1443760755 order by clock desc limit 1"
  2439:20151109:004328.883 slow query: 3.193238 sec, "select clock,ns,value from history_uint where itemid=49942 and clock<=1447043954 and clock>1446957554 order by clock desc limit 9"
  2442:20151109:004328.894 slow query: 3.222520 sec, "select clock,ns,value from history_uint where itemid=50048 and clock<=1447043957 and clock>1446957557 order by clock desc limit 1

        1. screenshot-1.png
          screenshot-1.png
          50 kB
        2. zabbix-patch-3.0.0-57353.diff
          4 kB

            Unassigned Unassigned
            palmertree Kenneth Palmertree
            Votes:
            12 Vote for this issue
            Watchers:
            17 Start watching this issue

              Created:
              Updated:
              Resolved: