IntegrityError: duplicate key violates unique constraint "resource_custom_pkey"

[tom.steinmann@…]

Hallo, Gibt es auf diesem Portal noch Unterstützung, weil wir einen Fehler in unserem oForge/trac haben:

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'__EDITOR__1': u'textarea',
 '__FORM_TOKEN': u'b7f90c8851b7e673a2004c4d',
 'action': u'edit',
 'comment': u'',
 'editrows': u'20',
 'page': u'test',
 'page_type': u'wiki-page',
 'resource_parent': u'',
 'resource_related': u'',
 'save': u'Submit changes',
 'scroll_bar_pos': u'0',
 'tags': u'',
 'text': u'test new site',
 'version': u'0',
 'virtual_children_resources': u''}

User Agent was: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11

System Information

Trac	0.12dev-r7756
Python	2.5.4 (r254:67916, Aug 13 2009, 10:27:04) [GCC 4.3.2]
setuptools	0.6
psycopg2	2.0.11
Genshi	0.6dev-r960
Pygments	1.0
Subversion	1.6.4 (r38063)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/var/trac-oforge/lib/python2.5/site-packages/Trac-0.12dev_r7756-py2.5.egg/trac/web/main.py", line 457, in _dispatch_request
    dispatcher.dispatch(req)
  File "/var/trac-oforge/lib/python2.5/site-packages/Trac-0.12dev_r7756-py2.5.egg/trac/web/main.py", line 214, in dispatch
    resp = chosen_handler.process_request(req)
  File "/var/trac-oforge/lib/python2.5/site-packages/Trac-0.12dev_r7756-py2.5.egg/trac/wiki/web_ui.py", line 141, in process_request
    valid = self._validate(req, versioned_page)
  File "/var/trac-oforge/lib/python2.5/site-packages/Trac-0.12dev_r7756-py2.5.egg/trac/wiki/web_ui.py", line 190, in _validate
    for field, message in manipulator.validate_wiki_page(req, page):
  File "build/bdist.linux-i686/egg/tracwikitools/customfields/web_ui.py", line 37, in validate_wiki_page
    self._set_custom_fields(req, page)
  File "build/bdist.linux-i686/egg/tracwikitools/customfields/web_ui.py", line 81, in _set_custom_fields
    prop_model.set(prop_value_new, db=db)
  File "build/bdist.linux-i686/egg/tracresourcetools/property/model.py", line 322, in set
    return super(ListResourcePropertyModel, self).set(value, db, pretend)
  File "build/bdist.linux-i686/egg/tracresourcetools/property/model.py", line 88, in set
    self.update(db)
  File "build/bdist.linux-i686/egg/tracresourcetools/property/model.py", line 58, in update
    self.insert(self.name, self.value, db)
  File "build/bdist.linux-i686/egg/tracresourcetools/property/model.py", line 332, in insert
    for idx, value_item in enumerate(value)])
  File "/var/trac-oforge/lib/python2.5/site-packages/Trac-0.12dev_r7756-py2.5.egg/trac/db/util.py", line 57, in executemany
    return self.cursor.executemany(sql_escape_percent(sql), args)
  File "/var/trac-oforge/lib/python2.5/site-packages/Trac-0.12dev_r7756-py2.5.egg/trac/db/util.py", line 57, in executemany
    return self.cursor.executemany(sql_escape_percent(sql), args)
IntegrityError: duplicate key violates unique constraint "resource_custom_pkey"

[osimons]

You are:

• Running a very old Trac 0.12dev (r7756) - a ~3 years old pre-release version.
• Something called tracwikitools is involved in this request. I have no idea what that is.
• Something called tracresourcetools also does some magic in this request, and I don't know what that is either.
• There is no resource_custom_pkey constraint in default Trac database schema.

You obviously have an issue, but it is likely a problem that originates from code belong to others. wiki:OForge perhaps?

[tom.steinmann@…]

Great, thank you for your Help. I will try investigate your hints and also update to a newer Trac version. cheers, Tom