Page MenuHomePhabricator

Add some of the missing tables in wikidatawiki_f_p
Closed, ResolvedPublic

Description

wikidatawiki_p currently contains the following tables:

MariaDB [wikidatawiki_p]> SHOW TABLES;
--------------------------

Tables_in_wikidatawiki_p

--------------------------

abuse_filter
abuse_filter_action
abuse_filter_history
abuse_filter_log
archive
archive_userindex
category
categorylinks
change_tag
externallinks
geo_killlist
geo_tags
geo_updates
global_block_whitelist
globalblocks
hitcounter
image
imagelinks
interwiki
ipblocks
ipblocks_ipindex
iwlinks
l10n_cache
langlinks
logging
logging_logindex
logging_userindex
math
module_deps
msg_resource
msg_resource_links
oldimage
oldimage_userindex
page
page_props
page_restrictions
pagelinks
protected_titles
recentchanges
recentchanges_userindex
redirect
revision
revision_userindex
site_identifiers
site_stats
sites
tag_summary
templatelinks
transcode
updatelog
updates
user
user_former_groups
user_groups
valid_tag
wb_changes
wb_changes_dispatch
wb_entity_per_page
wb_id_counters
wb_items_per_site
wb_terms

--------------------------
61 rows in set (0.03 sec)

The federated version only contains a very small subset of these:

MariaDB [wikidatawiki_f_p]> show tables;
----------------------------

Tables_in_wikidatawiki_f_p

----------------------------

image
logging
logging_userindex
page
revision
revision_userindex
user

----------------------------
7 rows in set (0.03 sec)

I would like to see all the missing tables added, but that seems to be a bridge to far at this moment. So to get about this deadlock please at least add these tables:

  • pagelinks
  • recentchanges
  • recentchanges_userindex
  • wb_changes
  • wb_changes_dispatch
  • wb_entity_per_page
  • wb_id_counters
  • wb_items_per_site
  • wb_terms

Version: unspecified
Severity: enhancement

Details

Reference
bz59682

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 2:19 AM
bzimport added a project: Toolforge.
bzimport set Reference to bz59682.

Change 123916 had a related patch set uploaded by coren:
Labs: automate federated table maintenance

https://gerrit.wikimedia.org/r/123916

Change 123916 merged by coren:
Labs: automate federated table maintenance

https://gerrit.wikimedia.org/r/123916

Federation now provides, by default, the set of public tables.

Still some tables missing:

$mysql -hs2.labsdb -e "show tables from wikidatawiki_f_p like 'wb\_%'"
------------------------------------

Tables_in_wikidatawiki_f_p (wb\_%)

------------------------------------

wb_property_info

------------------------------------

comapred to

$mysql -hs5.labsdb -e "show tables from wikidatawiki_p like 'wb\_%'"
----------------------------------

Tables_in_wikidatawiki_p (wb\_%)

----------------------------------

wb_changes
wb_changes_dispatch
wb_entity_per_page
wb_id_counters
wb_items_per_site
wb_property_info
wb_terms

----------------------------------

Oh yeah, oops; when I added those to replication I have forgotten to also add them to federation.

Hey Marc-André, for merl this is a crucial thing for migrating. Please give this a high priority. Thanks!!

Change 138586 had a related patch set uploaded by coren:
Labs: sync federation up to replication

https://gerrit.wikimedia.org/r/138586

Change 138586 merged by coren:
Labs: sync federation up to replication

https://gerrit.wikimedia.org/r/138586