| Melderick created this task. Melderick added projects: Wikidata, Dumps-Generation. Herald added a subscriber: Zppix. |
Line 21232819 of latest dump contains unexpected sql warning after the definition of item Q22251178 :
[Mon Jun 20 13:54:32 2016] [hphp] [24609:7f90e5f5b100:0:000001] [] SlowTimer [14607ms] at runtime/ext_mysql: slow query: SELECT /* Wikibase\Lib\Store\Sql\WikiPageEntityMetaDataLookup::selectRevisionInformationMultiple */ rev_id,rev_content_format,rev_timestamp,page_latest,page_is_redirect,old_id,old_text,old_flags,page_title FROM page INNER JOIN revision ON ((page_latest=rev_id)) INNER JOIN text ON ((old_id=rev_text_id)) WHERE (('Q22251189'=page_title) AND (0=page_namespace)) OR (('Q22251195'=page_title) AND (0=page_namespace)) OR (('Q22251204'=page_title) AND (0=page_namespace)) OR (('Q22251206'=page_title) AND (0=page_namespace)) OR (('Q22251207'=page_title) AND (0=page_namespace)) OR (('Q22251208'=page_title) AND (0=page_namespace)) OR (('Q22251211'=page_title) AND (0=page_namespace)) OR (('Q22251216'=page_title) AND (0=page_namespace)) OR (('Q22251218'=page_title) AND (0=page_namespace)) OR (('Q22251220'=page_title) AND (0=page_namespace)) OR (('Q22251223'=page_title) AND (0=page_namespace)) OR (('Q22251228'=page_title) AND (0=page_namespace)) OR (('Q22251233'=page_title) AND (0=page_namespace)) OR (('Q22251245'=page_title) AND (0=page_namespace)) OR (('Q22251251'=page_title) AND (0=page_namespace)) OR (('Q22251258'=page_title) AND (0=page_namespace)) OR (('Q22251262'=page_title) AND (0=page_namespace)) OR (('Q22251263'=page_title) AND (0=page_namespace)) OR (('Q22251264'=page_title) AND (0=page_namespace)) OR (('Q22251267'=page_title) AND (0=page_namespace)) OR (('Q22251269'=page_title) AND (0=page_namespace)) OR (('Q22251271'=page_title) AND (0=page_namespace))
Steps to Reproduce:
- Get latest JSON dump wikidata-20160620-all.json (from https://dumps.wikimedia.org/wikidatawiki/entities/)
- Run this unix command :
split -n l/21207/21814 wikidata-20160620-all.json | grep -A1 Q22251178
Expected Results:
<JSON definition of Q22251178>,
<JSON definition of another item>,
Actual Results:
<JSON definition of Q22251178><above SQL warning>
,
Cc: Melderick, Zppix, D3r1ck01, Izno, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
