IntegrityError: columns ticket, name are not unique

[tim.lai@…]

How to Reproduce

While doing a POST operation on /newticket, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'dd1dc1a787ed9a8d50ce8393',
 'field_description': u'asdfasdfa',
 'field_owner': u'',
 'field_priority': u'major',
 'field_reporter': u'tim.lai',
 'field_sprint': u'',
 'field_summary': u'asdfadsf',
 'field_type': u'bug',
 'submit': u'Create ticket'}

User agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101026 Firefox/3.6.12

System Information

Trac	0.12.1
Agilo	1.3.1-pro
Genshi	0.6
mod_wsgi	3.3 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})
pysqlite	2.4.1
Python	2.6.6 (r266:84292, Aug 24 2010, 16:01:11) [MSC v.1500 32 bit (Intel)]
setuptools	0.6c11
SQLite	3.5.9
jQuery	1.4.2

Enabled Plugins

binary-agilo	1.3.1-pro
tracaccountmanager	0.3dev-r9549

Python Traceback

Traceback (most recent call last):
  File "build\bdist.win32\egg\trac\web\main.py", line 511, in _dispatch_request
    dispatcher.dispatch(req)
  File "build\bdist.win32\egg\trac\web\main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "build\bdist.win32\egg\trac\ticket\web_ui.py", line 170, in process_request
    return self._process_newticket_request(req)
  File "C:\Python26\lib\site-packages\binary_agilo-1.3.1_pro-py2.6.egg\agilo\ticket\web_ui.py", line 458, in _process_newticket_request
    super(AgiloTicketModule, self)._process_newticket_request(req)
  File "build\bdist.win32\egg\trac\ticket\web_ui.py", line 398, in _process_newticket_request
    self._do_create(req, ticket) # (redirected if successful)
  File "C:\Python26\lib\site-packages\binary_agilo-1.3.1_pro-py2.6.egg\agilo\ticket\web_ui.py", line 354, in _do_create
    ticket.insert()
  File "C:\Python26\lib\site-packages\binary_agilo-1.3.1_pro-py2.6.egg\agilo\ticket\model.py", line 759, in insert
    t_id = super(AgiloTicket, self).insert(when=when, db=db)
  File "build\bdist.win32\egg\trac\ticket\model.py", line 226, in insert
    @self.env.with_transaction(db)
  File "build\bdist.win32\egg\trac\db\api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "build\bdist.win32\egg\trac\ticket\model.py", line 239, in do_insert
    """, [(tkt_id[0], name, self[name]) for name in custom_fields])
  File "build\bdist.win32\egg\trac\db\util.py", line 85, in executemany
    return self.cursor.executemany(sql_escape_percent(sql), args)
  File "build\bdist.win32\egg\trac\db\sqlite_backend.py", line 62, in executemany
    args)
  File "build\bdist.win32\egg\trac\db\sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
IntegrityError: columns ticket, name are not unique

[Remy Blank]

PluginIssue (AgiloForScrum).

[anonymous]

@rblank: Thanks for cc'ing us on this bug.

@reporter: Can you please provide the [ticket-custom] section of your trac.ini file? Let's continue this discussion on the Agilo Google Group, see the wiki page referenced above.

[tim.lai@…]

[ticket-custom] businessvalue = select businessvalue.label = Business Value businessvalue.options = |100|200|300|500|800|1200|2000|3000 businessvalue.value = drp_resources = text drp_resources.label = Resources i_links = text i_links.label = Referenced By o_links = text o_links.label = References rd_points = select rd_points.label = Story Points rd_points.options = |0|1|2|3|5|8|13|20|40|100 remaining_time = text remaining_time.label = Remaining Time sprint = select sprint.label = Sprint sprint.value = story_priority = select story_priority.label = Importance story_priority.options = |Mandatory|Linear|Exciter story_priority.value =

[Martin Häcker <martin.haecker@…>]

@tim: Please lets take this discussion to our support google group, as it's quite rude to spam this bug tracker with discussion about bugs in our (different) project. Even though we are a plugin.

Thanks!

[Martin Häcker <martin.haecker@…>]

For details on how to find the group, please see AgiloForScrum