User Details
- User Since
- Mar 22 2021, 7:07 PM (97 w, 5 d)
- Availability
- Available
- LDAP User
- Clare Ming
- MediaWiki User
- CMing (WMF) [ Global Accounts ]
Wed, Feb 1
Tue, Jan 31
Mon, Jan 30
Thu, Jan 26
Tue, Jan 24
Fri, Jan 20
Yay! the integration tests run with console output and local eventgate:
Thu, Jan 19
Thu, Jan 12
Tue, Jan 10
Jan 5 2023
Dec 14 2022
Dec 13 2022
Dec 12 2022
To capture the current state of the ToDos in the task description:
Dec 9 2022
Dec 8 2022
Dec 2 2022
Nov 29 2022
Nov 23 2022
Nov 22 2022
Nov 21 2022
Nov 15 2022
Nov 14 2022
Nov 13 2022
Nov 10 2022
Nov 9 2022
Ran this query earlier in Hue (11/7 is when the latest missing config got deployed for testwiki):
SELECT * FROM mediawiki_visual_editor_feature_use WHERE year=2022 AND month=11 AND day>7;
which returned 77 rows -- here's a sampling of the results:
_schema | agent | custom_data | dt | http | mediawiki | meta | name | page | performer | user_agent_map | is_wmf_domain | normalized_host | datacenter | year | month | day | hour |
NULL | {"app_install_id":null,"client_platform":"mediawiki_js","client_platform_family":"desktop_browser"} | {"feature":{"data_type":"string","value":"editor-switch"},"editing_session_id":{"data_type":"string","value":"redacted"},"editor_interface":{"data_type":"string","value":"wikitext-2017"},"integration":{"data_type":"string","value":"discussiontools"}} | 2022-11-08T20:21:58.568Z | {"has_cookies":null,"method":null,"protocol":null,"request_headers":{"user-agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36"},"response_headers":null,"status_code":null} | {"database":null,"is_debug_mode":null,"is_production":null,"site_content_language":null,"site_content_language_variant":null,"skin":null,"version":null} | {"domain":"test.wikipedia.org","dt":"2022-11-08T20:22:23.093Z","id":"redacted","request_id":"redacted","stream":"mediawiki.visual_editor_feature_use","uri":null} | vefu.visual-desktop | {"title":null,"content_language":null,"id":null,"is_redirect":null,"namespace":null,"namespace_name":null,"revision_id":null,"user_groups_allowed_to_edit":null,"user_groups_allowed_to_move":null,"wikidata_id":null} | {"can_probably_edit_page":null,"edit_count":1,"edit_count_bucket":null,"groups":null,"id":47306,"is_bot":null,"is_logged_in":null,"language":null,"language_variant":null,"name":null,"pageview_id":null,"registration_dt":null,"session_id":null} | {"os_family":"Mac OS X","os_major":"10","os_minor":"15","browser_major":"106","browser_family":"Chrome","device_family":"Mac","wmf_app_version":"-"} | TRUE | {"project_class":"wikipedia","project":"test","qualifiers":[],"tld":"org","project_family":"wikipedia"} | codfw | 2022 | 11 | 8 | 20 |
NULL | {"app_install_id":null,"client_platform":"mediawiki_js","client_platform_family":"desktop_browser"} | {"feature":{"data_type":"string","value":"editor-switch"},"editing_session_id":{"data_type":"string","value":"redacted"},"editor_interface":{"data_type":"string","value":"wikitext-2017"},"integration":{"data_type":"string","value":"discussiontools"}} | 2022-11-08T20:21:53.031Z | {"has_cookies":null,"method":null,"protocol":null,"request_headers":{"user-agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36"},"response_headers":null,"status_code":null} | {"database":null,"is_debug_mode":null,"is_production":null,"site_content_language":null,"site_content_language_variant":null,"skin":null,"version":null} | {"domain":"test.wikipedia.org","dt":"2022-11-08T20:22:23.088Z","id":"redacted","request_id":"redacted","stream":"mediawiki.visual_editor_feature_use","uri":null} | vefu.visual-desktop | {"title":null,"content_language":null,"id":null,"is_redirect":null,"namespace":null,"namespace_name":null,"revision_id":null,"user_groups_allowed_to_edit":null,"user_groups_allowed_to_move":null,"wikidata_id":null} | {"can_probably_edit_page":null,"edit_count":1,"edit_count_bucket":null,"groups":null,"id":47306,"is_bot":null,"is_logged_in":null,"language":null,"language_variant":null,"name":null,"pageview_id":null,"registration_dt":null,"session_id":null} | {"os_family":"Mac OS X","os_major":"10","os_minor":"15","browser_major":"106","browser_family":"Chrome","device_family":"Mac","wmf_app_version":"-"} | TRUE | {"project_class":"wikipedia","project":"test","qualifiers":[],"tld":"org","project_family":"wikipedia"} | codfw | 2022 | 11 | 8 | 20 |
NULL | {"app_install_id":null,"client_platform":"mediawiki_js","client_platform_family":"desktop_browser"} | {"feature":{"data_type":"string","value":"editor-switch"},"editing_session_id":{"data_type":"string","value":"redacted"},"editor_interface":{"data_type":"string","value":"visualeditor"},"integration":{"data_type":"string","value":"discussiontools"}} | 2022-11-08T20:22:00.369Z | {"has_cookies":null,"method":null,"protocol":null,"request_headers":{"user-agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36"},"response_headers":null,"status_code":null} | {"database":null,"is_debug_mode":null,"is_production":null,"site_content_language":null,"site_content_language_variant":null,"skin":null,"version":null} | {"domain":"test.wikipedia.org","dt":"2022-11-08T20:22:23.094Z","id":"redacted","request_id":"redacted","stream":"mediawiki.visual_editor_feature_use","uri":null} | vefu.source-nwe-desktop | {"title":null,"content_language":null,"id":null,"is_redirect":null,"namespace":null,"namespace_name":null,"revision_id":null,"user_groups_allowed_to_edit":null,"user_groups_allowed_to_move":null,"wikidata_id":null} | {"can_probably_edit_page":null,"edit_count":1,"edit_count_bucket":null,"groups":null,"id":47306,"is_bot":null,"is_logged_in":null,"language":null,"language_variant":null,"name":null,"pageview_id":null,"registration_dt":null,"session_id":null} | {"os_family":"Mac OS X","os_major":"10","os_minor":"15","browser_major":"106","browser_family":"Chrome","device_family":"Mac","wmf_app_version":"-"} | TRUE | {"project_class":"wikipedia","project":"test","qualifiers":[],"tld":"org","project_family":"wikipedia"} | codfw | 2022 | 11 | 8 | 20 |
NULL | {"app_install_id":null,"client_platform":"mediawiki_js","client_platform_family":"desktop_browser"} | {"feature":{"data_type":"string","value":"mwSave"},"editing_session_id":{"data_type":"string","value":"redacted"},"editor_interface":{"data_type":"string","value":"visualeditor"},"integration":{"data_type":"string","value":"page"}} | 2022-11-09T10:17:50.575Z | {"has_cookies":null,"method":null,"protocol":null,"request_headers":{"user-agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:108.0) Gecko/20100101 Firefox/108.0"},"response_headers":null,"status_code":null} | {"database":"testwiki","is_debug_mode":null,"is_production":null,"site_content_language":null,"site_content_language_variant":null,"skin":null,"version":null} | {"domain":"test.wikipedia.org","dt":"2022-11-09T10:17:54.016Z","id":"redacted","request_id":"redacted","stream":"mediawiki.visual_editor_feature_use","uri":null} | vefu.window-open-from-command | {"title":null,"content_language":null,"id":null,"is_redirect":null,"namespace":null,"namespace_name":null,"revision_id":null,"user_groups_allowed_to_edit":null,"user_groups_allowed_to_move":null,"wikidata_id":null} | {"can_probably_edit_page":null,"edit_count":151,"edit_count_bucket":null,"groups":null,"id":40269,"is_bot":null,"is_logged_in":null,"language":null,"language_variant":null,"name":null,"pageview_id":null,"registration_dt":null,"session_id":null} | {"os_family":"Mac OS X","os_major":"10","os_minor":"15","browser_major":"108","browser_family":"Firefox","device_family":"Mac","wmf_app_version":"-"} | TRUE | {"project_class":"wikipedia","project":"test","qualifiers":[],"tld":"org","project_family":"wikipedia"} | eqiad | 2022 | 11 | 9 | 10 |
NULL | {"app_install_id":null,"client_platform":"mediawiki_js","client_platform_family":"desktop_browser"} | {"feature":{"data_type":"string","value":"mwSave"},"editing_session_id":{"data_type":"string","value":"redacted"},"editor_interface":{"data_type":"string","value":"visualeditor"},"integration":{"data_type":"string","value":"page"}} | 2022-11-09T10:18:13.478Z | {"has_cookies":null,"method":null,"protocol":null,"request_headers":{"user-agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:108.0) Gecko/20100101 Firefox/108.0"},"response_headers":null,"status_code":null} | {"database":"testwiki","is_debug_mode":null,"is_production":null,"site_content_language":null,"site_content_language_variant":null,"skin":null,"version":null} | {"domain":"test.wikipedia.org","dt":"2022-11-09T10:18:16.109Z","id":"redacted","request_id":"redacted","stream":"mediawiki.visual_editor_feature_use","uri":null} | vefu.dialog-save | {"title":null,"content_language":null,"id":null,"is_redirect":null,"namespace":null,"namespace_name":null,"revision_id":null,"user_groups_allowed_to_edit":null,"user_groups_allowed_to_move":null,"wikidata_id":null} | {"can_probably_edit_page":null,"edit_count":152,"edit_count_bucket":null,"groups":null,"id":40269,"is_bot":null,"is_logged_in":null,"language":null,"language_variant":null,"name":null,"pageview_id":null,"registration_dt":null,"session_id":null} | {"os_family":"Mac OS X","os_major":"10","os_minor":"15","browser_major":"108","browser_family":"Firefox","device_family":"Mac","wmf_app_version":"-"} | TRUE | {"project_class":"wikipedia","project":"test","qualifiers":[],"tld":"org","project_family":"wikipedia"} | eqiad | 2022 | 11 | 9 | 10 |
NULL | {"app_install_id":null,"client_platform":"mediawiki_js","client_platform_family":"desktop_browser"} | {"feature":{"data_type":"string","value":"mwSave"},"editing_session_id":{"data_type":"string","value":"redacted"},"editor_interface":{"data_type":"string","value":"visualeditor"},"integration":{"data_type":"string","value":"page"}} | 2022-11-09T10:17:51.516Z | {"has_cookies":null,"method":null,"protocol":null,"request_headers":{"user-agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:108.0) Gecko/20100101 Firefox/108.0"},"response_headers":null,"status_code":null} | {"database":"testwiki","is_debug_mode":null,"is_production":null,"site_content_language":null,"site_content_language_variant":null,"skin":null,"version":null} | {"domain":"test.wikipedia.org","dt":"2022-11-09T10:17:54.016Z","id":"redacted","request_id":"redacted","stream":"mediawiki.visual_editor_feature_use","uri":null} | vefu.dialog-save | {"title":null,"content_language":null,"id":null,"is_redirect":null,"namespace":null,"namespace_name":null,"revision_id":null,"user_groups_allowed_to_edit":null,"user_groups_allowed_to_move":null,"wikidata_id":null} | {"can_probably_edit_page":null,"edit_count":151,"edit_count_bucket":null,"groups":null,"id":40269,"is_bot":null,"is_logged_in":null,"language":null,"language_variant":null,"name":null,"pageview_id":null,"registration_dt":null,"session_id":null} | {"os_family":"Mac OS X","os_major":"10","os_minor":"15","browser_major":"108","browser_family":"Firefox","device_family":"Mac","wmf_app_version":"-"} | TRUE | {"project_class":"wikipedia","project":"test","qualifiers":[],"tld":"org","project_family":"wikipedia"} | eqiad | 2022 | 11 | 9 | 10 |
NULL | {"app_install_id":null,"client_platform":"mediawiki_js","client_platform_family":"desktop_browser"} | {"feature":{"data_type":"string","value":"mwSave"},"editing_session_id":{"data_type":"string","value":"redacted"},"editor_interface":{"data_type":"string","value":"visualeditor"},"integration":{"data_type":"string","value":"page"}} | 2022-11-09T10:18:12.522Z | {"has_cookies":null,"method":null,"protocol":null,"request_headers":{"user-agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:108.0) Gecko/20100101 Firefox/108.0"},"response_headers":null,"status_code":null} | {"database":"testwiki","is_debug_mode":null,"is_production":null,"site_content_language":null,"site_content_language_variant":null,"skin":null,"version":null} | {"domain":"test.wikipedia.org","dt":"2022-11-09T10:18:16.111Z","id":"redacted","request_id":"redacted","stream":"mediawiki.visual_editor_feature_use","uri":null} | vefu.window-open-from-command | {"title":null,"content_language":null,"id":null,"is_redirect":null,"namespace":null,"namespace_name":null,"revision_id":null,"user_groups_allowed_to_edit":null,"user_groups_allowed_to_move":null,"wikidata_id":null} | {"can_probably_edit_page":null,"edit_count":152,"edit_count_bucket":null,"groups":null,"id":40269,"is_bot":null,"is_logged_in":null,"language":null,"language_variant":null,"name":null,"pageview_id":null,"registration_dt":null,"session_id":null} | {"os_family":"Mac OS X","os_major":"10","os_minor":"15","browser_major":"108","browser_family":"Firefox","device_family":"Mac","wmf_app_version":"-"} | TRUE | {"project_class":"wikipedia","project":"test","qualifiers":[],"tld":"org","project_family":"wikipedia"} | eqiad | 2022 | 11 | 9 | 10 |
NULL | {"app_install_id":null,"client_platform":"mediawiki_js","client_platform_family":"desktop_browser"} | {"feature":{"data_type":"string","value":"reference"},"editing_session_id":{"data_type":"string","value":"redacted"},"editor_interface":{"data_type":"string","value":"visualeditor"},"integration":{"data_type":"string","value":"page"}} | 2022-11-09T11:10:57.606Z | {"has_cookies":null,"method":null,"protocol":null,"request_headers":{"user-agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36"},"response_headers":null,"status_code":null} | {"database":"testwiki","is_debug_mode":null,"is_production":null,"site_content_language":null,"site_content_language_variant":null,"skin":null,"version":null} | {"domain":"test.wikipedia.org","dt":"2022-11-09T11:11:02.706Z","id":"redacted","request_id":"redacted","stream":"mediawiki.visual_editor_feature_use","uri":null} | vefu.context-show | {"title":null,"content_language":null,"id":null,"is_redirect":null,"namespace":null,"namespace_name":null,"revision_id":null,"user_groups_allowed_to_edit":null,"user_groups_allowed_to_move":null,"wikidata_id":null} | {"can_probably_edit_page":null,"edit_count":null,"edit_count_bucket":null,"groups":null,"id":0,"is_bot":null,"is_logged_in":null,"language":null,"language_variant":null,"name":null,"pageview_id":null,"registration_dt":null,"session_id":null} | {"os_family":"Windows","os_major":"10","os_minor":"-","browser_major":"107","browser_family":"Chrome","device_family":"Other","wmf_app_version":"-"} | TRUE | {"project_class":"wikipedia","project":"test","qualifiers":[],"tld":"org","project_family":"wikipedia"} | eqiad | 2022 | 11 | 9 | 11 |
The following properties presumably should be populated? I'll look into these further and file tickets if needed.
Nov 1 2022
Oct 31 2022
Will verify data tomorrow since edit_attempt_step sample rate was bumped up to 1 for group0 wikis this afternoon.
ok - so turns out the edit_attempt stream sample rate is configured to 1 for testwiki only which explains why we have so few query results. We'll apply that sampling rate for all group0 wikis and expect to see an increase in rows returned starting tomorrow if I can get the config deployed this afternoon.
Ran the following query in Hue since the last DT patch was merged on 10/24:
SELECT * FROM mediawiki_edit_attempt WHERE custom_data IS NOT NULL AND year=2022 AND month=10 AND day > 24 AND day < 31;
Query returned 159 rows. Not sure if this is within reasonable ballpark of expected results. The EAS sampling rate in config $wgWMESchemaEditAttemptStepSamplingRate is set to 0.06 for default and 0.2 for a handful of pilot wikis.
Oct 24 2022
Oct 19 2022
Reached out to Editing team in #humansoftheweb channel for their consent before merging associated patches in DiscussionTools + VisualEditor + MobileFrontend.
also verified same event in legacy eventlogging:
also verified legacy eventlogging is still working as well: