[15:01:17] (03PS9) 10Aude: Refactor EntityPerPageBuilder and test [extensions/Wikibase] - 10https://gerrit.wikimedia.org/r/102685 [15:15:18] (03PS10) 10Aude: Refactor EntityPerPageBuilder and test [extensions/Wikibase] - 10https://gerrit.wikimedia.org/r/102685 [15:16:38] (03CR) 10Aude: "patchset 10 addresses comments and suggestions by hoo" [extensions/Wikibase] - 10https://gerrit.wikimedia.org/r/102685 (owner: 10Aude) [15:20:43] (03CR) 10Hoo man: [C: 031] "Not into this enough to merge, but looks good" [extensions/Wikibase] - 10https://gerrit.wikimedia.org/r/102685 (owner: 10Aude) [15:32:23] https://www.wikidata.org/wiki/Special:Statistics according to that we're close to 100M edits... but that's probably not true [15:36:16] MariaDB [wikidatawiki_p]> SELECT c1 +c2 AS edit_count FROM ( SELECT COUNT(rev_id ) AS c1 FROM revision) AS rev, (SELECT COUNT(ar_id ) AS c2 FROM archive) AS arch; [15:36:17] 96992583 [15:36:42] although that's on Labs, so the number is probably (slightly) higher in production as Labs is messing with stuff [15:37:24] probably true [15:37:45] we had ~76-80 million back in september [15:43:01] max rev_id = 97242726 + maybe delete edits? [15:43:21] aude: IIRC, it does include deleted edits. [15:43:30] Then again, don't quote me :p [15:43:57] aude: My count also included the archive page... [15:44:08] hoo: ok :) [15:44:26] at some points code fetches auto increment ids and the edits still don't make it [15:44:33] (exceptions, ...) [15:44:44] same goes for site stats table updates [15:44:51] hoo: So basically, down with AbuseFilter and Special:Statstics? :p [15:45:04] (As in, rewrite perhaps?) [15:46:36] it does select count(*) from revision + seelct count(*) from archive [15:46:55] 95699038 + 1295731, so not quite what special:statistics ays [15:46:57] aude: Really? [15:46:57] says* [15:47:22] hoo: really, yes ... according to SiteStats [15:47:32] which the special page uses [15:48:31] max rev_id would be equivalent i think [15:48:32] aude: Nah, it uses the site_stats table [15:48:57] MariaDB [wikidatawiki_p]> SELECT ss_total_edits FROM site_stats; [15:49:01] 100002402 [15:49:07] well, that's how it gets updated [15:50:04] aude: No, that's how it's inited [15:50:16] I could verify if WMF finally gave me real world DB... [15:50:46] SiteStatsUpdate does the updates [15:51:00] mh [15:52:49] var $ssi = new SiteStatsInit(); $ssi->doAllAndCommit(); [15:53:09] One needs to run that to refresh things... would probably run a few minutes in production [15:53:21] hmmm, ok [15:53:37] maybe the deferred update gets called for some log actions [15:54:14] aude: mh... maybe we call(ed) it at some point before doing some kind of sanity check... so that we increase the number before actually pushing the edit [15:54:28] could be [15:54:33] all those skipped ids [17:36:54] Lydia_WMDE: https://bugzilla.wikimedia.org/show_bug.cgi?id=59128 could be a really easy bug :P [18:03:00] aude: Can you still read Arabic? [18:18:39] why? [18:19:17] multichill: ^ [19:54:54] aude: https://ar.wikipedia.org/wiki/%D8%B3%D9%8A%D8%AA%D9%8A_%D9%85%D9%88%D9%81%D8%B1%D8%B2_%D8%A8%D9%88%D9%86%D8%AA_%D9%86%D8%A7%D9%84 <- spam? [20:09:39] [travis-ci] wikimedia/mediawiki-extensions-WikibaseQuery#98 (master - 3481ce3 : Translation updater bot): The build has errored. [20:09:39] [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-WikibaseQuery/compare/a826b822754a...3481ce3a154a [20:09:39] [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-WikibaseQuery/builds/16156561 [20:11:49] [travis-ci] wikimedia/mediawiki-extensions-WikibaseQueryEngine#102 (master - 5cb0262 : Translation updater bot): The build failed. [20:11:49] [travis-ci] Change view : https://github.com/wikimedia/mediawiki-extensions-WikibaseQueryEngine/compare/5d787f152950...5cb026279e7c [20:11:49] [travis-ci] Build details : http://travis-ci.org/wikimedia/mediawiki-extensions-WikibaseQueryEngine/builds/16156549 [20:32:32] multichill: yes it's spam... lists places they serve. etc. nothing notable [20:33:16] * aude can read enough to know that