Last modified: 2014-06-10 12:34:37 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T61682, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 59682 - Add some of the missing tables in wikidatawiki_f_p
Add some of the missing tables in wikidatawiki_f_p
Status: RESOLVED FIXED
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: High enhancement
: ---
Assigned To: Marc A. Pelletier
:
Depends on: 63384
Blocks: tool-missing-ts-feat
  Show dependency treegraph
 
Reported: 2014-01-05 15:37 UTC by Maarten Dammers
Modified: 2014-06-10 12:34 UTC (History)
6 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Maarten Dammers 2014-01-05 15:37:00 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
Comment 1 Silke Meyer (WMDE) 2014-01-23 17:42:47 UTC
+1!
Comment 2 Gerrit Notification Bot 2014-04-04 19:51:56 UTC
Change 123916 had a related patch set uploaded by coren:
Labs: automate federated table maintenance

https://gerrit.wikimedia.org/r/123916
Comment 3 Gerrit Notification Bot 2014-04-04 19:52:51 UTC
Change 123916 merged by coren:
Labs: automate federated table maintenance

https://gerrit.wikimedia.org/r/123916
Comment 4 Marc A. Pelletier 2014-04-04 19:54:13 UTC
Federation now provides, by default, the set of public tables.
Comment 5 merl 2014-06-07 06:33:31 UTC
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                         |
+----------------------------------+
Comment 6 Marc A. Pelletier 2014-06-07 12:22:07 UTC
Oh yeah, oops; when I added those to replication I have forgotten to also add them to federation.
Comment 7 Silke Meyer (WMDE) 2014-06-10 08:55:22 UTC
Hey Marc-André, for merl this is a crucial thing for migrating. Please give this a high priority. Thanks!!
Comment 8 Gerrit Notification Bot 2014-06-10 12:27:32 UTC
Change 138586 had a related patch set uploaded by coren:
Labs: sync federation up to replication

https://gerrit.wikimedia.org/r/138586
Comment 9 Gerrit Notification Bot 2014-06-10 12:28:51 UTC
Change 138586 merged by coren:
Labs: sync federation up to replication

https://gerrit.wikimedia.org/r/138586
Comment 10 Marc A. Pelletier 2014-06-10 12:34:37 UTC
Views added.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links