User merege and delete is installed on wikivoyage. This is almost certainly incompatible with SUL and should probably be disabled.
Version: unspecified
Severity: major
Bawolff | |
Jun 12 2013, 5:55 PM |
F11043: localnames-enwikivoyage | |
Nov 22 2014, 1:43 AM |
User merege and delete is installed on wikivoyage. This is almost certainly incompatible with SUL and should probably be disabled.
Version: unspecified
Severity: major
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | Legoktm | T68535 Clean up centralauth db inconsistencies due to UserMerge extension | |||
Resolved | Legoktm | T51489 User merge and delete doesn't play nicely with CentralAuth |
For reference, I disagree that this is a "shellpolicy" issue. Its more of a "may cause db inconsistency/totally break things" issue
If this is not a shellpolicy issue then the other option is to make the extension compatible with CentralAuth. You can't just have it disabled.
To clarify something. I only suspect that it might not play nicely, I don't have evidence. If I'm wrong, please ignore this bug.
If the codebase of CentralAuth can be fixed, then this is the right product/component in Bugzilla. If this ends up as UserMerge being removed from Wikivoyage, this should probably go to "Wikimedia > Site requests" instead.
Still needs further investigation if both work well together though, might influence fixing bug 39817?
'wmgUseUserMerge' => array(
'default' => false,
'wikivoyage' => true,
'eswikivoyage' => false,
'hewikivoyage' => false,
'plwikivoyage' => false,
'ptwikivoyaye' => false,
'rowikivoyage' => false,
'ukwikivoyage' => false,
),
This is bad...
Random example:
01:53, 18 November 2013 Wrh2 (talk | contribs) Deleted user: (WT-en) Koavf (2598)
01:53, 18 November 2013 Wrh2 (talk | contribs) User (WT-en) Koavf (2598) merged to Koavf (36077)
MariaDB [centralauth_p]> select * from localuser where lu_name="(WT-en) Koavf";
+--------------+---------------+-----------------------+--------------------+
lu_wiki | lu_name | lu_attached_timestamp | lu_attached_method |
+--------------+---------------+-----------------------+--------------------+
enwikivoyage | (WT-en) Koavf | 20130412190305 | primary |
+--------------+---------------+-----------------------+--------------------+
1 row in set (0.00 sec)
MariaDB [centralauth_p]> select gu_id, gu_name from globaluser where gu_name="(WT-en) Koavf";
+----------+---------------+
gu_id | gu_name |
+----------+---------------+
17526985 | (WT-en) Koavf |
+----------+---------------+
1 row in set (0.00 sec)
MariaDB [enwikivoyage_p]> select lu_name from centralauth_f_p.localuser AS localuser LEFT JOIN enwikivoyage_p.user AS user ON lu_name=user_name WHERE lu_wiki="enwikivoyage" AND user_name IS NULL;
+-------------------------+
lu_name |
+-------------------------+
(WT-en) Cayla |
(WT-en) DBaron |
(WT-en) Dguillaime |
(WT-en) DixonD |
(WT-en) Dominik Mayer |
(WT-en) ElectAbuzzzz |
(WT-en) F00bar |
(WT-en) Flip666 |
(WT-en) Handrian |
(WT-en) Intheback |
(WT-en) JRHorse |
(WT-en) JimDeLaHunt |
(WT-en) Koavf |
(WT-en) Mlinksva |
(WT-en) Neilworms |
(WT-en) Pashley |
(WT-en) Pbsouthwood |
(WT-en) PerryPlanet |
(WT-en) Piotrus |
(WT-en) Pjamescowie |
(WT-en) Pnaha |
(WT-en) Pprtw |
(WT-en) Rastapopulous |
(WT-en) RickScott |
(WT-en) Squeed |
(WT-en) Superdog |
(WT-en) Swissbelg |
(WT-en) Tsuliwaensis |
(WT-en) Unforgettableid |
(WT-en) Unger |
(WT-en) Velorian |
(WT-en) Waldir |
ElectAbuzzzz |
Insulam Simia |
+-------------------------+
34 rows in set (3.23 sec)
https://en.wikivoyage.org/w/index.php?title=Special:Log/usermerge&offset=&limit=500&type=usermerge&user= shows more accounts merged than that...
I ran queries across all the other wikivoyage databases with UserMerge enabled, and only dewikivoyage had ghost accounts...
MariaDB [dewikivoyage_p]> select lu_name from centralauth_f_p.localuser AS localuser LEFT JOIN user ON lu_name=user_name WHERE lu_wiki="dewikivoyage" AND user_name IS NULL;
+------------------------+
lu_name |
+------------------------+
(WT-de) SabineCretella |
(WV-de) Flöschen |
(WV-de) Menz |
(WV-de) Mojo Dodo |
(WV-de) UngerNormal |
Edu.1183 |
Herby1000 |
Hucketyne |
TravelBalz |
+------------------------+
9 rows in set (0.13 sec)
(In reply to Kunal Mehta (Legoktm) from comment #6)
<https://en.wikivoyage.org/w/index.php?title=Special:Log/
usermerge&offset=&limit=500&type=usermerge&user=> shows more accounts merged
than that...
I'm going to assume that these accounts were never global to begin with.
Created attachment 15639
Query results of localnames table vs enwikivoyage user table
101 entries in localnames that don't exist on enwikivoyage anymore, see attachment.
Attached:
Change 139331 had a related patch set uploaded by Legoktm:
Add hook handler for UserMerge's DeleteAccount
CentralAuth+UserMerge should work better now. Bug 66535 tracks the cleaning up of Wikimedia's centralauth database.