Page MenuHomePhabricator

Some querries cannot be 'unstarred'
Closed, ResolvedPublicBUG REPORT

Description

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 https://quarry.wmflabs.org/query/11613 and https://quarry.wmflabs.org/query/11685 .

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'

https://gerrit.wikimedia.org/r/368604

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'

https://gerrit.wikimedia.org/r/368604

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.

Aklapper changed the subtype of this task from "Task" to "Bug Report".Jul 18 2023, 12:20 PM