Wikireplica service for tools and labs - issues and missing available views (tracking)
Closed, DeclinedPublic
Actions

Assigned To

Authored By

	jcrespo
	Nov 15 2016, 4:28 PM

Description

Use the Data-Services tag instead of this deprecated Tracking-Neverending task.

Issues related to problems found that are specific to the replica service on labsdb1001 and labsdb1003 (a data service provided to tools, and in general Labs users) such as:

Data missing or incorrect
Service unavailable or slow
Tables not made available for querying (views allow querying new tables and wikis)
Improvements on the quality of service

Work on this is normally coordinated between Cloud-Services and SRE teams.

If you see a problem on the replica service, add this one as a parent. We will triage it and see if it is a replication problem (T50930), a user account problem, a performance problem or something else.

Related Objects
Search...

Status	Assigned	Task
Declined	jcrespo	T150767 Wikireplica service for tools and labs - issues and missing available views (tracking)
Resolved	Ladsgroup	T148561 Replicate ores_classification and ores_model tables in labs
Resolved	coren	T50875 Unable to explain queries on replicated databases
Open	None	T70876 Make user_email_authenticated status visible on labs
Open	None	T71088 Queries of commonswiki_p.filearchive for fa_sha1 are slow
Resolved	jcrespo	T138967 Labs database replica drift
Duplicate	None	T141818 Phantom entries in "Quarry" query and or labs replica of enwiki db
Resolved	jcrespo	T159023 Possible labs imagelinks drift
Duplicate	None	T167554 Missing plwikisource_p.revision and plwikisource_p.page data on labs replica database
Declined	None	T172567 Data missing from labs replica of enwiki.imagelinks
Resolved	• Marostegui	T178135 ores_classification table corrupt on enwiki labs replica labsdb1001
Resolved	• Marostegui	T179767 Database replica drift on web and analytics clusters
Resolved	• srodlund	T85868 Document labsdb replication set up
Resolved	Krinkle	T56703 Create web version of metainformation table on replica servers
Declined	None	T89548 labswiki isn't replicated on Labs
Resolved	None	T101631 rev_len should be available also for deleted revisions in database replicas
Resolved	• madhuvishy	T135405 Replicate CentralNotice tables to Labs
Open	None	T139289 Document all tables missing in replicas
Resolved	aborrero	T140609 Add page_props.pp_value index to Wiki Replicas
		Restricted Task
Resolved	• chasemp	T150832 Replicate page_assessments and page_assessments_projects tables on Labs
Resolved	• chasemp	T150679 Some Labs DB user_properties view fields are sensitive
Resolved	jcrespo	T142759 New entries in meta_p.wiki are missing a URL
Resolved	• Marostegui	T153213 Fix broken views in labs DB "ERROR 1356 -- references invalid table(s) or column(s)"
Resolved	jcrespo	T113842 `pr_index` to be replicated to Labs public databases
Resolved	• Marostegui	T174782 Drop pr_index from wikis where ProofreadPage isn't enabled
Resolved	TTO	T154355 page_lang column of the page table is not replicated to Labs
Open	None	T168349 enwiki_p logging vs logging_userindex returning dramatically different results
Resolved	jcrespo	T177096 Some queries to new replica hosts are dramatically slower than labsdb; missing indexes?
Resolved	bd808	T177223 Determine schema differences between labsdb1001 and labsdb1009

Event Timeline

jcrespo created this task.Nov 15 2016, 4:28 PM

Restricted Application added a project: Cloud-Services. · View Herald TranscriptNov 15 2016, 4:28 PM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

jcrespo updated the task description. (Show Details)Nov 15 2016, 4:45 PM

jcrespo mentioned this in T50930: Database replication problems - production and labs (tracking).Nov 15 2016, 4:49 PM

mark added a subtask: T148561: Replicate ores_classification and ores_model tables in labs.Nov 15 2016, 4:51 PM

jcrespo renamed this task from LabsDB replica service issues (tracking) to LabsDB replica service for tools and labs - issues and missing available views (tracking).Nov 15 2016, 4:54 PM

jcrespo updated the task description. (Show Details)

jcrespo added a subtask: T50875: Unable to explain queries on replicated databases.Nov 15 2016, 5:23 PM

jcrespo added a subtask: T70876: Make user_email_authenticated status visible on labs.Nov 15 2016, 5:25 PM

jcrespo added a subtask: T71088: Queries of commonswiki_p.filearchive for fa_sha1 are slow.

jcrespo added a subtask: T138967: Labs database replica drift.Nov 15 2016, 5:29 PM

jcrespo added a subtask: T85868: Document labsdb replication set up.

jcrespo added a subtask: T56703: Create web version of metainformation table on replica servers.Nov 15 2016, 5:32 PM

jcrespo added a subtask: T89548: labswiki isn't replicated on Labs.Nov 15 2016, 5:35 PM

jcrespo added a subtask: T101631: rev_len should be available also for deleted revisions in database replicas.

jcrespo added a subtask: T135405: Replicate CentralNotice tables to Labs.Nov 15 2016, 5:39 PM

jcrespo added a subtask: T139289: Document all tables missing in replicas.

jcrespo added a subtask: T140609: Add page_props.pp_value index to Wiki Replicas.

jcrespo added a subtask: Restricted Task.Nov 15 2016, 5:43 PM

• AlexMonk-WMF added a subscriber: • AlexMonk-WMF.Nov 15 2016, 7:20 PM

kaldari added a subtask: T150832: Replicate page_assessments and page_assessments_projects tables on Labs.Nov 16 2016, 8:14 AM

• chasemp closed subtask T148561: Replicate ores_classification and ores_model tables in labs as Resolved.Nov 16 2016, 4:38 PM

jcrespo added a subtask: T150679: Some Labs DB user_properties view fields are sensitive.Nov 17 2016, 12:26 PM

jcrespo moved this task from Triage to Blocked external/Not db team on the DBA board.

jcrespo added a subtask: T142759: New entries in meta_p.wiki are missing a URL.Nov 25 2016, 4:00 PM

• chasemp closed subtask T150832: Replicate page_assessments and page_assessments_projects tables on Labs as Resolved.Nov 28 2016, 3:20 PM

scfc closed subtask T50875: Unable to explain queries on replicated databases as Resolved.Dec 4 2016, 10:30 PM

Krenair added a subtask: T153213: Fix broken views in labs DB "ERROR 1356 -- references invalid table(s) or column(s)".Dec 14 2016, 6:14 PM

• AlexMonk-WMF added a subtask: T154355: page_lang column of the page table is not replicated to Labs.Dec 31 2016, 11:44 AM

• AlexMonk-WMF removed a subtask: T154355: page_lang column of the page table is not replicated to Labs.Dec 31 2016, 3:56 PM

jcrespo closed subtask T89548: labswiki isn't replicated on Labs as Declined.Mar 3 2017, 9:49 AM

jcrespo mentioned this in T113842: `pr_index` to be replicated to Labs public databases.Mar 3 2017, 10:02 AM

Tpt added a subtask: T113842: `pr_index` to be replicated to Labs public databases.Mar 3 2017, 10:12 AM

jcrespo added a subtask: T154355: page_lang column of the page table is not replicated to Labs.Mar 3 2017, 10:17 AM

• chasemp closed subtask T150679: Some Labs DB user_properties view fields are sensitive as Resolved.Mar 16 2017, 8:04 PM

jcrespo closed subtask T154355: page_lang column of the page table is not replicated to Labs as Resolved.Mar 22 2017, 8:05 PM

jcrespo closed subtask T142759: New entries in meta_p.wiki are missing a URL as Resolved.Apr 5 2017, 11:34 AM

bd808 triaged this task as Medium priority.Jun 13 2017, 7:26 PM

bd808 added a project: Tracking-Neverending.

• Marostegui closed subtask T153213: Fix broken views in labs DB "ERROR 1356 -- references invalid table(s) or column(s)" as Resolved.Jun 26 2017, 7:09 AM

jcrespo added a subtask: T168349: enwiki_p logging vs logging_userindex returning dramatically different results.Jul 3 2017, 9:44 AM

• MZMcBride added a subscriber: • MZMcBride.Jul 5 2017, 3:40 AM

Liuxinyu970226 added a subscriber: Liuxinyu970226.Aug 7 2017, 1:23 AM

• madhuvishy closed subtask T135405: Replicate CentralNotice tables to Labs as Resolved.Aug 31 2017, 11:22 PM

jcrespo renamed this task from LabsDB replica service for tools and labs - issues and missing available views (tracking) to Wikireplica service for tools and labs - issues and missing available views (tracking).Oct 4 2017, 3:21 PM

jcrespo removed a project: Cloud-VPS.

jcrespo edited projects, added Data-Services; removed Cloud-Services.

jcrespo added a subtask: T177096: Some queries to new replica hosts are dramatically slower than labsdb; missing indexes?.

jcrespo closed subtask T177096: Some queries to new replica hosts are dramatically slower than labsdb; missing indexes? as Resolved.Oct 4 2017, 5:42 PM

bd808 moved this task from Backlog to Wiki replicas on the Data-Services board.Oct 6 2017, 3:57 AM

@jcrespo Would you feel ok about closing this tracking bug and instead pointing people to the Data-Services tag? If we need more fine grained tracking that that I would be ok with creating a #wiki-replicas tag as a milestone of Data-Services.