error in syncing svn <> trac using mysql as backend

[anonymous]

jan@lab:~/projects/$ sudo trac-admin /data/trac/env/ resync
Resyncing repository history...
Traceback (most recent call last):
  File "/usr/bin/trac-admin", line 7, in ?
    sys.exit(
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/admin/console.py", line 1249, in run
    return admin.onecmd(command)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/admin/console.py", line 104, in onecmd
    rv = cmd.Cmd.onecmd(self, line) or 0
  File "/usr/lib/python2.4/cmd.py", line 219, in onecmd
    return func(arg)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/admin/console.py", line 632, in do_resync
    repos = env.get_repository().sync(self._resync_feedback)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/versioncontrol/cache.py", line 205, in sync
    (str(next_youngest),
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/Trac-0.11rc1-py2.4.egg/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.IntegrityError: (1062, "Duplicate entry '1-old/img/120-036.jpg-A' for key 1")

• trac version: Trac 0.11rc1
• os: debian
• mysql version: 5.0.32-Debian_7etch5-log
• svn version: svn, version 1.4.2 (r22196)

[Noah Kantrowitz]

To clarify a bit:

• resync worked fine with a blank repo and mysql.
• didn't work with mysql after a dump/load cycle in a new repo.
• the original repo worked fine with sqlite.
• checking the dumpfile for rev one, there isn't a duplicate node for that path.

[Christian Boos]

MySqlDb case insensitivity issue (#4378).