Ad Widget

Collapse

Events table filled with autoregistration events

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • glesys-andreas
    Junior Member
    • Nov 2024
    • 3

    #1

    Events table filled with autoregistration events

    Hi,

    We have some issues with that the events tables are filled with events of type 2, and from what i saw in the docs thats autoregistration.

    We are using timescaledb, but from what i can tell this table isn't compressed or picked up by the housekeeper. Is there a way of clearing these records?

    Code:
    zabbix=# select name,source,count(*) from events group by name,source order by 2 desc  limit 10;
                                      name                                   | source |   count  
    -------------------------------------------------------------------------+--------+-----------
                                                                             |      2 | 356569424
     0 C:: Disk is overloaded (util > 95% for 15m)                           |      0 |        68
     0 C:: Disk write request responses are too high (write > 0.02s for 15m) |      0 |         4
     1 D:: Disk is overloaded (util > 95% for 15m)                           |      0 |      2944
     1 D:: Disk read request responses are too high (read > 0.02s for 15m    |      0 |        28
     1 D:: Disk write request responses are too high (write > 0.02s for 15m) |      0 |         8
     1: Disk is overloaded (util > 95% for 15m)                              |      0 |         4
     1 E:: Disk is overloaded (util > 95% for 15m)                           |      0 |         2
     1 E:: Disk write request responses are too high (write > 0.02s for 15m) |      0 |         2
     2: Disk is overloaded (util > 95% for 15m)                              |      0 |        12
    (10 rows)
    
    ​
Working...