Last modified: 2014-06-10 12:34:37 UTC
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
+1!
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
Views added.