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
Version: unspecified
Severity: major
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=48899
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | jcrespo | T50930 Database replication problems - production and labs (tracking) | |||
| Resolved | None | T50897 wikidatawiki_p missing wb_* tables |
Ah, yes, we hadn't considered Wikidata-specific tables when doing replication. That shouldn't be too hard to add.
afeldman wrote:
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)
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
afeldman wrote:
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.
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.