IntegrityError: (1062, "Duplicate entry '815-server/impl/trunk/.lib/rasea-server-common.jar -D' for key 1")

[cleverson.sacramento@…]

How to Reproduce

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

When I just try to access the following url ​https://sourceforge.net/apps/trac/rasea/timeline I get this error message

User Agent was: Mozilla/5.0 (X11; U; Linux i686; pt-BR; rv:1.9.0.9) Gecko/2009042113 Ubuntu/8.04 (hardy) Firefox/3.0.9

System Information

Trac	0.11.2.1
Python	2.4.3 (#1, May 24 2008, 13:57:05) [GCC 4.1.2 20070626 (Red Hat 4.1.2-14)]
setuptools	0.6c9
MySQL	server: "5.0.51a-log", client: "5.0.45", thread-safe: 0
MySQLdb	1.2.2
Genshi	0.5.1
mod_python	3.2.8
Pygments	0.9
Subversion	1.6.4 (r38063)
jQuery:	1.2.6

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 432, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 174, in dispatch
    chosen_handler)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 295, in _pre_process_request
    chosen_handler = filter_.pre_process_request(req, chosen_handler)
  File "/usr/lib/python2.4/site-packages/trac/versioncontrol/api.py", line 86, in pre_process_request
    self.get_repository(req.authname).sync()
  File "/usr/lib/python2.4/site-packages/trac/versioncontrol/cache.py", line 210, in sync
    (str(next_youngest),
  File "/usr/lib/python2.4/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib64/python2.4/site-packages/MySQLdb/cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
IntegrityError: (1062, "Duplicate entry '815-server/impl/trunk/.lib/rasea-server-common.jar -D' for key 1")

[anonymous]

I am using the SourceForge Trac hosted app to manage the support requests of my project: ​http://sourceforge.net/projects/rasea/

[Christian Boos]

Wrong MySQL database collation method (should be utf8_bin, see MySqlDb).

Correct this and resync.