-
Incident report
-
Resolution: Fixed
-
Minor
-
1.8, 2.0.2
-
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
- is duplicated by
-
ZBX-3142 Duplicate index in history_str_sync
- Closed