Ladsgroup (Amir Sarabadani)Administrator
Master of introducing new bugs

Projects (24)

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Sunday

  • Clear sailing ahead.

User Details

User Since
Oct 6 2014, 9:53 PM (189 w, 3 d)
Roles
Administrator
Availability
Available
IRC Nick
Amir1
LDAP User
Ladsgroup
MediaWiki User
Ladsgroup

Recent Activity

Today

Ladsgroup created P7152 Hit count of Special:ItemDisambiguation in May 2018.
Fri, May 25, 5:36 AM

Yesterday

Ladsgroup added a comment to T195520: Multiple projects reporting Cannot access the database: No working replica DB server.

Also property suggester is disabled and article placeholder won't show much and also Special:ItemDisambiguation

Thu, May 24, 9:00 PM · Wikidata-Ministry-Of-Magic, Wikimedia-Incident, MW-1.32-release-notes (WMF-deploy-2018-05-15 (1.32.0-wmf.4)), Wikidata, Patch-For-Review, Wikimedia-General-or-Unknown, Wikimedia-log-errors, Operations
Ladsgroup added a comment to T194273: Clean up indexes of wb_terms table.

Wait a second, I thought it's depooled again. if that's not right, I get to it right now.

Thu, May 24, 12:51 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), Patch-For-Review, DBA, MediaWiki-extensions-WikibaseRepository, Wikidata

Wed, May 23

Ladsgroup claimed T193868: Add code to write to change_tag_def table.
Wed, May 23, 11:22 PM · User-Ladsgroup, Patch-For-Review, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging
GitHub <noreply@github.com> committed rOEQ32a965ad2a18: Merge a0f64651ce0e2f66fb5d246ee9b9f590777b9e83 into… (authored by Ladsgroup).
Merge a0f64651ce0e2f66fb5d246ee9b9f590777b9e83 into…
Wed, May 23, 9:29 PM
Ladsgroup committed rOEQa0f64651ce0e: Add srwiki damaging and goodfaith (authored by Ladsgroup).
Add srwiki damaging and goodfaith
Wed, May 23, 9:28 PM
Ladsgroup moved T195063: Train / test damaging and goodfaith models for srwiki from Active to Review on the Scoring-platform-team (Current) board.

https://github.com/wiki-ai/editquality/pull/160

Wed, May 23, 9:21 PM · Patch-For-Review, Scoring-platform-team (Current), artificial-intelligence, editquality-modeling, User-Ladsgroup
Ladsgroup added a comment to T195063: Train / test damaging and goodfaith models for srwiki.

good faith:

Model Information:
	 - type: GradientBoosting
	 - version: 0.4.0
	 - params: {'criterion': 'friedman_mse', 'min_weight_fraction_leaf': 0.0, 'subsample': 1.0, 'min_impurity_decrease': 0.0, 'min_samples_split': 2, 'random_state': None, 'min_impurity_split': None, 'verbose': 0, 'center': True, 'max_features': 'log2', 'label_weights': OrderedDict([(False, 10)]), 'min_samples_leaf': 1, 'max_depth': 7, 'multilabel': False, 'init': None, 'labels': [True, False], 'n_estimators': 700, 'presort': 'auto', 'scale': True, 'max_leaf_nodes': None, 'population_rates': None, 'warm_start': False, 'learning_rate': 0.1, 'loss': 'deviance'}
	Environment:
	 - revscoring_version: '2.2.3'
	 - platform: 'Linux-4.9.0-6-amd64-x86_64-with-debian-9.4'
	 - machine: 'x86_64'
	 - version: '#1 SMP Debian 4.9.82-1+deb9u3 (2018-03-02)'
	 - system: 'Linux'
	 - processor: ''
	 - python_build: ('default', 'Jan 19 2017 14:11:04')
	 - python_compiler: 'GCC 6.3.0 20170118'
	 - python_branch: ''
	 - python_implementation: 'CPython'
	 - python_revision: ''
	 - python_version: '3.5.3'
	 - release: '4.9.0-6-amd64'
	
	Statistics:
	counts (n=118840):
		label         n         ~True    ~False
		-------  ------  ---  -------  --------
		True     118387  -->   118048       339
		False       453  -->      354        99
	rates:
		              True    False
		----------  ------  -------
		sample       0.996    0.004
		population   0.996    0.004
	match_rate (micro=0.993, macro=0.5):
		  False    True
		-------  ------
		  0.004   0.996
	filter_rate (micro=0.007, macro=0.5):
		  False    True
		-------  ------
		  0.996   0.004
	recall (micro=0.994, macro=0.608):
		  False    True
		-------  ------
		  0.219   0.997
	!recall (micro=0.222, macro=0.608):
		  False    True
		-------  ------
		  0.997   0.219
	precision (micro=0.994, macro=0.612):
		  False    True
		-------  ------
		  0.226   0.997
	!precision (micro=0.229, macro=0.612):
		  False    True
		-------  ------
		  0.997   0.226
	f1 (micro=0.994, macro=0.61):
		  False    True
		-------  ------
		  0.222   0.997
	!f1 (micro=0.225, macro=0.61):
		  False    True
		-------  ------
		  0.997   0.222
	accuracy (micro=0.994, macro=0.994):
		  False    True
		-------  ------
		  0.994   0.994
	fpr (micro=0.778, macro=0.392):
		  False    True
		-------  ------
		  0.003   0.781
	roc_auc (micro=0.99, macro=0.92):
		  False    True
		-------  ------
		  0.849   0.991
	pr_auc (micro=0.996, macro=0.577):
		  False    True
		-------  ------
		  0.155   0.999
	
	 - score_schema: {'title': 'Scikit learn-based classifier score with probability', 'properties': {'prediction': {'type': 'bool', 'description': 'The most likely label predicted by the estimator'}, 'probability': {'properties': {'false': 'number', 'true': 'number'}, 'type': 'object', 'description': 'A mapping of probabilities onto each of the potential output labels'}}, 'type': 'object'}
Wed, May 23, 9:19 PM · Patch-For-Review, Scoring-platform-team (Current), artificial-intelligence, editquality-modeling, User-Ladsgroup
Ladsgroup added a comment to T195063: Train / test damaging and goodfaith models for srwiki.

damaging:

Model Information:
	 - type: GradientBoosting
	 - version: 0.4.0
	 - params: {'min_impurity_split': None, 'max_leaf_nodes': None, 'scale': True, 'init': None, 'min_samples_split': 2, 'presort': 'auto', 'max_features': 'log2', 'center': True, 'min_impurity_decrease': 0.0, 'population_rates': None, 'subsample': 1.0, 'multilabel': False, 'labels': [True, False], 'max_depth': 3, 'criterion': 'friedman_mse', 'loss': 'deviance', 'min_weight_fraction_leaf': 0.0, 'verbose': 0, 'warm_start': False, 'learning_rate': 0.1, 'random_state': None, 'label_weights': OrderedDict([(True, 10)]), 'min_samples_leaf': 1, 'n_estimators': 300}
	Environment:
	 - revscoring_version: '2.2.3'
	 - platform: 'Linux-4.9.0-6-amd64-x86_64-with-debian-9.4'
	 - machine: 'x86_64'
	 - version: '#1 SMP Debian 4.9.82-1+deb9u3 (2018-03-02)'
	 - system: 'Linux'
	 - processor: ''
	 - python_build: ('default', 'Jan 19 2017 14:11:04')
	 - python_compiler: 'GCC 6.3.0 20170118'
	 - python_branch: ''
	 - python_implementation: 'CPython'
	 - python_revision: ''
	 - python_version: '3.5.3'
	 - release: '4.9.0-6-amd64'
	
	Statistics:
	counts (n=118840):
		label         n         ~True    ~False
		-------  ------  ---  -------  --------
		True        669  -->      424       245
		False    118171  -->     1184    116987
	rates:
		              True    False
		----------  ------  -------
		sample       0.006    0.994
		population   0.006    0.994
	match_rate (micro=0.981, macro=0.5):
		  False    True
		-------  ------
		  0.986   0.014
	filter_rate (micro=0.019, macro=0.5):
		  False    True
		-------  ------
		  0.014   0.986
	recall (micro=0.988, macro=0.812):
		  False    True
		-------  ------
		   0.99   0.634
	!recall (micro=0.636, macro=0.812):
		  False    True
		-------  ------
		  0.634    0.99
	precision (micro=0.994, macro=0.631):
		  False    True
		-------  ------
		  0.998   0.264
	!precision (micro=0.268, macro=0.631):
		  False    True
		-------  ------
		  0.264   0.998
	f1 (micro=0.99, macro=0.683):
		  False    True
		-------  ------
		  0.994   0.372
	!f1 (micro=0.376, macro=0.683):
		  False    True
		-------  ------
		  0.372   0.994
	accuracy (micro=0.988, macro=0.988):
		  False    True
		-------  ------
		  0.988   0.988
	fpr (micro=0.364, macro=0.188):
		  False    True
		-------  ------
		  0.366    0.01
	roc_auc (micro=0.979, macro=0.98):
		  False    True
		-------  ------
		  0.979   0.981
	pr_auc (micro=0.997, macro=0.71):
		  False    True
		-------  ------
		      1   0.421
	
	 - score_schema: {'properties': {'probability': {'description': 'A mapping of probabilities onto each of the potential output labels', 'properties': {'true': 'number', 'false': 'number'}, 'type': 'object'}, 'prediction': {'description': 'The most likely label predicted by the estimator', 'type': 'bool'}}, 'type': 'object', 'title': 'Scikit learn-based classifier score with probability'}
Wed, May 23, 6:06 PM · Patch-For-Review, Scoring-platform-team (Current), artificial-intelligence, editquality-modeling, User-Ladsgroup
Ladsgroup added a comment to T194273: Clean up indexes of wb_terms table.

Okay, with the patch deployed, I think we are good to go here, @Marostegui : let me know if anything happens

Wed, May 23, 5:24 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), Patch-For-Review, DBA, MediaWiki-extensions-WikibaseRepository, Wikidata
Ladsgroup moved T194297: Make wp10 rows be a squeezed to a weighted sum in ores_classification from Active to Review on the Scoring-platform-team (Current) board.
Wed, May 23, 1:09 PM · Patch-For-Review, Scoring-platform-team (Current), User-Ladsgroup, MediaWiki-extensions-ORES

Tue, May 22

Ladsgroup moved T190530: Enhanced recent changes don't format external usernames well in contributors summary from Needs Review to Test (Product Review) on the Wikidata-Ministry-Of-Magic board.
Tue, May 22, 10:46 PM · MW-1.32-release-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6)), User-Ladsgroup, Patch-For-Review, Wikidata-Ministry-Of-Magic, MediaWiki-Recent-changes, Wikidata
Ladsgroup moved T193867: Create the change_tag_def table and add the ct_tag_id field to change_tag from Needs Review to Done on the Wikidata-Ministry-Of-Magic board.
Tue, May 22, 9:19 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), Patch-For-Review, Schema-change, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging, User-Ladsgroup
Ladsgroup closed T194614: amwikimedia is loading external resources (webfonts) from Google and rawgit.com as Resolved.

I talked to David and this won't be added. It's safe to call this done.

Tue, May 22, 9:11 PM · User-Ladsgroup, Security, Wikimedia-General-or-Unknown
Ladsgroup added a comment to T194273: Clean up indexes of wb_terms table.

This two index should stay and everything else needs to go (T191391#4191406)

test_user@db2083.codfw.wmnet(wikidatawiki)>show index from wb_terms;
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name         | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_terms |          0 | PRIMARY          |            1 | term_row_id         | A         |  1585960379 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | wb_terms_text    |            1 | term_text           | A         |   528653459 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_full_entity |            1 | term_full_entity_id | A         |   144178216 |     NULL | NULL   | YES  | BTREE      |         |               |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.03 sec)
Tue, May 22, 9:00 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), Patch-For-Review, DBA, MediaWiki-extensions-WikibaseRepository, Wikidata

Mon, May 21

GitHub <noreply@github.com> committed rORESea4af13587a0: Merge pull request #254 from wiki-ai/eslint_fix (authored by Ladsgroup).
Merge pull request #254 from wiki-ai/eslint_fix
Mon, May 21, 12:21 AM

Sun, May 20

Ladsgroup awarded T195220: +2 for Jakob in mediawiki/* a Like token.
Sun, May 20, 5:49 PM · User-Addshore, Repository-Ownership-Requests
Ladsgroup added a comment to T195199: Expose model and filter statistics on a special page.

Ping me when it's not WIP anymore :)

Sun, May 20, 4:49 PM · Patch-For-Review, Wikimania-Hackathon-2018, Scoring-platform-team, MediaWiki-extensions-ORES
Ladsgroup awarded T195199: Expose model and filter statistics on a special page a Love token.
Sun, May 20, 4:49 PM · Patch-For-Review, Wikimania-Hackathon-2018, Scoring-platform-team, MediaWiki-extensions-ORES
Ladsgroup created T195207: Special page to disable OATH for other users.
Sun, May 20, 2:24 PM · Patch-For-Review, MediaWiki-extensions-OATHAuth, User-Ladsgroup
Ladsgroup moved T57377: API: Implement rctitles parameter in query=recentchanges from Blocked to Needs Review on the Wikidata-Ministry-Of-Magic board.
Sun, May 20, 11:47 AM · MW-1.32-release-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6)), User-Ladsgroup, Wikidata-Ministry-Of-Magic, Patch-For-Review, MediaWiki-API
Ladsgroup moved T195193: Schema change for ct_tag_id field to change_tag from Tasks to Blocked on the Wikidata-Ministry-Of-Magic board.
Sun, May 20, 11:46 AM · Blocked-on-schema-change, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging
Ladsgroup created T195193: Schema change for ct_tag_id field to change_tag.
Sun, May 20, 11:46 AM · Blocked-on-schema-change, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging

Sat, May 19

Ladsgroup closed T189596: Run deleteAutopatrolLogs script for Wikidata (WMF), a subtask of T184485: Stop logging autopatrol actions, as Resolved.
Sat, May 19, 12:10 PM · MW-1.32-release-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6)), MW-1.31-release-notes (WMF-deploy-2018-04-17 (1.31.0-wmf.30)), Wikidata-Ministry-Of-Magic-Tech-Debt, Wikidata-Ministry-Of-Magic, User-notice, TechCom-RFC (TechCom-Approved), User-ArielGlenn, MediaWiki-Patrolling, Patch-For-Review, MediaWiki-Logging
Ladsgroup closed T189596: Run deleteAutopatrolLogs script for Wikidata (WMF) as Resolved.

This has been done \o/ 1.1B rows deleted including 99.1% of logging table of wikidatawiki

Sat, May 19, 12:10 PM · Patch-For-Review, User-Ladsgroup, Wikidata, Wikimedia-maintenance-script-run, Wikidata-Ministry-Of-Magic
Ladsgroup moved T190530: Enhanced recent changes don't format external usernames well in contributors summary from In Progress to Needs Review on the Wikidata-Ministry-Of-Magic board.
Sat, May 19, 12:09 PM · MW-1.32-release-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6)), User-Ladsgroup, Patch-For-Review, Wikidata-Ministry-Of-Magic, MediaWiki-Recent-changes, Wikidata
01tonythomas awarded T194030: Phabricator admin request for Ladsgroup a Like token.
Sat, May 19, 9:15 AM · Phabricator
mmodell awarded T194030: Phabricator admin request for Ladsgroup a Like token.
Sat, May 19, 9:15 AM · Phabricator
Ladsgroup added a comment to T194030: Phabricator admin request for Ladsgroup.

Thank you ❤❤❤❤

Sat, May 19, 9:13 AM · Phabricator

Wed, May 16

Ladsgroup added a comment to T194770: [Bug} False positive error in detecting same label-description in Wikidata.

We actually made it more strict so this should not happen, I will check this ASAP

Wed, May 16, 11:34 AM · Wikidata

Tue, May 15

Ladsgroup added a comment to T190867: Add ORES wp10/item_quality predictions to history pages.

I think a gadget makes a lot of sense here because visiting history of articles doesn't happen that often and storing lots of scores doesn't make much sense for this small usecase.

Tue, May 15, 10:49 AM · MediaWiki-Interface, MediaWiki-extensions-ORES, artificial-intelligence, articlequality-modeling, ORES, Scoring-platform-team
Ladsgroup created T194742: Audit deployed editquality models and figure out why if the models are bad.
Tue, May 15, 10:45 AM · Wikimedia-Hackathon-2018, Scoring-platform-team (Current), User-Ladsgroup
Ladsgroup created T194737: Improve features for wikibase vandalism detection model.
Tue, May 15, 10:34 AM · Wikimedia-Hackathon-2018, Scoring-platform-team (Current), User-Ladsgroup

Mon, May 14

Ladsgroup lowered the priority of T194614: amwikimedia is loading external resources (webfonts) from Google and rawgit.com from Unbreak Now! to High.

Removed it. Hope you don't mind if reduce the priority now.

Mon, May 14, 8:59 PM · User-Ladsgroup, Security, Wikimedia-General-or-Unknown
Ladsgroup added a comment to T194213: Disable autopatrol subtype in Special:Log.

https://pt.wikipedia.org/wiki/Special:Log/patrol?subtype=autopatrol still seems to take forever to load. Should this be different now?

Mon, May 14, 8:52 PM · MW-1.32-release-notes (WMF-deploy-2018-05-15 (1.32.0-wmf.4)), Wikidata-Ministry-Of-Magic, MediaWiki-Patrolling, MediaWiki-Logging, User-Ladsgroup
Ladsgroup added a comment to T194614: amwikimedia is loading external resources (webfonts) from Google and rawgit.com.

In order to reduce the priority, is there any need to do more actions?

Mon, May 14, 3:25 AM · User-Ladsgroup, Security, Wikimedia-General-or-Unknown
Ladsgroup updated subscribers of T194614: amwikimedia is loading external resources (webfonts) from Google and rawgit.com.

David is a staff in WMAM, probably an oversight. I will talk to him tomorrow. In the mean time I fixed the privacy issue in this edit
cc. @DavidSaroyan

Mon, May 14, 12:39 AM · User-Ladsgroup, Security, Wikimedia-General-or-Unknown

Sat, May 12

Ladsgroup added a comment to T14129: Log events occasionally not logged.

Is this still a problem?

Sat, May 12, 7:04 PM · TestMe, MediaWiki-Page-editing
Ladsgroup added a comment to T184485: Stop logging autopatrol actions.

I have already deleted 1.1B rows from the database and deleting those rows that at the most will be about 10% of what we have accomplished by now will gain us next to none. I can't put too much time on it unfortunately. I will try to poke it when I have some free time but it's not high priority.

Sat, May 12, 6:59 PM · MW-1.32-release-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6)), MW-1.31-release-notes (WMF-deploy-2018-04-17 (1.31.0-wmf.30)), Wikidata-Ministry-Of-Magic-Tech-Debt, Wikidata-Ministry-Of-Magic, User-notice, TechCom-RFC (TechCom-Approved), User-ArielGlenn, MediaWiki-Patrolling, Patch-For-Review, MediaWiki-Logging
Ladsgroup reassigned T190492: Wrong alias shown in watchlist/history when updating an alias from Ladsgroup to WMDE-leszek.
Sat, May 12, 12:39 PM · MW-1.32-release-notes (WMF-deploy-2018-05-15 (1.32.0-wmf.4)), User-Ladsgroup, Patch-For-Review, Wikidata-Ministry-Of-Magic, Wikidata
Ladsgroup added a comment to T194343: quentinv57-tools/tools/globalcontribs.php generates slow/complex SQL queries which impact server performance.

So I guess this falls under Toolforge-standards-committee now

Sat, May 12, 9:56 AM · Tool-Quentinv57's-tools, Patch-For-Review, DBA, Data-Services

Fri, May 11

Ladsgroup moved T193867: Create the change_tag_def table and add the ct_tag_id field to change_tag from In Progress to Needs Review on the Wikidata-Ministry-Of-Magic board.
Fri, May 11, 7:45 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), Patch-For-Review, Schema-change, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging, User-Ladsgroup
Ladsgroup committed rOEQ49d8ab0cb23a: Fixes bawiki's name and adds bswiki. (#159) (authored by Halfak).
Fixes bawiki's name and adds bswiki. (#159)
Fri, May 11, 6:41 PM
Ladsgroup moved T167989: Add “integer” constraint from In Progress to Needs Review on the Wikidata-Ministry-Of-Magic board.
Fri, May 11, 6:16 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), User-Ladsgroup, Patch-For-Review, Wikidata-Ministry-Of-Magic, Need-volunteer, Wikibase-Quality-Constraints, Wikibase-Quality, Wikidata
Ladsgroup added a comment to T139740: Port Selenium tests from Ruby to Node.js.

I can work on that in the hackathon and then bring back the knowledge to WMDE HQ.

Fri, May 11, 5:14 PM · Release-Engineering-Team, MW-1.31-release-notes (WMF-deploy-2017-11-28 (1.31.0-wmf.10)), MW-1.30-release-notes (WMF-deploy-2017-06-06_(1.30.0-wmf.4)), Epic, MW-1.29-release-notes, MediaWiki-General-or-Unknown, User-zeljkofilipin
Ladsgroup added a comment to T194302: Schema change for new change_tag_def.

I don't think anything will happen but let's check in Monday and if nothing happened, we'll resolve this.

Fri, May 11, 5:10 PM · Wikimedia-log-errors, User-Ladsgroup, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging
Ladsgroup added a comment to T194302: Schema change for new change_tag_def.

The first one happened when I added --query to the command so it tried to run the file address as the query. The second one happened because I ran test run on aawiki first to be sure it works correctly and then ran it again on all wikis which aawiki had it already, it's all good IMO. Is it happening still?

Fri, May 11, 12:21 PM · Wikimedia-log-errors, User-Ladsgroup, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging
Ladsgroup moved T194302: Schema change for new change_tag_def from Tasks to Done on the Wikidata-Ministry-Of-Magic board.

All done.

Fri, May 11, 11:55 AM · Wikimedia-log-errors, User-Ladsgroup, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging
Ladsgroup added a comment to T189596: Run deleteAutopatrolLogs script for Wikidata (WMF).

Everything was still working, if you were patient, you could see they are gone by now.

Fri, May 11, 11:40 AM · Patch-For-Review, User-Ladsgroup, Wikidata, Wikimedia-maintenance-script-run, Wikidata-Ministry-Of-Magic
Ladsgroup raised the priority of T194423: Disable two-step authentication for User Fatemi from High to Needs Triage.

Don't do it

Fri, May 11, 10:14 AM · Trust-and-Safety
Ladsgroup added a comment to T194423: Disable two-step authentication for User Fatemi.

I know the person in real life and met him several times so I can confirm if the request is legit or not. I'm traveling at the moment so it's hard but I will do the checking :)

Fri, May 11, 8:30 AM · Trust-and-Safety

Thu, May 10

Ladsgroup added a comment to T194343: quentinv57-tools/tools/globalcontribs.php generates slow/complex SQL queries which impact server performance.

Also, I have been deleting rows from logging tables in large wikis and changing values in wb_terms of wikidatawiki. This might contribute to the load but they will go away really soon.

Thu, May 10, 8:44 AM · Tool-Quentinv57's-tools, Patch-For-Review, DBA, Data-Services

Wed, May 9

Ladsgroup added a comment to T117781: Convert Special:Preferences to OOUI.

If you're doing it wiki-by-wiki, I offer Persian Wikipedia. They were pretty happy about the change when it got deployed.

Wed, May 9, 9:08 PM · Tech-Ambassadors, MW-1.31-release-notes (WMF-deploy-2017-11-28 (1.31.0-wmf.10)), MediaWiki-User-preferences, Patch-For-Review, Front-end-Standards-Group, MediaWiki-Special-pages, Epic, UI-Standardization
Ladsgroup created T194311: The lemma interface direction is based on direction of the user interface and not lemma's language.
Wed, May 9, 8:58 PM · RTL, Wikidata, Lexicographical data, I18n
Ladsgroup claimed T194302: Schema change for new change_tag_def.

Yes, you're right. i will handle this when it hits production.

Wed, May 9, 8:37 PM · Wikimedia-log-errors, User-Ladsgroup, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging
Ladsgroup created T194302: Schema change for new change_tag_def.
Wed, May 9, 6:47 PM · Wikimedia-log-errors, User-Ladsgroup, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging
Ladsgroup moved T193867: Create the change_tag_def table and add the ct_tag_id field to change_tag from Needs Review to In Progress on the Wikidata-Ministry-Of-Magic board.
Wed, May 9, 6:46 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), Patch-For-Review, Schema-change, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging, User-Ladsgroup
Ladsgroup created T194300: Write a maintaince script to populate wp10 data for articles.
Wed, May 9, 6:41 PM · Scoring-platform-team (Current), User-Ladsgroup, MediaWiki-extensions-ORES
Ladsgroup created T194298: Add option of keep forever for ores scores.
Wed, May 9, 6:39 PM · Scoring-platform-team (Current), User-Ladsgroup, MediaWiki-extensions-ORES
Ladsgroup created T194297: Make wp10 rows be a squeezed to a weighted sum in ores_classification.
Wed, May 9, 6:37 PM · Patch-For-Review, Scoring-platform-team (Current), User-Ladsgroup, MediaWiki-extensions-ORES
GitHub <noreply@github.com> committed rDRAFTTOPIC263e9a12565a: Merge pull request #24 from wiki-ai/model_version (authored by Ladsgroup).
Merge pull request #24 from wiki-ai/model_version
Wed, May 9, 6:19 PM
Ladsgroup committed rEASR10620a3dfe62: Add warning to category search infotext (authored by gabriel-wmde).
Add warning to category search infotext
Wed, May 9, 3:50 PM
Ladsgroup committed rEASR15ebad67ad8e: Add warning to category search infotext (authored by gabriel-wmde).
Add warning to category search infotext
Wed, May 9, 3:50 PM
Ladsgroup updated the task description for T188992: Make wb_terms table fancy.
Wed, May 9, 2:01 PM · DBA, MediaWiki-extensions-WikibaseRepository, Wikidata, Epic
Ladsgroup created T194273: Clean up indexes of wb_terms table.
Wed, May 9, 2:01 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), Patch-For-Review, DBA, MediaWiki-extensions-WikibaseRepository, Wikidata
Ladsgroup created T194270: Drop 'tmp1' index from wb_terms table in production.
Wed, May 9, 1:56 PM · Patch-For-Review, DBA, MediaWiki-extensions-WikibaseRepository, Wikidata
Ladsgroup added a comment to T191391: Apply schema changes to an isolated database and examine the results.

I think this part is done, I make some actionables.

Wed, May 9, 9:57 AM · Wikidata-Ministry-Of-Magic, DBA, MediaWiki-extensions-WikibaseRepository, Wikidata, User-Ladsgroup
Ladsgroup moved T191391: Apply schema changes to an isolated database and examine the results from Blocked to Done on the Wikidata-Ministry-Of-Magic board.
Wed, May 9, 9:57 AM · Wikidata-Ministry-Of-Magic, DBA, MediaWiki-extensions-WikibaseRepository, Wikidata, User-Ladsgroup
Ladsgroup moved T57377: API: Implement rctitles parameter in query=recentchanges from Needs Review to In Progress on the Wikidata-Ministry-Of-Magic board.
Wed, May 9, 9:57 AM · MW-1.32-release-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6)), User-Ladsgroup, Wikidata-Ministry-Of-Magic, Patch-For-Review, MediaWiki-API
Ladsgroup added a comment to T191391: Apply schema changes to an isolated database and examine the results.

After running the optimize table we have this now:

test_user@db2083.codfw.wmnet(wikidatawiki)>SELECT * from information_schema.TABLES where TABLE_NAME = 'wb_terms'\G;
*************************** 1. row ***************************
  TABLE_CATALOG: def
   TABLE_SCHEMA: wikidatawiki
     TABLE_NAME: wb_terms
     TABLE_TYPE: BASE TABLE
         ENGINE: InnoDB
        VERSION: 10
     ROW_FORMAT: Compressed
     TABLE_ROWS: 1600682009
 AVG_ROW_LENGTH: 45
    DATA_LENGTH: 72589770752
MAX_DATA_LENGTH: 0
   INDEX_LENGTH: 52602863616
      DATA_FREE: 0
 AUTO_INCREMENT: 2130542996
    CREATE_TIME: 2018-05-09 07:18:14
    UPDATE_TIME: NULL
     CHECK_TIME: NULL
TABLE_COLLATION: binary
       CHECKSUM: NULL
 CREATE_OPTIONS: row_format=COMPRESSED key_block_size=8
  TABLE_COMMENT:
1 row in set (0.04 sec)
Wed, May 9, 9:52 AM · Wikidata-Ministry-Of-Magic, DBA, MediaWiki-extensions-WikibaseRepository, Wikidata, User-Ladsgroup

Tue, May 8

Ladsgroup claimed T167989: Add “integer” constraint.
Tue, May 8, 10:05 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), User-Ladsgroup, Patch-For-Review, Wikidata-Ministry-Of-Magic, Need-volunteer, Wikibase-Quality-Constraints, Wikibase-Quality, Wikidata
Ladsgroup moved T194213: Disable autopatrol subtype in Special:Log from Tasks to Needs Review on the Wikidata-Ministry-Of-Magic board.
Tue, May 8, 9:13 PM · MW-1.32-release-notes (WMF-deploy-2018-05-15 (1.32.0-wmf.4)), Wikidata-Ministry-Of-Magic, MediaWiki-Patrolling, MediaWiki-Logging, User-Ladsgroup
Ladsgroup triaged T194213: Disable autopatrol subtype in Special:Log as High priority.
Tue, May 8, 9:04 PM · MW-1.32-release-notes (WMF-deploy-2018-05-15 (1.32.0-wmf.4)), Wikidata-Ministry-Of-Magic, MediaWiki-Patrolling, MediaWiki-Logging, User-Ladsgroup
Ladsgroup added a comment to T184485: Stop logging autopatrol actions.

Yes, I make a phabricator ticket and make it happen ASAP.

Tue, May 8, 9:03 PM · MW-1.32-release-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6)), MW-1.31-release-notes (WMF-deploy-2018-04-17 (1.31.0-wmf.30)), Wikidata-Ministry-Of-Magic-Tech-Debt, Wikidata-Ministry-Of-Magic, User-notice, TechCom-RFC (TechCom-Approved), User-ArielGlenn, MediaWiki-Patrolling, Patch-For-Review, MediaWiki-Logging
Ladsgroup added a comment to T184485: Stop logging autopatrol actions.

Yes, We have been removing autopatrol actions (at least anything after September 2011) as well.

Tue, May 8, 8:04 PM · MW-1.32-release-notes (WMF-deploy-2018-05-29 (1.32.0-wmf.6)), MW-1.31-release-notes (WMF-deploy-2018-04-17 (1.31.0-wmf.30)), Wikidata-Ministry-Of-Magic-Tech-Debt, Wikidata-Ministry-Of-Magic, User-notice, TechCom-RFC (TechCom-Approved), User-ArielGlenn, MediaWiki-Patrolling, Patch-For-Review, MediaWiki-Logging
Ladsgroup added a comment to T191391: Apply schema changes to an isolated database and examine the results.

That is very valid. I looked into indexes:

test_user@db2083.codfw.wmnet(wikidatawiki)>show index from wb_terms;
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name            | Seq_in_index | Column_name         | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_terms |          0 | PRIMARY             |            1 | term_row_id         | A         |  1585960379 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | wb_terms_text       |            1 | term_text           | A         |   528653459 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | wb_terms_search_key |            1 | term_search_key     | A         |    28835643 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | tmp1                |            1 | term_language       | A         |     4217979 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | tmp1                |            2 | term_type           | A         |     2969963 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | tmp1                |            3 | term_entity_type    | A         |     6446993 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | tmp1                |            4 | term_search_key     | A         |      577132 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_full_entity    |            1 | term_full_entity_id | A         |   144178216 |     NULL | NULL   | YES  | BTREE      |         |               |
| wb_terms |          1 | term_search_full    |            1 | term_language       | A         |     7552192 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_search_full    |            2 | term_full_entity_id | A         |  1585960379 |     NULL | NULL   | YES  | BTREE      |         |               |
| wb_terms |          1 | term_search_full    |            3 | term_type           | A         |  1585960379 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_search_full    |            4 | term_search_key     | A         |  1585960379 |       16 | NULL   |      | BTREE      |         |               |
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
12 rows in set (0.04 sec)

1- The indexes are pretty different from what we have in the code
2- I dropped all of not-needed indexes:

test_user@db2083.codfw.wmnet(wikidatawiki)>show index from wb_terms;
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name         | Seq_in_index | Column_name         | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wb_terms |          0 | PRIMARY          |            1 | term_row_id         | A         |  1585960379 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | wb_terms_text    |            1 | term_text           | A         |   528653459 |     NULL | NULL   |      | BTREE      |         |               |
| wb_terms |          1 | term_full_entity |            1 | term_full_entity_id | A         |   144178216 |     NULL | NULL   | YES  | BTREE      |         |               |
+----------+------------+------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.03 sec)

I'm running an optimize table on it to reclaim the space and see how much it opens up...

Tue, May 8, 5:13 PM · Wikidata-Ministry-Of-Magic, DBA, MediaWiki-extensions-WikibaseRepository, Wikidata, User-Ladsgroup
Ladsgroup moved T193634: Refactor Context::getSnakGroup from Blocked to Done on the Wikidata-Ministry-Of-Magic board.
Tue, May 8, 4:26 PM · MW-1.32-release-notes (WMF-deploy-2018-05-08 (1.32.0-wmf.3)), Patch-For-Review, Wikidata-Ministry-Of-Magic, Wikibase-Quality-Constraints, Wikibase-Quality, Wikidata
Ladsgroup moved T193634: Refactor Context::getSnakGroup from Needs Review to Blocked on the Wikidata-Ministry-Of-Magic board.
Tue, May 8, 4:26 PM · MW-1.32-release-notes (WMF-deploy-2018-05-08 (1.32.0-wmf.3)), Patch-For-Review, Wikidata-Ministry-Of-Magic, Wikibase-Quality-Constraints, Wikibase-Quality, Wikidata

Mon, May 7

Ladsgroup created T194030: Phabricator admin request for Ladsgroup.
Mon, May 7, 11:46 AM · Phabricator

Sat, May 5

Ladsgroup awarded T193670: ORES logo should be replaced a Love token.
Sat, May 5, 12:25 PM · Design, Scoring-platform-team
Restricted Application added a project to T156494: Perform basic analysis of enwiki article creation rates : artificial-intelligence.

Do we still need to do this? We have the data in ores_classification table and it's just a matter of a query :)

Sat, May 5, 11:12 AM · artificial-intelligence, draftquality-modeling, Scoring-platform-team
Ladsgroup claimed T188282: Create Iginca alerts for dead celery service (pool of workers).
Sat, May 5, 11:08 AM · User-Ladsgroup, Scoring-platform-team (Current), monitoring
Ladsgroup edited projects for T188282: Create Iginca alerts for dead celery service (pool of workers), added: Scoring-platform-team (Current); removed Scoring-platform-team.

I added it: https://grafana-admin.wikimedia.org/dashboard/db/ores?refresh=1m&orgId=1

Sat, May 5, 11:08 AM · User-Ladsgroup, Scoring-platform-team (Current), monitoring
Ladsgroup moved T192267: Enable ores extension article quality storage in beta cluster from Incoming to Done on the User-Ladsgroup board.
Sat, May 5, 10:19 AM · Scoring-platform-team (Current), User-Ladsgroup, artificial-intelligence, drafttopic-modeling, draftquality-modeling, articlequality-modeling
Ladsgroup moved T192268: Enable ores extension wp10 storage in English Wikipedia from Incoming to In progress on the User-Ladsgroup board.
Sat, May 5, 10:19 AM · Patch-For-Review, Scoring-platform-team (Current), User-Ladsgroup, artificial-intelligence, drafttopic-modeling, draftquality-modeling, articlequality-modeling
Ladsgroup closed T166955: Create a message for when campaign is over. as Resolved.

This has been done for a very long time now

Sat, May 5, 10:18 AM · User-Ladsgroup, User-Zppix, Wikilabels, Scoring-platform-team
Ladsgroup closed T166955: Create a message for when campaign is over., a subtask of T164973: Have a clear message when worksets cannot be found for the User, as Resolved.
Sat, May 5, 10:18 AM · Scoring-platform-team (Current), User-Zppix, Wikilabels
Ladsgroup closed T179873: KeyError on "features" as Resolved.

This is not happening anymore, feel free to re-open if it happens again.

Sat, May 5, 9:57 AM · User-Ladsgroup, Scoring-platform-team, ORES
Ladsgroup moved T184205: Add language support for basque from Backlog to New development on the Scoring-platform-team board.

Hey, @MaiteUrra. thank you for reaching out to us. We already generated the list of bad words in meta. Please review them the way that have been explained in this page. Once you're done, please ping me and I will take care of the rest.

Sat, May 5, 9:52 AM · artificial-intelligence, Bad-Words-Detection-System, revscoring, Scoring-platform-team
Ladsgroup added a comment to T186239: Migrate ORES CI to Stretch.

This is not straightforward as Travis doesn't support stretch (or any debian whatsoever). There is one hacky way to do it which to make a docker image and then then run tests on that. See http://travis.debian.net/

Sat, May 5, 9:45 AM · Continuous-Integration-Config, ORES, Scoring-platform-team
Ladsgroup closed T191861: mwparserfromhell ParserError on Premier League as Resolved.

This doesn't error out anymore.

Sat, May 5, 9:32 AM · Scoring-platform-team (Current), ORES
Ladsgroup edited projects for T191861: mwparserfromhell ParserError on Premier League, added: Scoring-platform-team (Current); removed Scoring-platform-team.
Sat, May 5, 9:31 AM · Scoring-platform-team (Current), ORES
Ladsgroup moved T192267: Enable ores extension article quality storage in beta cluster from Active to Done on the Scoring-platform-team (Current) board.

Already done this :)

Sat, May 5, 9:29 AM · Scoring-platform-team (Current), User-Ladsgroup, artificial-intelligence, drafttopic-modeling, draftquality-modeling, articlequality-modeling
Ladsgroup claimed T192267: Enable ores extension article quality storage in beta cluster.
Sat, May 5, 9:29 AM · Scoring-platform-team (Current), User-Ladsgroup, artificial-intelligence, drafttopic-modeling, draftquality-modeling, articlequality-modeling
Ladsgroup claimed T192268: Enable ores extension wp10 storage in English Wikipedia.
Sat, May 5, 9:29 AM · Patch-For-Review, Scoring-platform-team (Current), User-Ladsgroup, artificial-intelligence, drafttopic-modeling, draftquality-modeling, articlequality-modeling

Fri, May 4

Ladsgroup added a comment to T185355: Normalize change tag schema.

I'm doing this :)

Awesome, thank you! What's your best guess for when it will be done? I'm not looking for a commitment, just your current vague estimate: is it closer to 1 month, 3 months, 6 months, or 12 months?

Fri, May 4, 5:53 PM · User-Ladsgroup, MW-1.32-release-notes (WMF-deploy-2018-05-15 (1.32.0-wmf.4)), Wikidata-Ministry-Of-Magic-Tech-Debt, Wikidata-Ministry-Of-Magic, TechCom-RFC (TechCom-Approved), MediaWiki-Database, MediaWiki-Change-tagging, Patch-For-Review
Ladsgroup moved T193867: Create the change_tag_def table and add the ct_tag_id field to change_tag from Tasks to Needs Review on the Wikidata-Ministry-Of-Magic board.
Fri, May 4, 5:49 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), Patch-For-Review, Schema-change, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging, User-Ladsgroup
Ladsgroup moved T193867: Create the change_tag_def table and add the ct_tag_id field to change_tag from Incoming to In progress on the User-Ladsgroup board.
Fri, May 4, 3:23 PM · MW-1.32-release-notes (WMF-deploy-2018-05-22 (1.32.0-wmf.5)), Patch-For-Review, Schema-change, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging, User-Ladsgroup
Ladsgroup created T193874: Add new indexes to change_tag table using ct_tag_id instead of ct_tag.
Fri, May 4, 1:36 PM · Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging
Ladsgroup created T193873: Run maintenance script to populate change_tag_def on WMF production (all wikis).
Fri, May 4, 1:33 PM · Wikimedia-maintenance-script-run, Wikidata-Ministry-Of-Magic, MediaWiki-Database, MediaWiki-Change-tagging