IntegrityError: columns sid, authenticated, name are not unique

[taco_chang]

How to Reproduce

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

(please provide additional details here)

Request parameters:

{'id': u'7'}

User agent: #USER_AGENT#

System Information

Trac	0.12.2
Agilo	1.3.4-PRO
Babel	0.9.5
Genshi	0.6
mod_python	3.3.1
Pygments	1.4
pysqlite	2.4.1
Python	2.6.5 (r265:79063, Apr 16 2010, 14:15:55) [GCC 4.4.3]
pytz	2010o
setuptools	0.6
SQLite	3.6.22
jQuery	#JQUERY#

Enabled Plugins

binary-agilo	1.3.4-PRO
TracForms	0.4.1-r10490
TracIncludeMacro	2.2dev-r11266

Python Traceback

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/main.py", line 511, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/main.py", line 260, in dispatch
    req.session.save()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/session.py", line 105, in save
    @self.env.with_transaction()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/api.py", line 77, in transaction_wrapper
    fn(ldb)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/web/session.py", line 146, in save_session
    """, [(self.sid, authenticated, k, v) for k, v in items])
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/util.py", line 85, in executemany
    return self.cursor.executemany(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py", line 62, in executemany
    args)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.2-py2.6.egg/trac/db/sqlite_backend.py", line 48, in _rollback_on_error
    return function(self, *args, **kwargs)
IntegrityError: columns sid, authenticated, name are not unique

[Christian Boos]

0.12.2… I thought we were done with that one (#3563). As apparently not, let's keep this one open.

To the reporter: how frequent is the issue for you?

[Ryan J Ollos]

Moved ticket assigned to next-stable-1.0.x since maintenance of 1.0.x is coming to a close. Please move the ticket back if it's critical to fix on 1.0.x.

[Ryan J Ollos]

Milestone renamed