columns sid, var_name are not unique during login

[pfnguyen@…]

I get the above Oops error message when switching back and forth between logged in and logged out areas of my site. This is running under mod_python 3.1.4 + apache 2.0.54.

traceback:

Traceback (most recent call last):
  File "/usr/local/trac/lib/python2.4/site-packages/trac/ModPythonHandler.py", line 195, in handler
    core.dispatch_request(mpr.path_info, args, mpr, env)
  File "/usr/local/trac/lib/python2.4/site-packages/trac/core.py", line 433, in dispatch_request
    req.session = Session.Session(env, req, newsession)
  File "/usr/local/trac/lib/python2.4/site-packages/trac/Session.py", line 51, in __init__
    self.get_session(sid)
  File "/usr/local/trac/lib/python2.4/site-packages/trac/Session.py", line 114, in get_session
    self.update_sess_time()
  File "/usr/local/trac/lib/python2.4/site-packages/trac/Session.py", line 101, in update_sess_time
    self['mod_time'] = now
  File "/usr/local/trac/lib/python2.4/site-packages/trac/Session.py", line 59, in __setitem__
    return self.set_var(key, val)
  File "/usr/local/trac/lib/python2.4/site-packages/trac/Session.py", line 141, in set_var
    self.sid, self.req.authname, key, val)
  File "/usr/src/build/539311-i386/install//usr/lib/python2.4/site-packages/sqlite/main.py", line 255, in execute
IntegrityError: columns sid, var_name are not unique

[Christopher Lenz]

The authenticated column should be part of the compound key of the session table. Grr, another DB upgrade script :-P

[Christopher Lenz]

(Fixed description)

[Christopher Lenz]

Patch that adds the authenticated column to the table key

[Christopher Lenz]

The attached patch​ provides a database upgrade that adds the authenticated column to the compound key of the session table. Seems to work with both SQLite and PostgreSQL.

Can someone else please test whether this creates any problems?

[Christopher Lenz]

Patch applied in [2418].