https://bugzilla.wikimedia.org/show_bug.cgi?id=52329
MZMcBride <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|FIXED |--- --- Comment #13 from MZMcBride <[email protected]> --- Christian: Chad and I looked over <https://gerrit.wikimedia.org/reviewer-counts.json> and it seems to be missing about 6,100 changesets. From <http://p.defau.lt/?XeY_5g8lrYwjWblQzZVGrQ>: gerrit> select count(*) from changes; count(*) -------- 78406 gerrit> select count(*) from change_id; count(*) -------- 72305 Do you know why the change_id table is missing thousands of changesets? Can the query be adjusted to include all changesets? More importantly, whatever is generating this .json file isn't outputting valid JSON. It doesn't load into Python's json.loads() and <http://jsonlint.com/> says it's invalid. The Python error: --- Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/__init__.py", line 326, in loads return _default_decoder.decode(s) File "/System/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/decoder.py", line 369, in decode raise ValueError(errmsg("Extra data", s, end, len(s))) ValueError: Extra data: line 2 column 1 - line 72311 column 1 (char 67 - 4914008) --- The JSONLint error: --- Parse error on line 7: ..._count": "2" }}{ "type": "row", ---------------------^ Expecting 'EOF', '}', ',', ']' --- -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
