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

Button "clean history and trends" locked database

    XMLWordPrintable

Details

    • Incident report
    • Status: Closed
    • Trivial
    • Resolution: Cannot Reproduce
    • 4.4.4
    • None
    • Frontend (F)
    • Linux 3.10.0-1062.4.3.el7.x86_64 #1 SMP Wed Nov 13 23:58:53 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
      CentOS Linux release 7.7.1908 (Core)
      mysql Ver 8.0.17 for Linux on x86_64 (Source distribution)

    Description

      Steps to reproduce:

      1. In fronted click "Clear history and trends" for host item.
      2. Start request in "DELETE FROM history_uint WHERE itemid=108521", very slow:
        DELETE from history_uint WHERE itemid=108521;
        Query OK, 86307 rows affected (7 min 9,25 sec)
      3. During that time database locked and agents start send messages about agents not available. I must restart mysqld and zabbix_server

      My configuration:
      400 hosts*.* At this time my database ~1,101,808,644 InnoDB utf8_general_ci 79.7 GiB.

      All other function work fine at this time.

      Attachments

        1. 1.png
          1.png
          5 kB
        2. 2.png
          2.png
          4 kB
        3. 3.png
          3.png
          27 kB
        4. 4.png
          4.png
          20 kB

        Activity

          People

            kpavars Kristians Pavars
            pixart Mykola Kuzmych
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: