Maniphest T196359

Prepare and check storage layer for pswikivoyage
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Urbanecm
	Jun 4 2018, 12:42 PM

Project Tags

Referenced Files

None

Subscribers

Description

This is going to be public wiki.

Related Objects
Search...

		Status	Subtype	Assigned	Task
		Resolved		Reedy	T183706 Create Wikivoyage Pashto
		Resolved		• Bstorm	T196359 Prepare and check storage layer for pswikivoyage

Event Timeline

Urbanecm created this task.Jun 4 2018, 12:42 PM

Urbanecm changed the task status from Open to Stalled.

Herald added a project: User-Urbanecm. · View Herald TranscriptJun 4 2018, 12:42 PM

Herald added a subscriber: Aklapper. · View Herald Transcript

Urbanecm moved this task from Backlog to Created on the User-Urbanecm board.Jun 4 2018, 12:43 PM

Let us know when this is created so we can sanitize it.

Mentioned in SAL (#wikimedia-operations) [2018-06-07T14:53:25Z] <marostegui> Sanitize wikis on db1095 (old sanitarium) - T196362 T196358 T196359 T195008 T193187

Stashbot mentioned this in T195008: Prepare and check storage layer for pmswikisource.Jun 7 2018, 2:53 PM

Stashbot mentioned this in T193187: Prepare and check storage layer for idwikimedia.

Mentioned in SAL (#wikimedia-operations) [2018-06-07T15:08:29Z] <marostegui> Sanitize wikis on db1124 (current sanitarium for s3) - T196362 T196358 T196359 T195008 T193187

This wiki has been sanitized. Ready for the views creation cc @bd808 @Bstorm. We have to double check the script for the views works correctly before going for it as a default after changing how the grants are deployed.

• Bstorm claimed this task.Jun 7 2018, 3:54 PM

@Bstorm in order not to block this on the issues we are having with the grant, I have manually run the database and grant creation on all the hosts.
Please feel free to proceed with the views creation

Seems it is working, thanks.

urbanecm@tools-bastion-02 ~ 
$ sql --cluster=analytics pswikivoyage
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 7744512
Server version: 10.1.33-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [pswikivoyage_p]> Bye
urbanecm@tools-bastion-02 ~ 
$ sql --cluster=web pswikivoyage
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 13225461
Server version: 10.1.33-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [pswikivoyage_p]> Bye
urbanecm@tools-bastion-02 ~ 
$