Page MenuHomePhabricator

Some querries cannot be 'unstarred'
Closed, ResolvedPublic


Originally reported on :mw:Talk:Quarry.

Bulgu said:

I was trying to organize the favorite queries by their url (newer queries have bigger numbers in the url). I noticed that when I unstar and then star several queries, they do not effectively get unstarred; multiple copies start to exist. Please check and .

Check his Quarry profile and you will see the query:11685 appearing around 6 times in the list of starred querries.

Event Timeline

Change 368604 had a related patch set uploaded (by Zhuyifei1999; owner: Zhuyifei1999):
[analytics/quarry/web@master] Handle duplicates in table 'star'

Mentioned in SAL (#wikimedia-cloud) [2017-12-10T05:49:30Z] <zhuyifei1999_> quarry-main-01: ALTER IGNORE TABLE star ADD UNIQUE INDEX star_user_query_index (user_id, query_id); Records: 728 Duplicates: 17 Warnings: 0 T165169

Change 368604 merged by jenkins-bot:
[analytics/quarry/web@master] Handle duplicates in table 'star'

Mentioned in SAL (#wikimedia-cloud) [2017-12-10T05:52:43Z] <zhuyifei1999_> deployed e835a46 to quarry-main-01 and restarted uwsgi T165169

zhuyifei1999 claimed this task.

Should be fixed. Please reopen if you encounter issues.