Skip to content

Correct duplicate keys within database #4531

@ddb4github

Description

@ddb4github

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

  1. Fresh install Cacti from 1.2.x branch
  2. run pt-duplicate-key-checker
  3. 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.

Metadata

Metadata

Assignees

Labels

bugUndesired behaviourconfirmedBug is confirm by dev team

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions