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

TODB: Incorrect or missing indexes #6066

Closed
shamrickus opened this issue Jul 28, 2021 · 0 comments · Fixed by #6081
Closed

TODB: Incorrect or missing indexes #6066

shamrickus opened this issue Jul 28, 2021 · 0 comments · Fixed by #6081
Assignees
Labels
bug something isn't working as intended database relating to setup/installation/structure of the Traffic Ops database Traffic Ops related to Traffic Ops
Milestone

Comments

@shamrickus
Copy link
Member

I'm submitting a ...

  • bug report

Traffic Control components affected ...

  • Traffic Ops

Current behavior:

Table topology has no last_updated index, but topology_cachegroup has two including the one for topology which is CREATE INDEX topology_last_updated_idx ON topology_cachegroup ....

Table phys_location has a typo in it's index. The name is listed as pys_location_last_updated_idx instead of phys_location_last_updated_idx

Expected behavior:

For topology, each table should have only one last_updated index.
For phys_location the index should be named correctly.

Minimal reproduction of the problem with instructions:

Run db/admin.go and inspect the schema.

@shamrickus shamrickus added the bug something isn't working as intended label Jul 28, 2021
@mitchell852 mitchell852 added the Traffic Ops related to Traffic Ops label Aug 3, 2021
@mitchell852 mitchell852 added this to the 6.0.0 milestone Aug 3, 2021
@zrhoffman zrhoffman added the database relating to setup/installation/structure of the Traffic Ops database label Aug 20, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug something isn't working as intended database relating to setup/installation/structure of the Traffic Ops database Traffic Ops related to Traffic Ops
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants