1335151 - Update Treeherder RO replica MySQL GRANTS for new SETA table

Status: RESOLVED FIXED

(Tree Management :: Treeherder: Infrastructure, defect, P2)

Description

[Ed Morley [:emorley]]

Need to update:
https://treeherder.readthedocs.io/admin.html#direct-database-access

And the redash/activedata users.

Comment 1

[GitHub Autolander Bot]

Attachment: [treeherder] mozilla:update-grants-seta > mozilla:master

Comment 2

[Ed Morley [:emorley]]

The only new addition was the seta_jobpriority table, so I've the GRANTs for it already:

GRANT SELECT ON treeherder.seta_jobpriority to 'redash' REQUIRE SSL;
GRANT SELECT ON treeherder.seta_jobpriority to 'activedata' REQUIRE SSL;

The redash instance refreshes the tables list every 30 minutes, which has just occurred, so the table is now accessible there.

Comment 3

[Cameron Dawson [:camd]]

Comment on attachment 8831791 [details] [review]
[treeherder] mozilla:update-grants-seta > mozilla:master

LGTM: The tests had failed once, but I re-ran them and it all looks good.  :)

Comment 4

[Treeherder GitHub Bugbot]

Commit pushed to master at https://github.com/mozilla/treeherder

https://github.com/mozilla/treeherder/commit/b05967e2265ae6a434882f734ebb2df5871cbd67
Bug 1335151 - Docs: Update read-only replica GRANTs for new SETA table

Also removes `task_set_meta` from the exclusion list, since that table
no longer exists.