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

housekeeper does seemingly useless deletes

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.1.0
    • None
    • Server (S)
    • 2.0 branch rev 32487

      starting on a fresh system, zabbix housekeeper still does execute a large amount of delete queries. excerpt from debug log :

      5374:20130107:151212.512 In delete_history() table:'trends' itemid:30668 keep_history:365 now:1357564317
      5374:20130107:151212.512 query [txnlev:0] [select min(clock) from trends where itemid=30668]
      5374:20130107:151212.512 query without transaction detected
      5374:20130107:151212.512 query [txnlev:0] [delete from trends where itemid=30668 and clock<1326028317]

      as can be seen, first a select is made, and even though we do not have any data that should be deleted, a delete query is executed.

      also, for every item warning "query without transaction detected" is printed, which can't be good

            Unassigned Unassigned
            richlv richlv
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: