- [FAIL] Database: extra index (ciscoASA/device_id_2)
- [FAIL] Database: extra index (devices_attribs/device_id_2)
- [FAIL] Database: extra index (device_graphs/device_id_2)
- [FAIL] Database: extra index (device_perf/device_id_2)
- [FAIL] Database: extra index (eventlog/device_id_2)
- [FAIL] Database: extra index (ipv4_mac/port_id_2)
- [FAIL] Database: extra index (ipv4_mac/mac_address_2)
- [FAIL] Database: extra index (juniAtmVp/port_id_2)
- [FAIL] Database: extra index (links/local_device_id_2)
- [FAIL] Database: extra index (loadbalancer_vservers/device_id_2)
- [FAIL] Database: extra index (ports_fdb/mac_address_2)
- [FAIL] Database: extra index (processors/device_id_3)
- [FAIL] Database: extra index (session/session_value_2)
- [FAIL] Database: extra index (storage/device_id_3)
- [FAIL] Database: extra index (syslog/program_2)
- [FAIL] Database: extra index (ucd_diskio/device_id_3)
- [FAIL] Database: extra column (users/remeber_token)
- [FAIL] Database: extra table (alert_map)
- [FAIL] Database: extra table (bill_port_counters_tmp)
- [FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
- [FIX] Run the following SQL statements to fix.
- SQL Statements:
- ALTER TABLE `ciscoASA` DROP INDEX `device_id_2`;
- ALTER TABLE `devices_attribs` DROP INDEX `device_id_2`;
- ALTER TABLE `device_graphs` DROP INDEX `device_id_2`;
- ALTER TABLE `device_perf` DROP INDEX `device_id_2`;
- ALTER TABLE `eventlog` DROP INDEX `device_id_2`;
- ALTER TABLE `ipv4_mac` DROP INDEX `port_id_2`;
- ALTER TABLE `ipv4_mac` DROP INDEX `mac_address_2`;
- ALTER TABLE `juniAtmVp` DROP INDEX `port_id_2`;
- ALTER TABLE `links` DROP INDEX `local_device_id_2`;
- ALTER TABLE `loadbalancer_vservers` DROP INDEX `device_id_2`;
- ALTER TABLE `ports_fdb` DROP INDEX `mac_address_2`;
- ALTER TABLE `processors` DROP INDEX `device_id_3`;
- ALTER TABLE `session` DROP INDEX `session_value_2`;
- ALTER TABLE `storage` DROP INDEX `device_id_3`;
- ALTER TABLE `syslog` DROP INDEX `program_2`;
- and 4 more...