Page MenuHomePhabricator

Re-run maintainviews on all clouddb* and an-redacteddb1001.eqiad.wmnet
Closed, ResolvedPublic

Description

The parent's schema change breaks views on the imagelinks view (which is expected)
This requires running the following command son all clouddb* and an-redacteddb1001

maintain-views --all-databases --replace --table imagelinks

I got pinged by @amastilovic about issues with this.
I've preventively ran the above everywhere as I am not sure where the schema change has been ran already so this should've mitigated the current issues, but we need to ran section per section
@FCeratto-WMF can you ensure this is run everytime a section is finished for the involved clouddb* hosts and an-redacteddb1001 - otherwise this keeps the sqooping broken.

Event Timeline

Marostegui triaged this task as High priority.
Marostegui moved this task from Ready to In progress on the DBA board.

Can confirm that this resolved our Sqoop issue - thank you @Marostegui !

@FCeratto-WMF has the parent's schema change progressed in any section that'd require recreating the views here?

Not yet, I'm looking at an error while updating s5 but in the meantime I'm starting another section.

The run on s5 had an error that needs further investigation: https://phabricator.wikimedia.org/P90336 .

FCeratto-WMF updated the task description. (Show Details)

Done on cloudb* hosts after schema changes reached them.