Ad Widget

Collapse

Trigger housekeeping understanding

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • grattachecca
    Junior Member
    • Mar 2017
    • 8
    #1

    Trigger housekeeping understanding

    Hi all,

    We have Zabbix 3.0 upgraded to Zabbix 3.2 and now to 3.4.

    We would like to clear triggers history because we have this situation:

    Click image for larger version Name: Screenshot at 2017-09-08 11-55-35.png Views: 1 Size: 53.5 KB ID: 318334

    Under Administration -> General -> Housekeeping we configured a 1 day retention period for triggers:

    Click image for larger version Name: Screenshot at 2017-09-08 11-54-50.png Views: 1 Size: 14.8 KB ID: 318333

    After 2 days the Triggers page still shows all the triggers since our installation. Is that option for other uses?

    If so, is it OK if we truncate the "trigger" table under MySQL or we will have inconsistency issues with our RDBMS?

    Thanks
    Tags: None
    • vso
      Zabbix developer
      • Aug 2016
      • 190
      #2
      What do you see in zabbix server log when you execute house keeper manually ? What are your other parameters related to housekeeper ? You can find those in configuration file.

        Comment

        • grattachecca
          Junior Member
          • Mar 2017
          • 8
          #3
          Thanks for replying.

          Originally posted by vso
          What do you see in zabbix server log when you execute house keeper manually?
          Every hour I can see lines like these...

          Code:
           16044:20170908:183759.836 executing housekeeper
 16044:20170908:183807.581 housekeeper [deleted 115815 hist/trends, 0 items, 0 events, 1 problems, 0 sessions, 0 alarms, 0 audit items in 7.742010 sec, idle for 1 hour(s)]
 16044:20170908:193808.216 executing housekeeper
 16044:20170908:193813.245 housekeeper [deleted 115788 hist/trends, 0 items, 3 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 5.026714 sec, idle for 1 hour(s)]
 16044:20170908:203813.903 executing housekeeper
 16044:20170908:203818.174 housekeeper [deleted 115814 hist/trends, 0 items, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 4.268867 sec, idle for 1 hour(s)]
 16044:20170908:213818.851 executing housekeeper
 16044:20170908:213827.216 housekeeper [deleted 115742 hist/trends, 0 items, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 8.363679 sec, idle for 1 hour(s)]
 16044:20170908:223827.868 executing housekeeper
 16044:20170908:223833.982 housekeeper [deleted 115750 hist/trends, 0 items, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 6.111848 sec, idle for 1 hour(s)]
 16044:20170908:233834.633 executing housekeeper
 16044:20170908:233841.284 housekeeper [deleted 115846 hist/trends, 0 items, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 6.648977 sec, idle for 1 hour(s)]
 16044:20170909:003841.939 executing housekeeper
 16044:20170909:003846.228 housekeeper [deleted 115718 hist/trends, 0 items, 0 events, 1 problems, 0 sessions, 0 alarms, 0 audit items in 4.287419 sec, idle for 1 hour(s)]
 16044:20170909:013846.920 executing housekeeper
 16044:20170909:013851.013 housekeeper [deleted 116143 hist/trends, 0 items, 3 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 4.091613 sec, idle for 1 hour(s)]
 16044:20170909:023851.694 executing housekeeper
 16044:20170909:023857.096 housekeeper [deleted 115914 hist/trends, 0 items, 0 events, 5 problems, 0 sessions, 0 alarms, 0 audit items in 5.399573 sec, idle for 1 hour(s)]
 16044:20170909:033857.800 executing housekeeper
 16044:20170909:033901.892 housekeeper [deleted 115800 hist/trends, 0 items, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 4.089664 sec, idle for 1 hour(s)]
 16044:20170909:043902.585 executing housekeeper
 16044:20170909:043912.555 housekeeper [deleted 115740 hist/trends, 0 items, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 9.966997 sec, idle for 1 hour(s)]
 16044:20170909:053913.231 executing housekeeper
 16044:20170909:053920.987 housekeeper [deleted 115783 hist/trends, 0 items, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 7.754191 sec, idle for 1 hour(s)]
 16044:20170909:063921.616 executing housekeeper
 16044:20170909:063926.964 housekeeper [deleted 115756 hist/trends, 0 items, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 5.344718 sec, idle for 1 hour(s)]
 16044:20170909:073927.626 executing housekeeper
 16044:20170909:073931.933 housekeeper [deleted 115674 hist/trends, 0 items, 3 events, 0 problems, 0 sessions, 0 alarms, 0 audit items in 4.305833 sec, idle for 1 hour(s)]
          Originally posted by vso
          What are your other parameters related to housekeeper ? You can find those in configuration file.
          Pretty much standard config (default value in /etc/zabbix/zabbix_server.conf):

          Code:
          # HousekeepingFrequency=1
...
# MaxHousekeeperDelete=5000

            Comment

            • grattachecca
              Junior Member
              • Mar 2017
              • 8
              #4
              Maybe it's related to ZBX-12434?

                Comment

                Previous template Next
                Working...