[Boost-bugs] [Boost C++ Libraries] #2795: IntegrityError: columns sid, authenticated are not unique

Subject: [Boost-bugs] [Boost C++ Libraries] #2795: IntegrityError: columns sid, authenticated are not unique
From: Boost C++ Libraries (noreply_at_[hidden])
Date: 2009-02-23 21:04:49

#2795: IntegrityError: columns sid, authenticated are not unique
---------------------------------------+------------------------------------
 Reporter:  mhcox_at_[hidden]  |       Owner:         
     Type:  Bugs                       |      Status:  new    
Milestone:  Boost 1.39.0               |   Component:  None   
  Version:  Boost 1.38.0               |    Severity:  Problem
 Keywords:                             |  
---------------------------------------+------------------------------------
 ==== How to Reproduce ====

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

 ''(please provide additional details here)''



 ==== System Information ====

 || '''Trac''' || `0.11` ||
 || '''Python''' || `2.4.4 (#1, Jan 25 2007, 13:04:51) ` [[br]] `[GCC 3.4.6
 20060404 (Red Hat 3.4.6-3)]` ||
 || '''setuptools''' || `0.6c8` ||
 || '''SQLite''' || `3.5.4` ||
 || '''pysqlite''' || `2.4.1` ||
 || '''Genshi''' || `0.5` ||
 || '''Subversion''' || `1.4.2 (r22196)` ||

 ==== Python Traceback ====
 {{{
 Traceback (most recent call last):
   File "/opt/trac2/lib/python2.4/site-
 packages/Trac-0.11-py2.4.egg/trac/web/main.py", line 423, in
 _dispatch_request
     dispatcher.dispatch(req)
   File "/opt/trac2/lib/python2.4/site-
 packages/Trac-0.11-py2.4.egg/trac/web/main.py", line 222, in dispatch
     req.session.save()
   File "/opt/trac2/lib/python2.4/site-
 packages/Trac-0.11-py2.4.egg/trac/web/session.py", line 84, in save
     (self.sid, self.last_visit, authenticated))
   File "/opt/trac2/lib/python2.4/site-
 packages/Trac-0.11-py2.4.egg/trac/db/util.py", line 50, in execute
     return self.cursor.execute(sql_escape_percent(sql), args)
   File "/opt/trac2/lib/python2.4/site-
 packages/Trac-0.11-py2.4.egg/trac/db/sqlite_backend.py", line 58, in
 execute
     args or [])
   File "/opt/trac2/lib/python2.4/site-
 packages/Trac-0.11-py2.4.egg/trac/db/sqlite_backend.py", line 50, in
 _rollback_on_error
     return function(self, *args, **kwargs)
 IntegrityError: columns sid, authenticated are not unique

 }}}

-- 
Ticket URL: <https://svn.boost.org/trac/boost/ticket/2795>
Boost C++ Libraries <http://www.boost.org/>
Boost provides free peer-reviewed portable C++ source libraries.