Possible bug: Tags in a workflow gets duplicated hundreds of times
Hi, I have run into an issue with a tag being duplicated hundreds of times each time I open, edit or clone a workflow. I have tried to manually remove them, but each time the tag gets inserted somehow and duplicated each time I edit the workflow. By now there are hundreds of copies of the tags at it makes loading and running the workflow very slow. Is there a way to remove a tag from the system somehow? I am willing to dig into the database with some SQL statement but not sure where to start... Thanks Thon
Hi Thon, Thanks for reporting this. I see what the problem is here at least for the clone duplication, and I've committed a fix in 6833:e8e361707865 that will affect all workflows going forward. Unfortunately, there isn't a complete solution for fixing the extra tags. The problem was that any time you cloned a workflow, the mapping that retrieved the set of tags that should have been copied was actually returning *all* of the user's tags. That means that even if the source workflow had no tags, all workflow tags owned by the user would get copied to the newly created workflow. Because of this, just removing duplicate tags (while an obvious step in the right direction) won't be enough and you'll still have tags where they shouldn't be. I'll add the duplicate removal code as a migration, but in the short term if there are a few individual workflows that you need to fix (by simply removing all tags) the easiest thing to do on your end would be to manually remove the stored_workflow_tag_associations for those particular workflows, using something like this sql statement: delete from stored_workflow_tag_associations where stored_workflow_id = '<enter stored_workflow id to fix>' -Dannon On Mar 19, 2012, at 1:47 PM, Anthonius deBoer wrote:
Hi,
I have run into an issue with a tag being duplicated hundreds of times each time I open, edit or clone a workflow. I have tried to manually remove them, but each time the tag gets inserted somehow and duplicated each time I edit the workflow. By now there are hundreds of copies of the tags at it makes loading and running the workflow very slow.
Is there a way to remove a tag from the system somehow? I am willing to dig into the database with some SQL statement but not sure where to start...
Thanks Thon ___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at:
Thanks for addressing this...The workflows load MUCH faster now... Thon On Mar 20, 2012, at 07:54 AM, Dannon Baker <dannonbaker@me.com> wrote:
Hi Thon,
Thanks for reporting this. I see what the problem is here at least for the clone duplication, and I've committed a fix in 6833:e8e361707865 that will affect all workflows going forward.
Unfortunately, there isn't a complete solution for fixing the extra tags. The problem was that any time you cloned a workflow, the mapping that retrieved the set of tags that should have been copied was actually returning *all* of the user's tags. That means that even if the source workflow had no tags, all workflow tags owned by the user would get copied to the newly created workflow. Because of this, just removing duplicate tags (while an obvious step in the right direction) won't be enough and you'll still have tags where they shouldn't be. I'll add the duplicate removal code as a migration, but in the short term if there are a few individual workflows that you need to fix (by simply removing all tags) the easiest thing to do on your end would be to manually remove the stored_workflow_tag_associations for those particular workflows, using something like this sql statement:
delete from stored_workflow_tag_associations where stored_workflow_id = '<enter stored_workflow id to fix>'
-Dannon
On Mar 19, 2012, at 1:47 PM, Anthonius deBoer wrote:
Hi,
I have run into an issue with a tag being duplicated hundreds of times each time I open, edit or clone a workflow. I have tried to manually remove them, but each time the tag gets inserted somehow and duplicated each time I edit the workflow. By now there are hundreds of copies of the tags at it makes loading and running the workflow very slow.
Is there a way to remove a tag from the system somehow? I am willing to dig into the database with some SQL statement but not sure where to start...
Thanks Thon ___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at:
participants (3)
-
Anthonius deBoer -
Dannon Baker -
thondeboer＠me.com