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

Frontend tags processing uses heavy SQL

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Critical Critical
    • 6.0.19rc1, 6.4.4rc1
    • API (A)
    • RHEl8
      Database hardware:
      - 64 cores
      - 512GB of RAM
      - PostgreSQL 15.3
      - TimescaleDB 2.10.3
      - all-flash array
      - Zabbix 6.2
    • Sprint 101 (Jun 2023), Sprint 102 (Jul 2023), Sprint 103 (Aug 2023), Sprint 104 (Sep 2023), Sprint 105 (Oct 2023), S2401-1, S2401-2, Prev.Sprint, S24-W10/11, S24-W12/13, S24-W14/15, S24-W16/17
    • 4

      Steps to reproduce:

      1. use Zabbix in a highly dynamic environment with 1-5m update interval for LLD

      Table size:

       item_tag                   | 11 GB          |      11745476608
      

      Result:
      Database is overloaded with:

      ...
       3912902 | postgres | 2023-06-21 14:50:46.778289+02 | 00:05:45.154366         | SELECT tag,value,itemid FROM item_tag WHERE (itemid IN (46869,46870,46872,46873,46875,46876,46880,46881,46883,46884,46885
      ,46886,46887,46893,46894,46895,46896,46897,46898,46899,46900,46901,46902,46903,46904,46905,46906,46907,46908,46909,46910,46911,46912,46913,46914,46920,46922,47229,47230,47232,47233,47235,47236,47240,47
      241,47243,47244,47245,47246,47247,47253,47254,47255,47256,47257,47258,47259,47260,47261,47262,47263,47264,47265,47266,47267,47268,47269,47270,47271,47272,47273,47274,47280,47282,47469,47470,47472,47473
      ,47475,47476,47480,47481,47483,47484,47485,47486,47487,47493,47494,47495,47496,47497,47498,47499,47500,47501,47502,47503,47504,47505,47506,47507,47508,47509,47510,47511,47512,47513,47514,47520,47522,47
      709,47710,47712,47713,47715,47716,47720,47721,47723,47724,47725,47726,47727,47733,47734,47735,47736,47737,47738,47739,47740,47741,47742,47743,47744,47745,47746,47747,47748,47749,47750,47751,47752,47753
      ,47754,47760,47762,48069,48070,48072,48073,48075,48076,48080,48081,48083,48084,48085,48086,48087,4 | active              |                 |
       3885483 | postgres | 2023-06-21 14:44:28.192753+02 | 00:12:03.739902         | SELECT tag,value,itemid FROM item_tag WHERE (itemid IN (5660883,5660884,5660885,5660886,5660887,5660888,5660889,5660890,5
      660891,5660892,5660893,5660894,5660895,5660896,5660897,5660898,5660899,5660900,5660901,5660902,5660903,5660904,5660905,5660906,5660907,5660908,5660909,5660910,5660914,5660915,5660916,5660917,5660918,56
      60919,5660920,5660921,5660922,5660924,5660925,5660926,5660927,5660928,5660929,5660930,5660931,5660932,5660938,5660939,5660940,5660950,5660952,5661045,5661046,5661047,5661048,5661049,5661050,5661051,566
      1052,5661053,5661054,5661055,5661056,5661057,5661058,5661059,5661060,5661061,5661062,5661063,5661064,5661065,5661066,5661067,5661068,5661069,5661070,5661071,5661072,5661076,5661077,5661078,5661079,5661
      080,5661081,5661082,5661083,5661084,5661086,5661087,5661088,5661089,5661090,5661091,5661092,5661093,5661094,5661100,5661101,5661102,5661112,5661114,5666729,5666730,5666731,5666732,5666733,5666734,56667
      35,5666736,5666737,5666738,5666739,5666740,5666741,5666742,5666751,5666752,5666753,5666754,5666755 | active
      ...
      

      Expected:
      Do not create heavy SQL for the database on internal tasks.

            dfofanovs Dmitrijs Fofanovs
            edgar.akhmetshin Edgar Akhmetshin
            Team A
            Votes:
            3 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated: