F7. Check for other missing users on MediaWiki.org in revision or LQT tables
Closed, ResolvedPublic
Actions

Related Objects
Search...

Status	Assigned	Task
Resolved	• DannyH	T171977 Annual Plan 2017-2018, Audiences 5: Increase current editor retention and engagement
Resolved	• DannyH	T171982 Annual Plan 2017-2018, Audiences 5, Goal 3: Provide better workflow and communication experiences
Open	None	T167928 Improve structured discussion features for the communities that use them, based on user feedback and prioritising technical debt
Open	None	T89426 Allow to uninstall all LiquidThreads code except the parts necessary for the remaining content, to be moved into (?)WikimediaMessages
Resolved	Catrope	T106302 Convert LQT->Flow on se.wikimedia.org
Resolved	• Mattflaschen-WMF	T92303 Convert LQT pages on MediaWiki.org to Flow (tracking)
Resolved	• Mattflaschen-WMF	T106613 F8. Run LQT conversion script on mediawiki.org VE/Feedback
Resolved	• Mattflaschen-WMF	T106614 F9. Run LQT conversion script on mediawiki.org Project:Support desk
Resolved	• Mattflaschen-WMF	T106569 F7. Check for other missing users on MediaWiki.org in revision or LQT tables

Event Timeline

• Mattflaschen-WMF created this task.Jul 22 2015, 6:44 PM

• Mattflaschen-WMF claimed this task.

• Mattflaschen-WMF raised the priority of this task from to High.

• Mattflaschen-WMF updated the task description. (Show Details)

• Mattflaschen-WMF added projects: Collaboration-Team-Triage, StructuredDiscussions.

• Mattflaschen-WMF added subscribers: SBisson, Krenair, Glaisher and 17 others.

• DannyH added a project: Collaboration-Team-Archive-2015-2016.Jul 22 2015, 9:36 PM

• DannyH set Security to None.

• DannyH added a parent task: T106614: F9. Run LQT conversion script on mediawiki.org Project:Support desk.Jul 22 2015, 9:43 PM

• DannyH added a parent task: T106613: F8. Run LQT conversion script on mediawiki.org VE/Feedback.

• DannyH renamed this task from Check for other missing users on MediaWiki.org in revision or LQT tables to F7. Check for other missing users on MediaWiki.org in revision or LQT tables.Jul 23 2015, 12:42 AM

The regexp syntax is to approximate the detection of IP addresses (both IPv4 and IPv6).

There were none in thread, but there were many in revision when I just did the general query. These may be caused by imports.

So I also queried revision for the specific two remaining pages, and it seems we're not affected:

P1046 Pre-check of missing users

1	mysql:research@s3-analytics-slave [mediawikiwiki]> SELECT thread_author_name, user_name FROM thread LEFT OUTER JOIN user ON thread_author_name = user_name WHERE user_name IS NULL AND thread_author_name NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' AND thread_author_name NOT REGEXP '^[0-9A-F].:([0-9A-F])*$' LIMIT 1;
2	Empty set (0.10 sec)
3
4	mysql:research@s3-analytics-slave [mediawikiwiki]> SELECT DISTINCT rev_user_text, user_name FROM revision LEFT OUTER JOIN user ON rev_user_text = user_name WHERE user_name IS NULL AND rev_user_text NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' AND rev_user_text NOT REGEXP '^[0-9A-F].:([0-9A-F])*$' LIMIT 100;
5
6	; Output not shown in case any are suppressed user names, but there were rows, so the below filters to only pages we care about, plus all LQT namespaces
7
8	mysql:research@s3-analytics-slave [mediawikiwiki]> SELECT page_namespace, page_title, rev_user_text, user_name FROM page JOIN revision ON page_id = rev_page LEFT OUTER JOIN user ON rev_user_text = user_name WHERE user_name IS NULL AND rev_user_text NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' AND rev_user_text NOT REGEXP '^[0-9A-F].:([0-9A-F])*$' AND ( ( page_namespace = 4 AND page_title = 'Support_desk' ) OR ( page_namespace = 0 AND page_title = 'VisualEditor/Feedback' ) OR page_namespace IN ( 90, 91, 92, 93 ) ) LIMIT 100;
9	Empty set (1.31 sec)
10
11	mysql:research@s3-analytics-slave [mediawikiwiki]> SELECT th_user_text, user_name FROM thread_history LEFT OUTER JOIN user ON th_user_text = user_name WHERE user_name IS NULL AND th_user_text NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' AND th_user_text NOT REGEXP '^[0-9A-F].:([0-9A-F])*$' LIMIT 100;
12	Empty set (0.11 sec)
13
14	; Shouldn't affect us, but just in case.
15	mysql:research@s3-analytics-slave [mediawikiwiki]> SELECT tr_user_text, user_name FROM thread_reaction LEFT OUTER JOIN user ON tr_user_text = user_name WHERE user_name IS NULL AND tr_user_text NOT REGEXP '^[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}$' AND tr_user_text NOT REGEXP '^[0-9A-F].:([0-9A-F])*$' LIMIT 100;
16	Empty set (0.01 sec)