Page MenuHomePhabricator
Create Task
Maniphest T165169

Some querries cannot be 'unstarred'
Closed, ResolvedPublic
Actions

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.

Details

ProjectBranchLines +/-Subject
analytics/quarry/webmaster+9 -1Handle duplicates in table 'star'
Customize query in gerrit

Event Timeline

XXN created this task.May 12 2017, 4:13 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 12 2017, 4:13 PM
• Phabricator_maintenance removed a subscriber: yuvipanda.Jun 7 2017, 6:37 PM
zhuyifei1999 moved this task from Backlog to Bugs on the Quarry board.Jul 31 2017, 12:29 AM
zhuyifei1999 added a subscriber: zhuyifei1999.Jul 31 2017, 1:24 AM

Issues:

gerritbot added a subscriber: gerritbot.Jul 31 2017, 1:50 AM

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

gerritbot added a project: Patch-For-Review.Jul 31 2017, 1:50 AM
Stashbot added a subscriber: Stashbot.Dec 10 2017, 5:49 AM

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

gerritbot added a comment.Dec 10 2017, 5:50 AM

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

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

Stashbot added a comment.Dec 10 2017, 5:52 AM

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

zhuyifei1999 closed this task as Resolved.Dec 10 2017, 5:53 AM
zhuyifei1999 claimed this task.

Should be fixed. Please reopen if you encounter issues.

Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL