Page MenuHomePhabricator

Special:CheckUserLog almost empty on testwiki
Closed, ResolvedPublic

Description

cu_log_testwiki.png (1×1 px, 167 KB)

(this image contains no private info, so it's fine to be public)

This was discovered while testing r879653, but it is reproducible with or without that patch. The cu_log table contains a lot of more rows:

wikiadmin@10.64.48.35(testwiki)> select count(*) from cu_log;
+----------+
| count(*) |
+----------+
|     1274 |
+----------+
1 row in set (0.002 sec)

The only difference between the displayed entry and the other entries is that for @Zabe's log, cul_reason_id and cul_reason_plaintext_id is populated.

This is reproducible at mediawiki.org as well (wmf.19 as of writing).

Event Timeline

Urbanecm triaged this task as Unbreak Now! priority.Jan 17 2023, 9:46 PM
Urbanecm updated the task description. (Show Details)
Urbanecm subscribed.

This is a wmf.19 train blocker, as it prevents auditing what the CheckUsers do.

I've not yet been able to find the issue for this on my local testing wiki. I'm going to try on checkuser-beta-wiki.wmcloud.org.

Change 880924 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@master] Revert "Add read new support for cu_log comment ID columns"

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

Change 880925 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[mediawiki/extensions/CheckUser@wmf/1.40.0-wmf.19] Revert "Add read new support for cu_log comment ID columns"

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

Change 880924 merged by Dreamy Jazz:

[mediawiki/extensions/CheckUser@master] Revert "Add read new support for cu_log comment ID columns"

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

Change 880925 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@wmf/1.40.0-wmf.19] Revert "Add read new support for cu_log comment ID columns"

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

Mentioned in SAL (#wikimedia-operations) [2023-01-17T23:07:31Z] <zabe@deploy1002> Started scap: Backport for [[gerrit:881026|Revert "Revert "Start writing to cul_reason[_plaintext]_id on group0 and group1 wikis"" (T233004)]], [[gerrit:880925|Revert "Add read new support for cu_log comment ID columns" (T327219)]]

Mentioned in SAL (#wikimedia-operations) [2023-01-17T23:09:14Z] <zabe@deploy1002> zabe and dreamyjazz and zabe: Backport for [[gerrit:881026|Revert "Revert "Start writing to cul_reason[_plaintext]_id on group0 and group1 wikis"" (T233004)]], [[gerrit:880925|Revert "Add read new support for cu_log comment ID columns" (T327219)]] synced to the testservers: mwdebug1001.eqiad.wmnet, mwdebug1002.eqiad.wmnet, mwdebug2002.codfw.wmnet, mwdebug2001.codfw.wmnet

Mentioned in SAL (#wikimedia-operations) [2023-01-17T23:19:17Z] <zabe@deploy1002> Finished scap: Backport for [[gerrit:881026|Revert "Revert "Start writing to cul_reason[_plaintext]_id on group0 and group1 wikis"" (T233004)]], [[gerrit:880925|Revert "Add read new support for cu_log comment ID columns" (T327219)]] (duration: 11m 46s)

Zabe assigned this task to Dreamy_Jazz.

Thanks for the help everyone to fix this.