IntegrityError: columns ticket, time, field are not unique

[andrei.bogdan@…]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'69032bd2e9cca855a6032e72',
 'action': u'leave',
 'cnum': u'26',
 'comment': u'',
 'field_description': u'',
 'field_fixer': u'',
 'field_priority': u'normal',
 'field_reporter': u'andrei.bogdan@machteamsoft.ro',
 'field_sprint': u'',
 'field_summary': u'asdasdadasdadasdasd',
 'field_tester': u'andrei.bogdan@machteamsoft.ro',
 'field_type': u'bug',
 'id': u'2584',
 'pane': u'edit',
 'replyto': u'',
 'submit': u'Submit changes',
 'ts': u'2011-02-28 08:22:30+00:00'}

User Agent was: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.13) Gecko/20101206 Ubuntu/10.10 (maverick) Firefox/3.6.13

System Information

Trac	0.11
Python	2.5.5 (r255:77872, Dec 8 2010, 11:43:14) [GCC 4.4.3]
setuptools	0.6
SQLite	3.6.22
pysqlite	2.3.2
Genshi	0.6
Agilo	0.9.1
jQuery:	1.2.3

Python Traceback

Traceback (most recent call last):
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/web/main.py", line 197, in dispatch
    resp = chosen_handler.process_request(req)
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/ticket/web_ui.py", line 152, in process_request
    return self._process_ticket_request(req)
  File "/opt/trac/0.11/lib/python2.5/site-packages/agilo-0.9.1-py2.5.egg/agilo/ticket/web_ui.py", line 224, in _process_ticket_request
    template, data, content_type = super(AgiloTicketModule, self)._process_ticket_request(req)
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/ticket/web_ui.py", line 471, in _process_ticket_request
    self._do_save(req, ticket, action)
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/ticket/web_ui.py", line 966, in _do_save
    cnum=internal_cnum):
  File "/opt/trac/0.11/lib/python2.5/site-packages/agilo-0.9.1-py2.5.egg/agilo/ticket/model.py", line 744, in save_changes
    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum)
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/ticket/model.py", line 282, in save_changes
    listener.ticket_changed(self, comment, author, old_values)
  File "/var/www/agilo/plugins/MachTicketObserver.py", line 141, in ticket_changed
    ticket.save_changes(author, comment)
  File "/opt/trac/0.11/lib/python2.5/site-packages/agilo-0.9.1-py2.5.egg/agilo/ticket/model.py", line 744, in save_changes
    res = super(AgiloTicket, self).save_changes(author, comment, when, db, cnum)
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/ticket/model.py", line 270, in save_changes
    (self.id, when_ts, author, cnum, comment))
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
    args or [])
  File "/opt/trac/0.11/lib/python2.5/site-packages/Trac-0.11-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
    return function(self, *args, **kwargs)
IntegrityError: columns ticket, time, field are not unique

[Christian Boos]

1. You're using AgiloForScrum superset of Trac, you should report bugs to them when one of their plugins is involved in the traceback
2. You're using Trac 0.11, probably not a good idea at this point (upgrade at least to 0.11.7, or better 0.12.2)
3. So please no more tickets like this one and #10054…