I created a Jeely script to add comments to existing bugs in jira. When I run the script it adds all comments as expected. But after running once, it starts all over again from the beginning and adds all comments again. It does not seem to stop after the second run so I killed the jira server to stop it.

What is wrong here? And how can I now get rid of the duplicated comments? Could you pls provide me with a mysql delete statement which deletes all comments, which have the same timestamp/content???

Here is a part of my script (all in all it tried to add ~500 comments):

<?xml version="1.0" encoding="UTF-8"?>
<JiraJelly xmlns:jira="jelly:com.atlassian.jira.jelly.JiraTagLib">
<jira:AddComment issue-key="CONJ-1900" comment="chris.peters@conject.com wrote: When a group permission is changed in the permissions list corresponding permissions for individual participants on the list are not updated. That is is a praticpant is member of a group and is also on the list as an individual participant, removing a permission from the group affects the way the particpants permission is shown in his own row." created="2003-08-28 11:12:55"/>
<jira:AddComment issue-key="CONJ-1900" comment="agalicki@mareon.com.pl wrote: implicit and implied permissions are updated AFTER save, not before." created="2003-09-08 11:26:38"/>
<jira:AddComment issue-key="CONJ-1900" comment="czwarycz@mareon.com.pl wrote: it should be updated after apply only" created="2003-09-11 11:26:48"/>
<jira:AddComment issue-key="CONJ-1900" comment="chris.peters@conject.com wrote: In general it should only be SAVED after clicking Apply or Cancel. That has nothing to do with showing the result of the not yet saved changes in the interface. If I change the content of a textfield the changes are also shown without saving first." created="2003-09-23 16:58:52"/>
<jira:AddComment issue-key="CONJ-1900" comment="tk@conject.com wrote: I reopened this bug, as we struggle from time to time because of not having the described way of displaying permissions any more. We should reinvent it, as it is really difficult at the moment to differenciate between group permissions and individual permissions. In old GUI, the direct permissions for a user were displayed differently from the permissions given through a group. Is it a technical problem to have that again in new GUI? Why was it not implemented for now GUI?" created="2004-12-19 18:58:22"/>
<jira:AddComment issue-key="CONJ-1901" comment="tk@conject.com wrote: When creating a project, the start date and end date have to be entered. There are calendar icons next to the entry fields, but clicking the icon, no calendar is opened!" created="2003-09-08 12:13:43"/>
<jira:AddComment issue-key="CONJ-1901" comment="rzaczynski@mareon.com.pl wrote: this means some new functionality we don't have - internationalization issues have to be taken under consideration" created="2003-09-08 12:17:42"/>
<jira:AddComment issue-key="CONJ-1901" comment="mm@conject.com wrote: ok, let's introduce that later. But than, we've to remove the links behind the icons." created="2003-09-08 12:34:16"/>
<jira:AddComment issue-key="CONJ-1901" comment="rzaczynski@mareon.com.pl wrote: calendar links removed" created="2003-09-09 09:29:23"/>
...
</JiraJelly>