Maniphest T209793

'rc_comment' column no longer populated in Wikidata's recentchanges table
Closed, InvalidPublic
Actions

Assigned To

None

Authored By

	Mahir256
	Nov 18 2018, 7:23 PM

Description

Since, I presume, the patch(es) in T207313 have been deployed, the column in Wikidata's recentchanges SQL table holding edit summaries has no longer been populated, which is problematic for those who wish to rely on such summaries.

My presumption of when the problem began comes from the results of https://quarry.wmflabs.org/query/25116, a list of changes to stuff on Wikidata in Bengali, which ideally shouldn't have stopped abruptly on October 23rd (around the time the aforementioned patches were deployed), and https://quarry.wmflabs.org/query/31314, a list intended to be of specifically Bengali label additions, which presently reports nothing in the rc_comment column.

Other possibly related tasks include T209459 and T202764.

Related Objects

Mentioned Here: T166733: Deploy refactored comment storage
T202764: Wikidata produces a lot of failed requests for recentchanges API
T207313: Some administrative and log actions on Wikidata take longer than 60 seconds and time out
T209459: Wikidata recentchanges API request with ORESscores parameter returns 0 results

Event Timeline

Mahir256 created this task.Nov 18 2018, 7:23 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 18 2018, 7:23 PM

I believe this will actually be related to T166733

In the recentchanges table you now have a new column

| rc_comment_id | bigint(20) unsigned | NO   |     | 0       |                |

This can be used in conjunction with the comment table.

MariaDB [wikidatawiki]> describe comment
    -> ;
+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| comment_id   | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| comment_hash | int(11)             | NO   | MUL | NULL    |                |
| comment_text | blob                | NO   |     | NULL    |                |
| comment_data | blob                | YES  |     | NULL    |                |
+--------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

Here is an example of one of your queries modified for the new schema: https://quarry.wmflabs.org/query/31322

Addshore closed this task as Invalid.Nov 19 2018, 9:39 AM

'rc_comment' column no longer populated in Wikidata's recentchanges tableClosed, InvalidPublicActions

Description

Related Objects

Event Timeline

'rc_comment' column no longer populated in Wikidata's recentchanges table
Closed, InvalidPublic
Actions