Page MenuHomePhabricator
Create Task
Maniphest T326235

Prepare and check storage layer for gucwiki
Closed, ResolvedPublic
Actions

Description

The new wiki's visibility will be: Public.

Related Objects
Search...

StatusSubtypeAssignedTask
 ResolvedNoneT326236 Post-creation work for gucwiki
 ResolvedDzahnT326240 Add gucwiki to wikistats
 ResolvedZabeT321880 Create Wikipedia Wayuu
 ResolvedBTullisT326235 Prepare and check storage layer for gucwiki

Event Timeline

Maintenance_bot created this task.Jan 4 2023, 2:30 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 4 2023, 2:30 PM
Zabe changed the edit policy from "Custom Policy" to "All Users".Jan 4 2023, 2:33 PM
Marostegui triaged this task as Medium priority.Jan 4 2023, 2:34 PM
Marostegui moved this task from Triage to Blocked on the DBA board.
Marostegui subscribed.

Let us know when the wiki is created so we can sanitize it

Marostegui moved this task from Blocked to Done on the DBA board.Jan 5 2023, 6:50 AM
Marostegui added a project: cloud-services-team.
Marostegui added a subscriber: BTullis.

Sanitized. Database _p and user grants created.
Ready for views creation.

Restricted Application edited projects, added cloud-services-team (Kanban); removed cloud-services-team. · View Herald TranscriptJan 5 2023, 6:50 AM
Marostegui added a comment.Jan 9 2023, 3:44 PM

I thought this wiki was also created (along with a bunch of others) but it wasn't. So I have cleaned up the _p database (but left the user and grants)

Marostegui moved this task from Done to Backlog on the DBA board.Jan 9 2023, 4:00 PM
Marostegui moved this task from Backlog to Blocked on the DBA board.Jan 11 2023, 7:28 PM
JJMC89 moved this task from Backlog to Wiki replicas on the Data-Services board.Jan 12 2023, 10:11 PM
fnegri edited projects, added cloud-services-team; removed cloud-services-team (Kanban).Jan 18 2023, 6:23 PM
fnegri moved this task from Kanban to Inbox on the cloud-services-team board.
Zabe subscribed.Feb 27 2023, 6:04 PM

The database was created.

Ladsgroup subscribed.Feb 27 2023, 8:25 PM

I think I did the sanitation:

root@db1154:~# for i in gucwiki; do echo $i; redact_sanitarium.sh -d $i -S /run/mysqld/mysqld.s5.sock | mysql -S /run/mysqld/mysqld.s5.sock $i ; done
Marostegui added a comment.Feb 28 2023, 6:49 AM

This looks clean and the grants are added GRANT SELECT, SHOW VIEW ON as well as the _p database.
This is ready for the views creation

Marostegui moved this task from Blocked to Done on the DBA board.Feb 28 2023, 6:49 AM
Agusbou2015 subscribed.Mar 5 2023, 12:09 PM
Marostegui added a project: Data-Engineering.Mar 22 2023, 6:17 AM
MarcoAurelio mentioned this in T315442: Wiki replicas are not fully setup for newly created wikis.Mar 29 2023, 2:46 PM
Stashbot added a comment.Mar 29 2023, 3:51 PM

Mentioned in SAL (#wikimedia-operations) [2023-03-29T15:51:06Z] <btullis@cumin1001> Added views for new wiki: gucwiki T326235

BTullis closed this task as Resolved.Mar 29 2023, 4:04 PM
BTullis claimed this task.
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