IntegrityError: duplicate key value violates unique constraint "session_attribute_pk"

[tdn]

How to Reproduce

While doing a GET operation on /query, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{'group': u'status',
 'milestone': u'september-2009',
 'status': [u'assigned', u'new', u'reopened']}

System Information

Trac	0.11.1
Python	2.5.2 (r252:60911, Jan 4 2009, 21:59:32) [GCC 4.3.2]
setuptools	0.6c8
psycopg2	2.0.7
Genshi	0.5.1
Pygments	0.10
Subversion	1.5.1 (r32289)

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 423, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 222, in dispatch
    req.session.save()
  File "/usr/lib/python2.5/site-packages/trac/web/session.py", line 102, in save
    "VALUES(%s,%s,%s,%s)", attrs)
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 57, in executemany
    return self.cursor.executemany(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 57, in executemany
    return self.cursor.executemany(sql_escape_percent(sql), args)
IntegrityError: duplicate key value violates unique constraint "session_attribute_pk"

[Christian Boos]

Duplicate key… and duplicate ticket ;-)

See #7663, which is believed to be fixed in versions > 0.11.1 of Trac, so please upgrade.

[anonymous]

Please refer to #7663 again. It has been reopened because the defect has been reopened.