OperationalError: ERROR: duplicate key violates unique constraint "report_pkey"

[diego]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__FORM_TOKEN': u'46ae3eba5b43eea9ba36fd8d',
 'action': u'new',
 'description': u'\r\n * List all active tickets by priority.\r\n * Color each row based on priority.\r\n',
 'id': u'1',
 'query': u"\r\nSELECT p.value AS __color__,\r\n   id AS ticket, summary, component, version, milestone, t.type AS type, \r\n   owner, status,\r\n   time AS created,\r\n   changetime AS _changetime, description AS _description,\r\n   reporter AS _reporter\r\n  FROM ticket t, enum p\r\n  WHERE status <> 'closed' \r\nAND p.name = t.priority AND p.type = 'priority'\r\n  ORDER BY p.value, milestone, t.type, time\r\n",
 'title': u'Active (ID)'}

User Agent was: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/1.0.154.43 Safari/525.19

System Information

Trac	0.11stable-r7696
Python	2.4.4 (#2, Jan 13 2007, 17:50:26) [GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)]
setuptools	0.6c5
pyPgSQL	2.5.1
Genshi	0.5.1
Subversion	1.4.2 (r22196)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11stable_r7696-py2.4.egg/trac/web/main.py", line 432, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11stable_r7696-py2.4.egg/trac/web/main.py", line 204, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11stable_r7696-py2.4.egg/trac/ticket/report.py", line 93, in process_request
    self._do_create(req, db)
  File "/usr/lib/python2.4/site-packages/Trac-0.11stable_r7696-py2.4.egg/trac/ticket/report.py", line 141, in _do_create
    "VALUES (%s,%s,%s)", (title, query, description))
  File "/usr/lib/python2.4/site-packages/Trac-0.11stable_r7696-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11stable_r7696-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3111, in execute
    raise OperationalError, msg
OperationalError: ERROR:  duplicate key violates unique constraint "report_pkey"

[Christian Boos]

Well, don't use PgSQL… We should probably state that only psycopg2 is supported.

[Christian Boos]

Actually a duplicate of #3948.