Edgewall Software
Modify

Opened 7 years ago

Last modified 3 years ago

#10966 new defect

IntegrityError: columns sid, authenticated, name are not unique

Reported by: taco_chang Owned by:
Priority: low Milestone: next-stable-1.2.x
Component: general Version: 0.12.2
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:

Description

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

Attachments (0)

Change History (4)

comment:1 by Christian Boos, 7 years ago

Milestone: next-minor-0.12.x
Priority: normallow

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?

comment:2 by Ryan J Ollos, 5 years ago

Milestone: next-minor-0.12.xnext-stable-1.0.x

comment:3 by Ryan J Ollos, 5 years ago

Owner: Scott_Wang removed

comment:4 by Ryan J Ollos, 3 years ago

Milestone: next-stable-1.0.xnext-stable-1.2.x

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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The ticket will remain with no owner.
The ticket will be disowned. Next status will be 'new'.
as The resolution will be set. Next status will be 'closed'.
The owner will be changed from (none) to anonymous. Next status will be 'assigned'.

Add Comment


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