Page MenuHomePhabricator

hat-web-tool/projects: listing incorrect number of users on some projects (not listening to ug_expiry)
Open, Needs TriagePublic

Description

I guess something's wrong with the SQL queries because, for example, it lists astwiki with 1 user in the 'checkuser' group, which at this moment ain't true (the same for several others).

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 24 2017, 2:54 PM

Is:

$db_server = mysql_connect("metawiki.labsdb", $loginData['user'], $loginData['password']);

metawiki.labsdb still a valid DB name?

@Steinsplitter Is this related to T156545 somehow?

No, But on the old replicas a few tables seems to be gone.

@bd808 Something that can be fixed with what was announced at Blog Post: New Wiki Replica servers ready for use?

Change 380748 had a related patch set uploaded (by MarcoAurelio; owner: MarcoAurelio):
[labs/tools/stewardbots@master] Update MySQL DB connection to use analytics.db.svc.eqiad.wmflabs

https://gerrit.wikimedia.org/r/380748

Change 380748 merged by jenkins-bot:
[labs/tools/stewardbots@master] Update MySQL DB connection to use analytics.db.svc.eqiad.wmflabs

https://gerrit.wikimedia.org/r/380748

https://github.com/wikimedia/labs-tools-stewardbots/commit/261fda1c58556c21e479ca6dab1a7a4abdc09672 didn't break the tool (that's a step forward), but it's still displaying incorrect data. For example, search for projects with 1 CheckUser and you'll see that in most of them, that's not true. Either the MySQL query is broken or badly formatted, so it give us wrong results.

MarcoAurelio closed this task as Resolved.Sep 26 2017, 2:31 PM
MarcoAurelio claimed this task.

I've updated the hosts to the new ones, and after consulting with a DBA, found a problem with temporary userrights, so I'll report that in a separate bug.

Restricted Application added a project: User-MarcoAurelio. · View Herald TranscriptSep 26 2017, 2:31 PM
MarcoAurelio reopened this task as Open.Sep 26 2017, 3:18 PM

https://phabricator.wikimedia.org/diffusion/TSTW/browse/master/hat-web-tool/projects.php does not take into count ug_expiry from user_groups, so it's potentially listing a lot of outdated data.

MarcoAurelio renamed this task from hat-web-tool/projects: listing incorrect number of users on some projects to hat-web-tool/projects: listing incorrect number of users on some projects (not listening to ug_expiry).
MarcoAurelio removed MarcoAurelio as the assignee of this task.