Edgewall Software
Modify

Opened 15 years ago

Closed 15 years ago

#8011 closed defect (duplicate)

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

Reported by: diego Owned by:
Priority: normal Milestone:
Component: general Version:
Severity: normal Keywords: postgresql
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

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"


Attachments (0)

Change History (2)

comment:1 by Christian Boos, 15 years ago

Keywords: postgresql added
Milestone: 0.11.6

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

comment:2 by Christian Boos, 15 years ago

Milestone: 0.11.6
Resolution: duplicate
Status: newclosed

Actually a duplicate of #3948.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.