Consider doing something about the "create/create" log entries on Wikidata and Commons
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	A_smart_kitten
	Nov 26 2024, 3:17 PM

Description

As a result of the regression described in T379534: Page creation log inserted even if $wgPageCreationLog is false, Wikidata and Wikimedia Commons (as wikis that have wgPageCreationLog set to false) currently have a lot of log actions for '[username] performed unknown action "create/create"' (example on Wikidata, example on Commons). (There are also a few on testcommonswiki, but given that wiki's closed, they might not be worth dealing with)

I've opened this task in case it's worth considering removing them from the database or doing something about them in another way, given these actions shouldn't have been logged at all (and currently display in an unclear way) - however, if this shouldn't be done, feel free to close.

Related Objects

Mentioned Here: T379534: Page creation log inserted even if $wgPageCreationLog is false

Event Timeline

A_smart_kitten created this task.Nov 26 2024, 3:17 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 26 2024, 3:17 PM

FTR, there’s ~310k of those rows on Wikidata and ~471k on Commons, all from this year (i.e. presumably all from T379534 and not some other older cause):

mysql:research@dbstore1009.eqiad.wmnet [wikidatawiki]> SELECT SUBSTR(log_timestamp, 1, 4), COUNT(*) FROM logging WHERE log_type = 'create' AND log_action = 'create' GROUP BY SUBSTR(log_timestamp, 1, 4);
+-----------------------------+----------+
| SUBSTR(log_timestamp, 1, 4) | COUNT(*) |
+-----------------------------+----------+
| 2024                        |   309517 |
+-----------------------------+----------+
1 row in set (0.155 sec)

mysql:research@dbstore1007.eqiad.wmnet [commonswiki]> SELECT SUBSTR(log_timestamp, 1, 4), COUNT(*) FROM logging WHERE log_type = 'create' AND log_action = 'create' GROUP BY SUBSTR(log_timestamp, 1, 4);
+-----------------------------+----------+
| SUBSTR(log_timestamp, 1, 4) | COUNT(*) |
+-----------------------------+----------+
| 2024                        |   470520 |
+-----------------------------+----------+
1 row in set (0.482 sec)

This constitutes about 2% of the rows in wikidatawiki’s logging table but 0.28% of commonswiki’s. (I guess Commons’ table is larger because file uploads, unlike page creations, do get logged.)

I can delete them.

I have deleted them.

Consider doing something about the "create/create" log entries on Wikidata and CommonsClosed, ResolvedPublicActions

Description

Related Objects

Event Timeline

Consider doing something about the "create/create" log entries on Wikidata and Commons
Closed, ResolvedPublic
Actions