0.10.4 MySql Error

[Greg]

To test the errors I was receiving I started a new empty 1.4.3 Subversion Repository and then created a new 0.10.4 Trac Env. pointing to that Repos. I initialized this using MySql 5.0.37 and Apache 2.2 Mod_python and a htpasswd file all on Mandriva 2007.1.

Initial Login successful but after clicking on a few links ( In this instance the TracAdmin wiki link on the default start page ) I get an error:

Python Traceback
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 191, in dispatch
    chosen_handler = self._pre_process_request(req, chosen_handler)
  File "/usr/lib/python2.5/site-packages/trac/web/main.py", line 263, in _pre_process_request
    chosen_handler = f.pre_process_request(req, chosen_handler)
  File "/usr/lib/python2.5/site-packages/trac/versioncontrol/api.py", line 73, in pre_process_request
    self.get_repository(req.authname).sync()
  File "/usr/lib/python2.5/site-packages/trac/versioncontrol/cache.py", line 87, in sync
    (CACHE_REPOSITORY_DIR, self.name,))
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.5/site-packages/MySQLdb/cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.5/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
IntegrityError: (1062, "Duplicate entry 'repository_dir' for key 1")

The actual error is not always the same the symptom that at the top of the page I am no longer logged in. Instead of saying "logged in as xxx", the login link is there.

After logging in again the offending link would work again until another error happens. Again this on a new empty repos with a newly initialized trac env.

Following the same exact documented install steps only using SQLite instead of MySql does not result in the same erros.

[Christian Boos]

Thanks for the report, I'll have a look.

[Christian Boos]

What does the following SQL query outputs?

SELECT name, value FROM system

[anonymous]

I had already wiped that system, so I created a new parallel repos on my existing 0.10.4 system. All specs the same only my working repos uses SQlite3.

I logged in and clicked around until I received the same error( no longer logged in ).

mysql> SELECT name, value FROM system; +—————————+———————————————————————————————-+ | name | value | +—————————+———————————————————————————————-+ | database_version | 20 | | repository_dir | svn:c4adc6fa-97e7-4021-821f-ba073683f83c:/home/repos/test/svn | | youngest_rev | | +—————————+———————————————————————————————-+ 3 rows in set (0.00 sec)

[Christian Boos]

Sorry for not realizing it earlier, actually I believe this must be a duplicate of #4378.