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

zabbix DB schema contains duplicated indexes for some tables

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.2.0
    • 1.8, 2.0.2
    • Server (S)
    • uname -a
      Linux 2.6.18-53.el5 #1 SMP Mon Nov 12 02:22:48 EST 2007 i686 i686 i386 GNU/Linux

      mysql -V
      mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0

      Running a db check on zabbix db via phpmyadmin warns of an issue with indexes

      SQL query:
      CHECK TABLE `acknowledges`, `actions`, `alerts`, `applications`, `auditlog`, `auditlog_details`, `autoreg_host`, `conditions`, `config`, `dchecks`, `dhosts`, `drules`, `dservices`, `escalations`, `events`, `expressions`, `functions`, `globalmacro`, `graphs`, `graphs_items`, `graph_theme`, `groups`, `help_items`, `history`, `history_log`, `history_str`, `history_str_sync`, `history_sync`, `history_text`, `history_uint`, `history_uint_sync`, `hostmacro`, `hosts`, `hosts_groups`, `hosts_profiles`, `hosts_profiles_ext`, `hosts_templates`, `housekeeper`, `httpstep`, `httpstepitem`, `httptest`, `httptestitem`, `ids`, `images`, `items`, `items_applications`, `maintenances`, `maintenances_groups`, `maintenances_hosts`, `maintenances_windows`, `mappings`, `media`, `media_type`, `nodes`, `node_cksum`, `opconditions`, `operations`, `opmediatypes`, `profiles`, `proxy_autoreg_host`, `proxy_dhistory`, `proxy_history`, `regexps`, `rights`, `screens`, `screens_items`, `scripts`, `services`, `services_[...]

      Problems with indexes of table `history_str_sync`
      The following indexes appear to be equal and one of them should be removed: PRIMARY, id
      Problems with indexes of table `history_sync`
      The following indexes appear to be equal and one of them should be removed: PRIMARY, id
      Problems with indexes of table `history_uint_sync`
      The following indexes appear to be equal and one of them should be removed: PRIMARY, id
      Problems with indexes of table `proxy_autoreg_host`
      The following indexes appear to be equal and one of them should be removed: PRIMARY, id
      Problems with indexes of table `proxy_dhistory`
      The following indexes appear to be equal and one of them should be removed: PRIMARY, id
      Problems with indexes of table `proxy_history`
      The following indexes appear to be equal and one of them should be removed: PRIMARY, id

            Unassigned Unassigned
            pascal.tempier Pascal Tempier
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: