-
-
Notifications
You must be signed in to change notification settings - Fork 436
Correct duplicate keys within database #4531
Copy link
Copy link
Closed
Labels
bugUndesired behaviourUndesired behaviourconfirmedBug is confirm by dev teamBug is confirm by dev team
Milestone
Description
Describe the bug
pt-duplicate-key-checker found few duplicate key as below:
ALTER TABLE `cacti`.`data_source_profiles_cf` DROP INDEX `data_source_profile_id`;
ALTER TABLE `cacti`.`data_template_rrd` DROP INDEX `local_data_id`;
ALTER TABLE `cacti`.`graph_template_input_defs` DROP INDEX `graph_template_input_id`;
ALTER TABLE `cacti`.`host` DROP INDEX `site_id`;
ALTER TABLE `cacti`.`host_snmp_query` DROP INDEX `host_id`;
ALTER TABLE `cacti`.`host_template_graph` DROP INDEX `host_template_id`;
ALTER TABLE `cacti`.`host_template_snmp_query` DROP INDEX `host_template_id`;
ALTER TABLE `cacti`.`processes` DROP INDEX `pid`;
ALTER TABLE `cacti`.`snmp_query_graph_rrd` DROP INDEX `snmp_query_graph_id`;
ALTER TABLE `cacti`.`snmpagent_cache_notifications` DROP INDEX `name`;
ALTER TABLE `cacti`.`snmpagent_cache_textual_conventions` DROP INDEX `name`;
ALTER TABLE `cacti`.`snmpagent_managers_notifications` DROP INDEX `manager_id_notification`;To Reproduce
- Fresh install Cacti from 1.2.x branch
- run pt-duplicate-key-checker
- Check terminal output
Expected behavior
A clear and concise description of what you expected to happen.
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information)
-
OS: [e.g. iOS]
-
Browser [e.g. chrome, safari]
-
Version [e.g. 22]
Smartphone (please complete the following information)
-
Device: [e.g. iPhone6]
-
OS: [e.g. iOS8.1]
-
Browser [e.g. stock browser, safari]
-
Version [e.g. 22]
Additional context
Add any other context about the problem here.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugUndesired behaviourUndesired behaviourconfirmedBug is confirm by dev teamBug is confirm by dev team