Page MenuHomePhabricator

Remove duplicate record from renameuser log
Closed, DeclinedPublicBUG REPORT

Description

Go to https://ru.wikipedia.org/w/api.php?action=query&format=xml&list=logevents&leprop=details|timestamp|title&leaction=renameuser%2Frenameuser&lestart=2010-12-07T00%3A00%3A00.000Z&leend=2010-12-08T00%3A00%3A00.000Z&ledir=newer

Or execute this on ruwiki_p (see https://quarry.wmcloud.org/query/17520):

select * from logging where log_action="renameuser" and log_timestamp>20101207110000 and log_timestamp<20101207120000;

You'll see two identical records about renaming user "Ruang_rak_noi_nid_mahasan" to "Даматрий", with identical timestamp (so timestamp can't be used as primary key).

This is the only duplicate record in ruwiki's renameuser log and it bothers my bot. Could you delete one of duplicate records?

Event Timeline

Looks like a duplicate submit of the rename form, because it is in the same second. Nothing to be worry about. Log items usally not modified, this can also happens for other actions. Would suggest to decline the task, just ignore the row in the report.

On wiki log, where the log id is linked, which can be used as primary key: https://ru.wikipedia.org/wiki/%D0%A1%D0%BB%D1%83%D0%B6%D0%B5%D0%B1%D0%BD%D0%B0%D1%8F:%D0%96%D1%83%D1%80%D0%BD%D0%B0%D0%BB%D1%8B?type=renameuser&page=%D0%A3%D1%87%D0%B0%D1%81%D1%82%D0%BD%D0%B8%D0%BA%3ARuang+rak+noi+nid+mahasan&uselang=en

Marostegui subscribed.

I am going to decline the task for now per @Umherirrender's comment. Also, if we need to delete something, I'd prefer if it is done via a maintenance script using MW - we tend to avoid deleting records on the database's prompt unless it is super critical/an emergency etc.