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

housekeeper does seemingly useless deletes

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.1.0
    • Component/s: Server (S)
    • Labels:
    • Environment:
      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

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

              Dates

              Created:
              Updated:
              Resolved: