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

Trends recalculations when older data from the proxy is coming LTS 5.0

    XMLWordPrintable

Details

    • Problem report
    • Resolution: Duplicate
    • Blocker
    • 7.0 (plan)
    • 5.0.37
    • Proxy (P), Server (S)
    • None
    • RHEL 7.9/ LTS 5.0
    • Team A
    • S2401-1, S2401-2
    • 1

    Description

      Steps to reproduce:

      1. Install 5.0.37 to fix https://support.zabbix.com/browse/ZBX-22126
      2. enable load from Proxies (50 proxies/17k NVPS)
      3. get lot's of:
      21799:20231004:141644.044 slow query: 26.083522 sec, "select distinct itemid from trends_uint where clock>=1696413600 and (itemid between 12041848 and 12041853 or itemid between 12041894 and 12041903 or itemid between 12041993 and 12041998 or itemid between 12045325 and 12045336 or itemid between 12045534 and 12045545 or itemid between 12045594 and 12045598 or itemid between 12046522 and 12046532 or itemid between 12046539 and 12046544 or itemid between 12046546 and 12046551 or itemid between 12049100 and 12049105 or itemid between 12049150 and 12049155 or itemid between 12052750 and 12052754 or itemid between 12052790 and 12052794 or itemid between 12056147 and 12056153 or itemid between 12056182 and 12056188 or itemid between 12066941 and 12066948 or itemid between 12066981 and 12066988 or itemid between 12070501 and 12070508 or itemid between 12074346 and 12074352 or itemid between 12074381 and 12074387 or itemid between 12077827 and 12077837 or itemid between 12077882 and 12077892 or itemid between 12102896 and 12102903 or itemid between 12134514 and 12134520 or itemid between 12135363 and 12135373 or itemid between 12135423 and 12135433 or itemid between 12135494 and 12135503 or itemid between 12135544 and 12135553 or itemid between 12160607 and 12160615 or itemid between 12160652 and 12160660 or itemid between 12164387 and 12164395 or itemid between 12171451 and 12171456 or itemid between 12171481 and 12171486 or itemid between 12175101 and 12175105 or itemid between 12175151 and 12175155 or itemid between 12185732 and 12185739 or itemid between 12185772 and 12185779 or itemid between 12185880 and 12185886 or itemid between 12185925 and 12185931 or itemid between 12190041 and 12190047 or itemid between 12190086 and 12190092 or itemid between 12191783 and 12191789 or itemid between 12193067 and 12193071 or itemid between 12193092 and 12193096 or itemid between 12203928 and 12203934 or itemid between 12203963 and 12203969 or itemid between 12207522 and 12207531 or itemid between 12207572 and 12207581 or itemid between 12210926 and 12210938 or itemid between 12210996 and 12211008 or itemid between 12211122 and 12211131 or itemid between 12211172 and 12211181 or itemid between 12214538 and 12214547 or itemid between 12214588 and 12214597 or itemid between 12214792 and 12214797 or itemid between 12218153 and 12218158 or itemid between 12218183 and 12218188 or itemid between 12221635 and 12221640 or itemid between 12221718 and 12221727 or itemid between 12221934 and 12221939 or itemid between 12225484 and 12225491 or itemid between 12225524 and 12225531 or itemid between 12229112 and 12229119 or itemid between 12229172 and 12229179 or itemid between 12232513 and 12232520 or itemid between 12236341 and 12236350 or itemid between 12236391 and 12236399 or itemid between 12239771 and 12239781 or itemid between 12239826 and 12239836 or itemid between 12243440 and 12243450 or itemid between 12243495 and 12243505 or itemid between 12250641 and 12250649 or itemid between 12250701 and 12250709 or itemid in (12041961,12041962,12041983,12041984,12045410,12045411,12045688,12045689,12045747,12045748,12045751,12045752,12045754,12045755,12045756,12045878,12045907,12045908,12046343,12046344,12046347,12046348,12046350,12046351,12046712,12046713,12047267,12047268,12047442,12047443,12047446,12047447,12047449,12047450,12047451,12047456,12048140,12048141,12048225,12048226,12048228,12048229,12048236,12048347,12048364,12048365,12048368,12048369,12048371,12048372,12048373,12048462,12048473,12048474,12048477,12048478,12048480,12048481,12048482,12048483,12049087,12049088,12049091,12049092,12049094,12049095,12049096,12049097,12052502,12052503,12052504,12052505,12052742,12056140,12066923,12066924,12070499,12070587,12070588,12074091,12074092,12074258,12077816,12077817,12090113,12090114,12104263,12104264,12105449,12105450,12105868,12105869,12105870,12105871,12117836,12117837,12118428,12118429,12119884,12119885,12131551,12131557,12131559,12131561,12131563,12131564,12131565,12131568,12131573,12131618,12131653,12131687,12131688,12132016,12132017,12132020,12132021,12132023,12132024,12132025,12132158,12133938,12133939,12134033,12134034,12134036,12134037,12134038,12134057,12134508,12134509,12134510,12134522,12134523,12134524,12135133,12135134,12135135,12135139,12135140,12135141,12135142,12135144,12135145,12135146,12135227,12135228,12135229,12135616,12135617,12135618,12135619,12142704,12142705,12142707,12147944,12147945,12148690,12148691,12149956,12149957,12162071,12162072,12162073,12164166,12164167,12164385,12171529,12171530,12171531,12171532,12175099,12175149,12176753,12176754,12176761,12176762,12177381,12177382,12177383,12177391,12177392,12183850,12183854,12185848,12185849,12185850,12185851,12185878,12185923,12185987,12185988,12185989,12189626,12189952,12189953,12189954,12189955,12190706,12190707,12191155,12191156,12191591,12191592,12191976,12192229,12192680,12193003,12193004,12193134,12196548,12196549,12196550,12196551,12204006,12204007,12204186,12204187,12204460,12204461,12204976,12204977,12205264,12205265,12205688,12205689,12206012,12206013,12206462,12206463,12206468,12206469,12207112,12207113,12207122,12207123,12207286,12207343,12207344,12207492,12207493,12207494,12207508,12207509,12207514,12207515,12211095,12211096,12214516,12214517,12214518,12214519,12214658,12214659,12214660,12214789,12214790,12218233,12218234,12218442,12218443,12218608,12218609,12218681,12218682,12218683,12218684,12218715,12218716,12218725,12218726,12218728,12218729,12218730,12218863,12218894,12218895,12218898,12218899,12218900,12218902,12218903,12219047,12219048,12219867,12219868,12219871,12219872,12219876,12219878,12219879,12220001,12220388,12220389,12220392,12220393,12220395,12220396,12220507,12220508,12220838,12220839,12220842,12220843,12220845,12220846,12220913,12220914,12221117,12221118,12221121,12221122,12221125,12221126,12221127,12221128,12221130,12221131,12221133,12221134,12221136,12221380,12221382,12221384,12221453,12221454,12221455,12221647,12221648,12221649,12221778,12221779,12221780,12221793,12221794,12221795,12221796,12221830,12221831,12221835,12221836,12221838,12221839,12221840,12221841,12225596,12225597,12225598,12229108,12229109,12229110,12229168,12229169,12229170,12232576,12232577,12232836,12232837,12233001,12233002,12233310,12233311,12233784,12233785,12233947,12233948,12234884,12234885,12235209,12235210,12235770,12235771,12236331,12236332,12239904,12239905,12239906,12247843,12247844,12248299,12248300,12248569,12248570,12248849,12248850,12249003,12249004,12249441,12249442,12250292,12250293,12250294,12250328,12250329,12250630,12250631,12250782,12250783,12250784,12250795,12250796,12254112))"
      

      Result:
      Issue is not fixed.

      Expected:
      If trends re-calculation is needed - do it with small SQL not to kill database performance with long running queries and stuck history syncer not able to process current data.

      Attachments

        Issue Links

          Activity

            People

              vso Vladislavs Sokurenko
              edgar.akhmetshin Edgar Akhmetshin
              Votes:
              5 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: