Last modified: 2013-06-21 22:45:44 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 T50897, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 48897 - wikidatawiki_p missing wb_* tables
wikidatawiki_p missing wb_* tables
Status: RESOLVED FIXED
Product: Wikimedia Labs
Classification: Unclassified
tools (Other open bugs)
unspecified
All All
: High major
: ---
Assigned To: Asher Feldman
:
Depends on:
Blocks: labs-replication
  Show dependency treegraph
 
Reported: 2013-05-28 15:16 UTC by Kunal Mehta (Legoktm)
Modified: 2013-06-21 22:45 UTC (History)
4 users (show)

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


Attachments

Description Kunal Mehta (Legoktm) 2013-05-28 15:16:50 UTC
The following tables are replicated on the Toolserver but not on the Labs copy:

wb_changes               
wb_changes_dispatch      
wb_id_counters           
wb_items_per_site        
wb_terms
Comment 1 Peter Bena 2013-05-28 15:50:46 UTC
+ Asher
Comment 2 Marc A. Pelletier 2013-05-30 18:52:12 UTC
Ah, yes, we hadn't considered Wikidata-specific tables when doing replication.  That shouldn't be too hard to add.
Comment 3 Asher Feldman 2013-05-30 19:49:21 UTC
I've created views for these in wikidatawiki_p.  Marc - when you're back from vacation, let's chat to make sure these are included in scripts to autogenerate views in the future and/or the redactatron.

[wikidatawiki_p]> show tables like 'wb%';
+--------------------------------+
| Tables_in_wikidatawiki_p (wb%) |
+--------------------------------+
| wb_changes                     |
| wb_changes_dispatch            |
| wb_id_counters                 |
| wb_items_per_site              |
| wb_terms                       |
+--------------------------------+
5 rows in set (0.03 sec)
Comment 4 Addshore 2013-06-21 21:18:19 UTC
Not all wb_* tables have been added, this is due to the list been taken from toolserver which was in turn missing tables.

After looking at the full list we still need to have the following table added to the replication :)

wb_entity_per_page
Comment 5 Asher Feldman 2013-06-21 21:50:34 UTC
Is there any reason rows or columns from wb_entity_per_page shouldn't be public in certain cases?  That doesn't appear to be the case, but want to be sure since this table wasn't exposed via toolserver.
Comment 6 Kunal Mehta (Legoktm) 2013-06-21 22:19:35 UTC
No, the data the table has is entity id #, entity type, and page_id, all public information. I just spoke with DaB., and the table is now viewable on the TS, its probably that someone just forgot.
Comment 7 Asher Feldman 2013-06-21 22:45:44 UTC
I've added a wb_entity_per_page view to wikidatawiki_p.

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


Navigation
Links