Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Correct duplicate keys within database #4531

Closed
ddb4github opened this issue Jan 20, 2022 · 2 comments
Closed

Correct duplicate keys within database #4531

ddb4github opened this issue Jan 20, 2022 · 2 comments
Assignees
Labels
bug Undesired behaviour confirmed Bug is confirm by dev team
Milestone

Comments

@ddb4github
Copy link
Contributor

ddb4github commented Jan 20, 2022

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.

@ddb4github ddb4github added bug Undesired behaviour unverified Some days we don't have a clue labels Jan 20, 2022
@TheWitness
Copy link
Member

A pull request would be appreciated @ddb4github. We are pretty close to 1.2.20 release. So, this will likely be in 1.2.21 after we confirm.

@TheWitness TheWitness added this to the 1.2.21 milestone Feb 5, 2022
@github-actions
Copy link

github-actions bot commented Apr 7, 2022

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@github-actions github-actions bot added the outdated No recent activity label Apr 7, 2022
@TheWitness TheWitness added confirmed Bug is confirm by dev team and removed unverified Some days we don't have a clue outdated No recent activity labels Apr 14, 2022
ddb4github added a commit to ddb4github/cacti that referenced this issue Apr 18, 2022
ddb4github added a commit to ddb4github/cacti that referenced this issue Apr 18, 2022
@netniV netniV changed the title Few duplicate key(analyze by percona toolkit 3.3.1) Correct duplicate keys within database May 15, 2022
@github-actions github-actions bot locked and limited conversation to collaborators Nov 30, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Undesired behaviour confirmed Bug is confirm by dev team
Projects
None yet
Development

No branches or pull requests

2 participants