IntegrityError: columns cookie, ipnr, name are not unique

[Emmanuel Blot]

When several browsers are used to access the same tracd instance and the login page (basic HTTP authentication) is requested with the same username, the following error is always thrown to the second (and subsequent) browser instances.

Although this issue does not really occur with a regular use of Trac, it is really painful for Trac and plugin development, while validating rendering with various browsers.

The error magically disappears after a random number of refresh of the login page. It is triggered with virtually every browser.

(no sure about the component, though)

File "trunk/trac/web/main.py", line 417, in _dispatch_request
  dispatcher.dispatch(req)
File "trunk/trac/web/main.py", line 197, in dispatch
  resp = chosen_handler.process_request(req)
File "trunk/trac/web/auth.py", line 101, in process_request
  self._do_login(req)
File "trunk/trac/web/auth.py", line 141, in _do_login
  req.remote_addr, int(time.time())))
File "trunk/trac/db/util.py", line 50, in execute
  return self.cursor.execute(sql_escape_percent(sql), args)
File "trunk/trac/db/sqlite_backend.py", line 58, in execute
  args or [])
File "trunk/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
  return function(self, *args, **kwargs)

Trac: 0.11dev-r6612
Python: 2.5.1 (r251:54863, Jan 17 2008, 19:35:17)
setuptools: 0.6c7
SQLite: 3.4.0
pysqlite:	2.3.5
Genshi: 0.4.4
Pygments: 0.9
Subversion: 1.4.4 (r25188)
jQuery: 1.2.3

[Emmanuel Blot]

See also #2570.

[Christopher Lenz]

Duplicate of #2570.