From TheGreatDoc, 5 Years ago, written in Plain Text.
Embed
  1. [FAIL]  Database: extra index (ciscoASA/device_id_2)
  2. [FAIL]  Database: extra index (devices_attribs/device_id_2)
  3. [FAIL]  Database: extra index (device_graphs/device_id_2)
  4. [FAIL]  Database: extra index (device_perf/device_id_2)
  5. [FAIL]  Database: extra index (eventlog/device_id_2)
  6. [FAIL]  Database: extra index (ipv4_mac/port_id_2)
  7. [FAIL]  Database: extra index (ipv4_mac/mac_address_2)
  8. [FAIL]  Database: extra index (juniAtmVp/port_id_2)
  9. [FAIL]  Database: extra index (links/local_device_id_2)
  10. [FAIL]  Database: extra index (loadbalancer_vservers/device_id_2)
  11. [FAIL]  Database: extra index (ports_fdb/mac_address_2)
  12. [FAIL]  Database: extra index (processors/device_id_3)
  13. [FAIL]  Database: extra index (session/session_value_2)
  14. [FAIL]  Database: extra index (storage/device_id_3)
  15. [FAIL]  Database: extra index (syslog/program_2)
  16. [FAIL]  Database: extra index (ucd_diskio/device_id_3)
  17. [FAIL]  Database: extra column (users/remeber_token)
  18. [FAIL]  Database: extra table (alert_map)
  19. [FAIL]  Database: extra table (bill_port_counters_tmp)
  20. [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):
  21.         [FIX] Run the following SQL statements to fix.
  22.         SQL Statements:
  23.          ALTER TABLE `ciscoASA` DROP INDEX `device_id_2`;
  24.          ALTER TABLE `devices_attribs` DROP INDEX `device_id_2`;
  25.          ALTER TABLE `device_graphs` DROP INDEX `device_id_2`;
  26.          ALTER TABLE `device_perf` DROP INDEX `device_id_2`;
  27.          ALTER TABLE `eventlog` DROP INDEX `device_id_2`;
  28.          ALTER TABLE `ipv4_mac` DROP INDEX `port_id_2`;
  29.          ALTER TABLE `ipv4_mac` DROP INDEX `mac_address_2`;
  30.          ALTER TABLE `juniAtmVp` DROP INDEX `port_id_2`;
  31.          ALTER TABLE `links` DROP INDEX `local_device_id_2`;
  32.          ALTER TABLE `loadbalancer_vservers` DROP INDEX `device_id_2`;
  33.          ALTER TABLE `ports_fdb` DROP INDEX `mac_address_2`;
  34.          ALTER TABLE `processors` DROP INDEX `device_id_3`;
  35.          ALTER TABLE `session` DROP INDEX `session_value_2`;
  36.          ALTER TABLE `storage` DROP INDEX `device_id_3`;
  37.          ALTER TABLE `syslog` DROP INDEX `program_2`;
  38.           and 4 more...
  39.