Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Fail: Database: missing index (config/config_config_name_unique)
- Fail: Database: missing index (ospf_areas/ospf_areas_device_id_ospfareaid_context_name_unique)
- Fail: Database: missing index (ospf_instances/ospf_instances_device_id_ospf_instance_id_context_name_unique)
- Fail: Database: extra index (ospf_instances/device_id)
- Fail: Database: missing index (ospf_nbrs/ospf_nbrs_device_id_ospf_nbr_id_context_name_unique)
- Fail: Database: extra index (ospf_nbrs/device_id)
- Fail: Database: missing index (ospf_ports/ospf_ports_device_id_ospf_port_id_context_name_unique)
- Fail: Database: extra index (ospf_ports/device_id)
- Fail: Database: missing index (packages/packages_device_id_index)
- Fail: Database: missing index (packages/packages_device_id_name_manager_arch_version_build_unique)
- Fail: Database: extra index (packages/device_id)
- Fail: Database: extra index (packages/unique_key)
- Fail: Database: missing index (perf_times/perf_times_type_index)
- Fail: Database: extra index (perf_times/type)
- Fail: Database: missing index (pollers/pollers_poller_name_unique)
- Fail: Database: extra index (pollers/poller_name)
- Fail: Database: missing index (poller_cluster_stats/poller_cluster_stats_parent_poller_poller_type_unique)
- Fail: Database: extra index (poller_cluster_stats/parent_poller_poller_type)
- Fail: Database: missing index (ports/ports_device_id_ifindex_unique)
- Fail: Database: missing index (ports/ports_ifdescr_index)
- Fail: Database: extra index (ports/device_ifIndex)
- Fail: Database: extra index (ports/if_2)
- Fail: Database: missing index (ports_adsl/ports_adsl_port_id_unique)
- Fail: Database: extra index (ports_adsl/interface_id)
- Fail: Database: missing index (ports_fdb/ports_fdb_mac_address_index)
- Fail: Database: extra index (ports_fdb/mac_address)
- Fail: Database: missing index (ports_stack/ports_stack_device_id_port_id_high_port_id_low_unique)
- Fail: Database: extra index (ports_stack/device_id)
- Fail: Database: missing index (ports_stp/ports_stp_device_id_port_id_unique)
- Fail: Database: extra index (ports_stp/device_id)
- Fail: Database: missing index (ports_vlans/ports_vlans_device_id_port_id_vlan_unique)
- Fail: Database: extra index (ports_vlans/unique)
- Fail: Database: missing index (processes/processes_device_id_index)
- Fail: Database: extra index (processes/device_id)
- Fail: Database: missing index (processors/processors_device_id_index)
- Fail: Database: extra index (processors/device_id)
- Fail: Database: missing index (proxmox/proxmox_cluster_vmid_unique)
- Fail: Database: extra index (proxmox/cluster_vm)
- Fail: Database: missing index (proxmox_ports/proxmox_ports_vm_id_port_unique)
- Fail: Database: extra index (proxmox_ports/vm_port)
- Fail: Database: missing index (sensors/sensors_device_id_index)
- Fail: Database: missing index (sensors/sensors_sensor_class_index)
- Fail: Database: missing index (sensors/sensors_sensor_type_index)
- Fail: Database: extra index (sensors/sensor_class)
- Fail: Database: extra index (sensors/sensor_host)
- Fail: Database: extra index (sensors/sensor_type)
- Fail: Database: missing index (sensors_to_state_indexes/sensors_to_state_indexes_sensor_id_state_index_id_unique)
- Fail: Database: missing index (sensors_to_state_indexes/sensors_to_state_indexes_state_index_id_index)
- Fail: Database: extra index (sensors_to_state_indexes/sensor_id_state_index_id)
- Fail: Database: extra index (sensors_to_state_indexes/state_index_id)
- Fail: Database: missing index (services/services_device_id_index)
- Fail: Database: extra index (services/service_host)
- Fail: Database: missing index (session/session_session_value_unique)
- Fail: Database: extra index (session/session_value)
- Fail: Database: missing index (slas/slas_device_id_index)
- Fail: Database: missing index (slas/slas_device_id_sla_nr_unique)
- Fail: Database: extra index (slas/device_id)
- Fail: Database: extra index (slas/unique_key)
- Fail: Database: missing index (state_indexes/state_indexes_state_name_unique)
- Fail: Database: extra index (state_indexes/state_name)
- Fail: Database: missing index (state_translations/state_translations_state_index_id_state_value_unique)
- Fail: Database: extra index (state_translations/state_index_id_value)
- Fail: Database: missing index (storage/storage_device_id_index)
- Fail: Database: missing index (storage/storage_device_id_storage_mib_storage_index_unique)
- Fail: Database: extra index (storage/device_id)
- Fail: Database: extra index (storage/index_unique)
- Fail: Database: missing index (stp/stp_device_id_index)
- Fail: Database: extra index (stp/stp_host)
- Fail: Database: missing index (syslog/syslog_device_id_index)
- Fail: Database: missing index (syslog/syslog_device_id_timestamp_index)
- Fail: Database: missing index (syslog/syslog_priority_level_index)
- Fail: Database: missing index (syslog/syslog_program_index)
- Fail: Database: missing index (syslog/syslog_timestamp_index)
- Fail: Database: extra index (syslog/datetime)
- Fail: Database: extra index (syslog/device_id)
- Fail: Database: extra index (syslog/device_id-timestamp)
- Fail: Database: extra index (syslog/priority_level)
- Fail: Database: extra index (syslog/program)
- Fail: Database: missing index (tnmsneinfo/tnmsneinfo_device_id_index)
- Fail: Database: missing index (tnmsneinfo/tnmsneinfo_neid_index)
- Fail: Database: extra index (tnmsneinfo/device_id)
- Fail: Database: extra index (tnmsneinfo/neID)
- Fail: Database: missing index (toner/toner_device_id_index)
- Fail: Database: extra index (toner/device_id)
- Fail: Database: missing index (ucd_diskio/ucd_diskio_device_id_index)
- Fail: Database: extra index (ucd_diskio/device_id)
- Fail: Database: missing index (users/users_auth_type_username_unique)
- Fail: Database: extra index (users/username)
- Fail: Database: missing index (vminfo/vminfo_device_id_index)
- Fail: Database: missing index (vminfo/vminfo_vmwvmvmid_index)
- Fail: Database: extra index (vminfo/device_id)
- Fail: Database: extra index (vminfo/vmwVmVMID)
- Fail: Database: missing index (vrfs/vrfs_device_id_index)
- Fail: Database: extra index (vrfs/device_id)
- Fail: Database: missing index (vrf_lite_cisco/vrf_lite_cisco_context_name_index)
- Fail: Database: missing index (vrf_lite_cisco/vrf_lite_cisco_device_id_context_name_vrf_name_index)
- Fail: Database: missing index (vrf_lite_cisco/vrf_lite_cisco_device_id_index)
- Fail: Database: missing index (vrf_lite_cisco/vrf_lite_cisco_vrf_name_index)
- Fail: Database: extra index (vrf_lite_cisco/context)
- Fail: Database: extra index (vrf_lite_cisco/device)
- Fail: Database: extra index (vrf_lite_cisco/mix)
- Fail: Database: extra index (vrf_lite_cisco/vrf)
- Fail: Database: missing index (widgets/widgets_widget_unique)
- Fail: Database: extra index (widgets/widget)
- Fail: Database: missing index (wireless_sensors/wireless_sensors_device_id_index)
- Fail: Database: missing index (wireless_sensors/wireless_sensors_sensor_class_index)
- Fail: Database: missing index (wireless_sensors/wireless_sensors_sensor_type_index)
- Fail: Database: extra index (wireless_sensors/sensor_class)
- Fail: Database: extra index (wireless_sensors/sensor_host)
- Fail: Database: extra index (wireless_sensors/sensor_type)
- Fail: We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
- Fix:
- Run the following SQL statements to fix.
- SQL Statements
- ALTER TABLE `config` ADD UNIQUE `config_config_name_unique` (`config_name`);
- ALTER TABLE `ospf_areas` ADD UNIQUE `ospf_areas_device_id_ospfareaid_context_name_unique` (`device_id`,`ospfAreaId`,`context_name`);
- ALTER TABLE `ospf_instances` DROP INDEX `device_id`;
- ALTER TABLE `ospf_instances` ADD UNIQUE `ospf_instances_device_id_ospf_instance_id_context_name_unique` (`device_id`,`ospf_instance_id`,`context_name`);
- ALTER TABLE `ospf_nbrs` DROP INDEX `device_id`;
- ALTER TABLE `ospf_nbrs` ADD UNIQUE `ospf_nbrs_device_id_ospf_nbr_id_context_name_unique` (`device_id`,`ospf_nbr_id`,`context_name`);
- ALTER TABLE `ospf_ports` DROP INDEX `device_id`;
- ALTER TABLE `ospf_ports` ADD UNIQUE `ospf_ports_device_id_ospf_port_id_context_name_unique` (`device_id`,`ospf_port_id`,`context_name`);
- ALTER TABLE `packages` DROP INDEX `device_id`;
- ALTER TABLE `packages` DROP INDEX `unique_key`;
- ALTER TABLE `packages` ADD INDEX `packages_device_id_index` (`device_id`);
- ALTER TABLE `packages` ADD UNIQUE `packages_device_id_name_manager_arch_version_build_unique` (`device_id`,`name`,`manager`,`arch`,`version`,`build`);
- ALTER TABLE `perf_times` DROP INDEX `type`;
- ALTER TABLE `perf_times` ADD INDEX `perf_times_type_index` (`type`);
- ALTER TABLE `pollers` DROP INDEX `poller_name`;
- ALTER TABLE `pollers` ADD UNIQUE `pollers_poller_name_unique` (`poller_name`);
- ALTER TABLE `poller_cluster_stats` DROP INDEX `parent_poller_poller_type`;
- ALTER TABLE `poller_cluster_stats` ADD UNIQUE `poller_cluster_stats_parent_poller_poller_type_unique` (`parent_poller`,`poller_type`);
- ALTER TABLE `ports` DROP INDEX `device_ifIndex`;
- ALTER TABLE `ports` DROP INDEX `if_2`;
- ALTER TABLE `ports` ADD UNIQUE `ports_device_id_ifindex_unique` (`device_id`,`ifIndex`);
- ALTER TABLE `ports` ADD INDEX `ports_ifdescr_index` (`ifDescr`);
- ALTER TABLE `ports_adsl` DROP INDEX `interface_id`;
- ALTER TABLE `ports_adsl` ADD UNIQUE `ports_adsl_port_id_unique` (`port_id`);
- ALTER TABLE `ports_fdb` DROP INDEX `mac_address`;
- ALTER TABLE `ports_fdb` ADD INDEX `ports_fdb_mac_address_index` (`mac_address`);
- ALTER TABLE `ports_stack` DROP INDEX `device_id`;
- ALTER TABLE `ports_stack` ADD UNIQUE `ports_stack_device_id_port_id_high_port_id_low_unique` (`device_id`,`port_id_high`,`port_id_low`);
- ALTER TABLE `ports_stp` DROP INDEX `device_id`;
- ALTER TABLE `ports_stp` ADD UNIQUE `ports_stp_device_id_port_id_unique` (`device_id`,`port_id`);
- ALTER TABLE `ports_vlans` DROP INDEX `unique`;
- ALTER TABLE `ports_vlans` ADD UNIQUE `ports_vlans_device_id_port_id_vlan_unique` (`device_id`,`port_id`,`vlan`);
- ALTER TABLE `processes` DROP INDEX `device_id`;
- ALTER TABLE `processes` ADD INDEX `processes_device_id_index` (`device_id`);
- ALTER TABLE `processors` DROP INDEX `device_id`;
- ALTER TABLE `processors` ADD INDEX `processors_device_id_index` (`device_id`);
- ALTER TABLE `proxmox` DROP INDEX `cluster_vm`;
- ALTER TABLE `proxmox` ADD UNIQUE `proxmox_cluster_vmid_unique` (`cluster`,`vmid`);
- ALTER TABLE `proxmox_ports` DROP INDEX `vm_port`;
- ALTER TABLE `proxmox_ports` ADD UNIQUE `proxmox_ports_vm_id_port_unique` (`vm_id`,`port`);
- ALTER TABLE `sensors` DROP INDEX `sensor_class`;
- ALTER TABLE `sensors` DROP INDEX `sensor_host`;
- ALTER TABLE `sensors` DROP INDEX `sensor_type`;
- ALTER TABLE `sensors` ADD INDEX `sensors_device_id_index` (`device_id`);
- ALTER TABLE `sensors` ADD INDEX `sensors_sensor_class_index` (`sensor_class`);
- ALTER TABLE `sensors` ADD INDEX `sensors_sensor_type_index` (`sensor_type`);
- ALTER TABLE `sensors_to_state_indexes` DROP INDEX `sensor_id_state_index_id`;
- ALTER TABLE `sensors_to_state_indexes` DROP INDEX `state_index_id`;
- ALTER TABLE `sensors_to_state_indexes` ADD UNIQUE `sensors_to_state_indexes_sensor_id_state_index_id_unique` (`sensor_id`,`state_index_id`);
- ALTER TABLE `sensors_to_state_indexes` ADD INDEX `sensors_to_state_indexes_state_index_id_index` (`state_index_id`);
- ALTER TABLE `services` DROP INDEX `service_host`;
- ALTER TABLE `services` ADD INDEX `services_device_id_index` (`device_id`);
- ALTER TABLE `session` DROP INDEX `session_value`;
- ALTER TABLE `session` ADD UNIQUE `session_session_value_unique` (`session_value`);
- ALTER TABLE `slas` DROP INDEX `device_id`;
- ALTER TABLE `slas` DROP INDEX `unique_key`;
- ALTER TABLE `slas` ADD INDEX `slas_device_id_index` (`device_id`);
- ALTER TABLE `slas` ADD UNIQUE `slas_device_id_sla_nr_unique` (`device_id`,`sla_nr`);
- ALTER TABLE `state_indexes` DROP INDEX `state_name`;
- ALTER TABLE `state_indexes` ADD UNIQUE `state_indexes_state_name_unique` (`state_name`);
- ALTER TABLE `state_translations` DROP INDEX `state_index_id_value`;
- ALTER TABLE `state_translations` ADD UNIQUE `state_translations_state_index_id_state_value_unique` (`state_index_id`,`state_value`);
- ALTER TABLE `storage` DROP INDEX `device_id`;
- ALTER TABLE `storage` DROP INDEX `index_unique`;
- ALTER TABLE `storage` ADD INDEX `storage_device_id_index` (`device_id`);
- ALTER TABLE `storage` ADD UNIQUE `storage_device_id_storage_mib_storage_index_unique` (`device_id`,`storage_mib`,`storage_index`);
- ALTER TABLE `stp` DROP INDEX `stp_host`;
- ALTER TABLE `stp` ADD INDEX `stp_device_id_index` (`device_id`);
- ALTER TABLE `syslog` DROP INDEX `datetime`;
- ALTER TABLE `syslog` DROP INDEX `device_id`;
- ALTER TABLE `syslog` DROP INDEX `device_id-timestamp`;
- ALTER TABLE `syslog` DROP INDEX `priority_level`;
- ALTER TABLE `syslog` DROP INDEX `program`;
- ALTER TABLE `syslog` ADD INDEX `syslog_device_id_index` (`device_id`);
- ALTER TABLE `syslog` ADD INDEX `syslog_device_id_timestamp_index` (`device_id`,`timestamp`);
- ALTER TABLE `syslog` ADD INDEX `syslog_priority_level_index` (`priority`,`level`);
- ALTER TABLE `syslog` ADD INDEX `syslog_program_index` (`program`);
- ALTER TABLE `syslog` ADD INDEX `syslog_timestamp_index` (`timestamp`);
- ALTER TABLE `tnmsneinfo` DROP INDEX `device_id`;
- ALTER TABLE `tnmsneinfo` DROP INDEX `neID`;
- ALTER TABLE `tnmsneinfo` ADD INDEX `tnmsneinfo_device_id_index` (`device_id`);
- ALTER TABLE `tnmsneinfo` ADD INDEX `tnmsneinfo_neid_index` (`neID`);
- ALTER TABLE `toner` DROP INDEX `device_id`;
- ALTER TABLE `toner` ADD INDEX `toner_device_id_index` (`device_id`);
- ALTER TABLE `ucd_diskio` DROP INDEX `device_id`;
- ALTER TABLE `ucd_diskio` ADD INDEX `ucd_diskio_device_id_index` (`device_id`);
- ALTER TABLE `users` DROP INDEX `username`;
- ALTER TABLE `users` ADD UNIQUE `users_auth_type_username_unique` (`auth_type`,`username`);
- ALTER TABLE `vminfo` DROP INDEX `device_id`;
- ALTER TABLE `vminfo` DROP INDEX `vmwVmVMID`;
- ALTER TABLE `vminfo` ADD INDEX `vminfo_device_id_index` (`device_id`);
- ALTER TABLE `vminfo` ADD INDEX `vminfo_vmwvmvmid_index` (`vmwVmVMID`);
- ALTER TABLE `vrfs` DROP INDEX `device_id`;
- ALTER TABLE `vrfs` ADD INDEX `vrfs_device_id_index` (`device_id`);
- ALTER TABLE `vrf_lite_cisco` DROP INDEX `context`;
- ALTER TABLE `vrf_lite_cisco` DROP INDEX `device`;
- ALTER TABLE `vrf_lite_cisco` DROP INDEX `mix`;
- ALTER TABLE `vrf_lite_cisco` DROP INDEX `vrf`;
- ALTER TABLE `vrf_lite_cisco` ADD INDEX `vrf_lite_cisco_context_name_index` (`context_name`);
- ALTER TABLE `vrf_lite_cisco` ADD INDEX `vrf_lite_cisco_device_id_context_name_vrf_name_index` (`device_id`,`context_name`,`vrf_name`);
- ALTER TABLE `vrf_lite_cisco` ADD INDEX `vrf_lite_cisco_device_id_index` (`device_id`);
- ALTER TABLE `vrf_lite_cisco` ADD INDEX `vrf_lite_cisco_vrf_name_index` (`vrf_name`);
- ALTER TABLE `widgets` DROP INDEX `widget`;
- ALTER TABLE `widgets` ADD UNIQUE `widgets_widget_unique` (`widget`);
- ALTER TABLE `wireless_sensors` DROP INDEX `sensor_class`;
- ALTER TABLE `wireless_sensors` DROP INDEX `sensor_host`;
- ALTER TABLE `wireless_sensors` DROP INDEX `sensor_type`;
- ALTER TABLE `wireless_sensors` ADD INDEX `wireless_sensors_device_id_index` (`device_id`);
- ALTER TABLE `wireless_sensors` ADD INDEX `wireless_sensors_sensor_class_index` (`sensor_class`);
- ALTER TABLE `wireless_sensors` ADD INDEX `wireless_sensors_sensor_type_index` (`sensor_type`);
Add Comment
Please, Sign In to add comment