Page MenuHomePhabricator

Prepare and check storage layer for minwiktionary
Closed, ResolvedPublic

Description

As part of the new wiki creation process and as per our instructions, please be advised:

  • Project: Wiktionary.
  • Type: Public wiki.

Event Timeline

jhsoby created this task.Mon, Nov 18, 9:58 AM
Restricted Application added a project: User-Urbanecm. · View Herald TranscriptMon, Nov 18, 9:58 AM
Marostegui triaged this task as Medium priority.Mon, Nov 18, 9:59 AM
Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board.

Let us know when the database is created so we can sanitize it before sending it to the WMCS team for the views creation.

Urbanecm removed Urbanecm as the assignee of this task.Mon, Nov 18, 10:26 AM
Urbanecm removed a project: User-Urbanecm.
Urbanecm added a subscriber: Urbanecm.

Unassigning, there's nothing I can do here :-).

Right, sorry – forgot to remove the defaults when creating the task. :-)

Let us know when the database is created so we can sanitize it before sending it to the WMCS team for the views creation.

The database has been just created.

Mentioned in SAL (#wikimedia-operations) [2019-11-21T06:32:37Z] <marostegui> Sanitize shywiktionary gcrwiki szywiki minwiktionary gewikimedia on db1124:3313 T238115 T238114 T237373 T238522 T236404

Marostegui removed Marostegui as the assignee of this task.Thu, Nov 21, 6:50 AM
Marostegui moved this task from Blocked external/Not db team to Done on the DBA board.
Marostegui added subscribers: Andrew, Bstorm, JHedden.

Database sanitized, _p database created and grants done - cloud-services-team please proceed with the views on the 4 hosts.

root@cumin1001:/home/marostegui# for i in labsdb1009 labsdb1010 labsdb1011 labsdb1012; do echo $i ; mysql.py -h$i minwiktionary_p -e "show grants for labsdbuser" | grep minwiktionary ; done
labsdb1009
GRANT SELECT, SHOW VIEW ON `minwiktionary\\_p`.* TO 'labsdbuser'
labsdb1010
GRANT SELECT, SHOW VIEW ON `minwiktionary\\_p`.* TO 'labsdbuser'
labsdb1011
GRANT SELECT, SHOW VIEW ON `minwiktionary\\_p`.* TO 'labsdbuser'
labsdb1012
GRANT SELECT, SHOW VIEW ON `minwiktionary\\_p`.* TO 'labsdbuser'

Mentioned in SAL (#wikimedia-cloud) [2019-11-21T15:46:05Z] <jeh> creating replica indexes and views for minwiktionary T238522

JHedden closed this task as Resolved.Thu, Nov 21, 3:55 PM
JHedden claimed this task.
Updates on labsdb10{09,10,11,12}
$ sudo /usr/local/sbin/maintain-replica-indexes --database minwiktionary --debug
$ sudo /usr/local/sbin/maintain-views --databases minwiktionary --debug
$ sudo /usr/local/sbin/maintain-meta_p --databases minwiktionary