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

Server reads all values in value cache of an item for timestamp outside history storage period

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Critical Critical
    • 6.0.40, 7.0.12, 7.2.6, 7.4.0beta2
    • Server (S)
    • None
    • RHEL 10.0, Zabbix 7.4 beta 2 (src) PgSQL 17/TSDB 2.19
      RHEL 8.10, Zabbix LTS 7.0.12 PgSQL 15+/TSDB2.13+
    • S25-W20/21

      Steps to reproduce:

      1. configure some Trapper item
      2. send fresh data with: 'zabbix_sender -z 127.0.0.1 -s time -k time -o 1' several times, ten for example
      3. create trigger with 'last(something)>1'
      4. send outdated timestamp with: 'zabbix_sender -z 127.0.0.1 -T -i /tmp/input.txt'
        /tmp/input.txt
        time time 1429533600 43
        
      5. check 'zabbix_server -R diaginfo'
      6. all values stored before will be inserted in cache
      7. server will have message:
         66488:20250515:125153.536 item "time:time" value timestamp "2015.04.20 15:40:00" is outside history storage period
         66488:20250515:125153.536 item "time:time" value timestamp "2015.04.20 15:40:00" is outside trends storage period
        

      Note: HK compression is off or on, or system with MySQL/PgSQL without TSDB.

      Result:
      Real issue result:

      zabbix_server.log
      923946:20250515:000033.008 === most used items statistics for value cache ===
      923946:20250515:000033.028 itemid:866412 active range:60 hits:6763 count:57775 perc:0.012750%
      923946:20250515:000033.028 itemid:1042381 active range:136145522 hits:71706 count:45088 perc:0.009950%
      923946:20250515:000033.028 itemid:1047781 active range:136145521 hits:66018 count:45073 perc:0.009947%
      923946:20250515:000033.028 itemid:1050781 active range:136145520 hits:35794 count:45068 perc:0.009946%
      923946:20250515:000033.028 itemid:1307077 active range:136067773 hits:63601 count:44806 perc:0.009888%
      923946:20250515:000033.028 itemid:1317549 active range:136067770 hits:32208 count:44805 perc:0.009888%
      923946:20250515:000033.028 itemid:1313809 active range:136067772 hits:58345 count:44805 perc:0.009888%
      923946:20250515:000033.028 itemid:1293613 active range:136067774 hits:94605 count:44804 perc:0.009888%
      923946:20250515:000033.028 itemid:1316801 active range:136067769 hits:32126 count:44803 perc:0.009887%
      923946:20250515:000033.028 itemid:1031575 active range:136180297 hits:89980 count:43221 perc:0.009538%
      923946:20250515:000033.028 itemid:1245070 active range:1242 hits:23713 count:43218 perc:0.009538%
      923946:20250515:000033.028 itemid:1245069 active range:1244 hits:23709 count:43216 perc:0.009537%
      923946:20250515:000033.028 itemid:1245066 active range:1247 hits:22634 count:43215 perc:0.009537%
      923946:20250515:000033.028 itemid:1245068 active range:1245 hits:23709 count:43214 perc:0.009537%
      923946:20250515:000033.028 itemid:1245067 active range:1246 hits:22629 count:43213 perc:0.009536%
      923946:20250515:000033.028 itemid:1050175 active range:136180297 hits:29886 count:43180 perc:0.009529%
      923946:20250515:000033.028 itemid:1042375 active range:136180299 hits:59719 count:43172 perc:0.009527%
      923946:20250515:000033.028 itemid:1047775 active range:136098850 hits:54391 count:43167 perc:0.009526%
      923946:20250515:000033.028 itemid:1050775 active range:136180299 hits:29843 count:43164 perc:0.009526%
      923946:20250515:000033.028 itemid:1031539 active range:136188300 hits:103486 count:43094 perc:0.009510%
      923946:20250515:000033.028 itemid:1031690 active range:136183752 hits:107824 count:43086 perc:0.009508%
      923946:20250515:000033.028 itemid:1069285 active range:5819 hits:27296 count:43058 perc:0.009502%
      923946:20250515:000033.028 itemid:1050290 active range:136183752 hits:35831 count:43051 perc:0.009501%
      923946:20250515:000033.028 itemid:1050139 active range:136188300 hits:34314 count:43039 perc:0.009498%
      923946:20250515:000033.028 itemid:1047890 active range:136109245 hits:65936 count:43030 perc:0.009496%
      923946:20250515:000033.028 ==================================================
      923946:20250515:000033.115 === memory statistics for value cache size ===
      923946:20250515:000033.115 free chunks of size     24 bytes:     6341
      923946:20250515:000033.115 free chunks of size     32 bytes:     8792
      923946:20250515:000033.115 free chunks of size     40 bytes:     1056
      923946:20250515:000033.115 free chunks of size     48 bytes:     5450
      923946:20250515:000033.115 free chunks of size     56 bytes:      322
      923946:20250515:000033.115 free chunks of size     64 bytes:    32097
      923946:20250515:000033.116 free chunks of size     72 bytes:      297
      923946:20250515:000033.116 free chunks of size     80 bytes:     2158
      923946:20250515:000033.116 free chunks of size     88 bytes:     5458
      923946:20250515:000033.116 free chunks of size     96 bytes:      467
      923946:20250515:000033.116 free chunks of size    104 bytes:      765
      923946:20250515:000033.116 free chunks of size    112 bytes:     1456
      923946:20250515:000033.116 free chunks of size    120 bytes:       44
      923946:20250515:000033.116 free chunks of size    128 bytes:     1150
      923946:20250515:000033.116 free chunks of size    136 bytes:       44
      923946:20250515:000033.116 free chunks of size    144 bytes:     2355
      923946:20250515:000033.116 free chunks of size    152 bytes:       56
      923946:20250515:000033.116 free chunks of size    160 bytes:     1667
      923946:20250515:000033.116 free chunks of size    168 bytes:     1044
      923946:20250515:000033.116 free chunks of size    176 bytes:     3301
      923946:20250515:000033.116 free chunks of size    184 bytes:      291
      923946:20250515:000033.116 free chunks of size    192 bytes:     2605
      923946:20250515:000033.116 free chunks of size    200 bytes:      195
      923946:20250515:000033.116 free chunks of size    208 bytes:     2469
      923946:20250515:000033.116 free chunks of size    216 bytes:      235
      923946:20250515:000033.116 free chunks of size    224 bytes:     3012
      923946:20250515:000033.116 free chunks of size    232 bytes:      145
      923946:20250515:000033.116 free chunks of size    240 bytes:     1975
      923946:20250515:000033.116 free chunks of size    248 bytes:     2433
      923946:20250515:000033.116 free chunks of size >= 256 bytes:   326228
      923946:20250515:000033.116 min chunk size:         24 bytes
      923946:20250515:000033.116 max chunk size:     636304 bytes
      923946:20250515:000033.116 memory of total size 8544217888 bytes fragmented into 2857271 chunks
      923946:20250515:000033.116 of those,  959316800 bytes are in   413908 free chunks
      923946:20250515:000033.116 of those, 7584901088 bytes are in  2443363 used chunks
      923946:20250515:000033.116 of those,   45716320 bytes are used by allocation overhead
      
      zabbix_server -R diaginfo
      Top.values:
        itemid:699620 values:70114 request.values:1
        itemid:695268 values:69459 request.values:1
        itemid:582126 values:65848 request.values:1
        itemid:764933 values:65059 request.values:1
        itemid:621231 values:64357 request.values:1
        itemid:799460 values:64069 request.values:1
        itemid:950965 values:62711 request.values:1
        itemid:723484 values:61862 request.values:1
        itemid:742622 values:58380 request.values:1
        itemid:763525 values:58375 request.values:1
        itemid:745703 values:58063 request.values:1
        itemid:897837 values:55051 request.values:1
        itemid:748980 values:52892 request.values:1
        itemid:771995 values:50572 request.values:1
        itemid:760116 values:50320 request.values:1
        itemid:912002 values:50122 request.values:1
        itemid:737824 values:50009 request.values:1
        itemid:949098 values:49637 request.values:1
        itemid:745262 values:49029 request.values:0
        itemid:703147 values:49006 request.values:1
        itemid:775250 values:48907 request.values:1
        itemid:753624 values:48734 request.values:1
        itemid:709750 values:48079 request.values:1
        itemid:923397 values:48072 request.values:1
        itemid:477241 values:47136 request.values:1
      Top.request.values:
        itemid:63402 values:72 request.values:61
        itemid:45787 values:69 request.values:61
        itemid:45789 values:69 request.values:61
        itemid:1004945 values:69 request.values:61
        itemid:45788 values:68 request.values:61
        itemid:50521 values:26 request.values:16
        itemid:50522 values:26 request.values:16
        itemid:45768 values:26 request.values:16
        itemid:45766 values:26 request.values:16
        itemid:45765 values:26 request.values:16
        itemid:50520 values:26 request.values:16
        itemid:50526 values:25 request.values:16
        itemid:50523 values:25 request.values:16
        itemid:50527 values:25 request.values:16
        itemid:50528 values:25 request.values:16
        itemid:50524 values:25 request.values:16
        itemid:50525 values:25 request.values:16
        itemid:50514 values:22 request.values:16
        itemid:50518 values:22 request.values:16
        itemid:50519 values:22 request.values:16
        itemid:50515 values:22 request.values:16
        itemid:50513 values:22 request.values:16
        itemid:50511 values:22 request.values:16
        itemid:50516 values:22 request.values:16
        itemid:45767 values:22 request.values:16
      ==
      

      Expected:
      If value skipped why to recalculate triggers?

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

              Created:
              Updated: