Page MenuHomePhabricator
Create Task
Maniphest T243935

Audit all cumin queries in switchdc scripts
Closed, ResolvedPublic
Actions

Description

In the switchdc cookbooks and related spicerack libraries, audit to make sure that each Cumin query still works and still refers to the correct hosts.

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
mysql: adapt Cumin queries to select DBsoperations/software/spicerackmaster+13 -13
mysql_legacy: update Cumin queries for DB selectionoperations/software/spicerackmaster+13 -14
mediawiki: use cumin alias instead of role queryoperations/software/spicerackmaster+3 -3
Customize query in gerrit

Related Objects
Search...

Event Timeline

RLazarus created this task.Jan 30 2020, 1:21 AM
RLazarus added a project: SRE-tools.
gerritbot added a comment.Feb 4 2020, 10:32 PM

Change 570159 had a related patch set uploaded (by Volans; owner: Volans):
[operations/software/spicerack@master] mediawiki: use cumin alias instead of role query

https://gerrit.wikimedia.org/r/570159

gerritbot added a project: Patch-For-Review.Feb 4 2020, 10:32 PM

Change 570161 had a related patch set uploaded (by Volans; owner: Volans):
[operations/software/spicerack@master] mysql: adapt Cumin queries to select DBs

https://gerrit.wikimedia.org/r/570161

Volans triaged this task as Medium priority.Feb 4 2020, 11:08 PM
Volans moved this task from Backlog to In Progress on the SRE-tools board.
gerritbot added a comment.Feb 5 2020, 8:42 PM

Change 570159 merged by jenkins-bot:
[operations/software/spicerack@master] mediawiki: use cumin alias instead of role query

https://gerrit.wikimedia.org/r/570159

Volans reassigned this task from Volans to • Kormat.Jun 24 2020, 2:16 PM
Volans added a subscriber: • Kormat.

The only out of date module is the mysql one (now mysql_legacy). Agreed with @Kormat that he will take care of it given the new Puppet selectors he just introduced.
My old patch for reference is https://gerrit.wikimedia.org/r/c/operations/software/spicerack/+/570161.

• Kormat added a project: DBA.Jun 25 2020, 2:54 PM
• Kormat moved this task from Triage to Backlog on the DBA board.
gerritbot added a comment.Jun 26 2020, 10:15 AM

Change 607996 had a related patch set uploaded (by Kormat; owner: Kormat):
[operations/software/spicerack@master] mysql_legacy: update Cumin queries for DB selection

https://gerrit.wikimedia.org/r/607996

• Kormat moved this task from Backlog to In progress on the DBA board.Jun 26 2020, 10:15 AM
• Kormat added a project: User-Kormat.Jun 26 2020, 10:28 AM
• Kormat moved this task from Unsorted 💣 to Active 🚁 on the User-Kormat board.
• Kormat moved this task from Active 🚁 to Patch for Review on the User-Kormat board.Jun 26 2020, 1:29 PM
gerritbot added a comment.Jul 1 2020, 10:52 AM

Change 607996 merged by jenkins-bot:
[operations/software/spicerack@master] mysql_legacy: update Cumin queries for DB selection

https://gerrit.wikimedia.org/r/c/operations/software/spicerack/ /607996

• Kormat closed this task as Resolved.Jul 1 2020, 10:57 AM

mysql_legacy is now updated, so i think this can be closed.

gerritbot added a comment.Aug 12 2020, 6:34 AM

Change 570161 abandoned by Volans:
[operations/software/spicerack@master] mysql: adapt Cumin queries to select DBs

Reason:
Superseeded by 790b0c7b48290d55346b77b2800b430e8738cbb8

https://gerrit.wikimedia.org/r/570161

Aklapper edited projects, added Cumin; removed SRE-tools.May 10 2023, 11:15 AM
Maintenance_bot moved this task from In progress to Done on the DBA board.May 10 2023, 11:29 AM
Restricted Application added a project: Infrastructure-Foundations. · View Herald TranscriptMay 10 2023, 11:29 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits