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

housekeeper does seemingly useless deletes

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: