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

cleaning history_uint

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Major Major
    • None
    • 3.4.0
    • Server (S)
    • zabbix on VMware VM with CentOS 7 and installed from RPM

      Hi Team,

      Recently I upgraded my zabbix from 2.4.6 to 3.4.1-1 and we hit the bug 12618 and I downgraded to 3.4.0-1. On 3.4.0-1 all seems ok but what issue I have observed is data polled, doapled in "latest data" and plotted in graph is in lag with current date and time and it increase over the time.
      I think this could be due to huge size of table history_uint which is around 180GB. I saw couple of blog to create temp table and move latest record to new table and then rename old table and put new table into use, all this when zabbix is stopped.

      I tried this method but insrting data of last week only also taking lot of time and I have to keep my zabbix down for that much time and in mysql query "show processlist" it does not show even one percent progress after spending 30 min, so I cancelled this operation twice and started zabbix back.

      Now I am thinking to create duplicate table as history_uint and not to move any data in it and start zabbix with zero records in it. will this create any issue or its ok to do this operation.

      Thanks

            Unassigned Unassigned
            jitendra.gondaliya Jitendra Gondaliya
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: