Page MenuHomePhabricator

wikidata (federated?) database not available for many wikis
Closed, DuplicatePublic

Description

Despite #57876, for many smaller languages, the (federated?) wikidatawiki_p database is missing/empty:

MariaDB [elwiki_p]> select * from wikidatawiki_p.wb_items_per_site limit 5;
ERROR 1146 (42S02): Table 'wikidatawiki_p.wb_items_per_site' doesn't exist
MariaDB [elwiki_p]> connect wikidatawiki_p
Connection id: 59084196
Current database: wikidatawiki_p

MariaDB [wikidatawiki_p]> show tables;
Empty set (0.00 sec)

Just the beginning of the alphabet includes:
aawiki_p, abwiki_p, acewiki_p, afwiki_p, akwiki_p, alswiki_p, amwiki_p, anwiki_p, angwiki_p, arwiki_p, arcwiki_p, arzwiki_p, aswiki_p, astwiki_p, avwiki_p, aywiki_p, azwiki_p, bawiki_p, barwiki_p, bclwiki_p, bewiki_p, bhwiki_p, biwiki_p, bjnwiki_p, bmwiki_p, bnwiki_p, bowiki_p, bpywiki_p, brwiki_p, bswiki_p, bugwiki_p, bxrwiki_p, cawiki_p, cdowiki_p, cewiki_p, cebwiki_p, chwiki_p, chowiki_p, chrwiki_p, chywiki_p, ckbwiki_p, cowiki_p, crwiki_p, crhwiki_p, csbwiki_p, cuwiki_p, cvwiki_p, cywiki_p, dawiki_p, diqwiki_p, dsbwiki_p, dvwiki_p, dzwiki_p, eewiki_p, emlwiki_p, elwiki_p
but I'm sure there are more...


Version: unspecified
Severity: major

Details

Reference
bz73511

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:48 AM
bzimport added a project: Cloud-VPS.
bzimport set Reference to bz73511.
bzimport added a subscriber: Unknown Object (MLST).
yuvipanda claimed this task.

We no longer have federated databases, all shards have all the databases :)

I don't care what it's called, the error remains. On shell, I do:

sql elwiki_p

In SQL shell, I do:

MariaDB [elwiki_p]> select * from wikidatawiki_p.wb_items_per_site limit 5;
ERROR 1146 (42S02): Table 'wikidatawiki_p.wb_items_per_site' doesn't exist

But if I use "sql enwiki_p", it works. Thus, NOT all shards have all the databases. Bug remains open.

Apologies, I misread the timestamp from the importer. Will investigate.