Page MenuHomePhabricator

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

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.

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
Addshore added a subscriber: Addshore.EditedNov 19 2018, 9:39 AM

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