Hello everyone, (see also http://groups.google.com/group/trac-users/browse_thread/thread/2f3bb851921f795b/1f5dbaba4a5655ac?)
I had a little Subversion repository and a little Trac system on my little WIN32 development machine for demonstration and testing purposes. Everyone in the company liked it, so they gave me a monster server machine. I installed FreeBSD, Python, Apache, Subversion, MySQL, Trac, etc. pp. yadiyadi... Then I migrated all Subversion repositories and all flat file, zipped and/or emailed code caches I could find throughout the company. The resulting repository is substantially larger than my test repo (roughly 10GB on disk after full check-out). I am using MySQL 5.0 as database backend. When I try to browse the code in SVN from Trac, it takes some time, then a message appears: Python Traceback Traceback (most recent call last): File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 379, in dispatch_request dispatcher.dispatch(req) File "/usr/local/lib/python2.4/site-packages/trac/web/main.py", line 230, in dispatch resp = chosen_handler.process_request(req) File "/usr/local/lib/python2.4/site-packages/trac/versioncontrol/web_ui/browser.py", line 131, in process_request self._render_directory(req, repos, node, rev) File "/usr/local/lib/python2.4/site-packages/trac/versioncontrol/web_ui/browser.py", line 156, in _render_directory changes = get_changes(self.env, repos, [i['rev'] for i in info]) File "/usr/local/lib/python2.4/site-packages/trac/versioncontrol/web_ui/util.py", line 37, in get_changes changeset = repos.get_changeset(rev) File "/usr/local/lib/python2.4/site-packages/trac/versioncontrol/cache.py", line 41, in get_changeset self.sync() File "/usr/local/lib/python2.4/site-packages/trac/versioncontrol/cache.py", line 107, in sync (str(current_rev), path, kind, action, File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 47, in execute return self.cursor.execute(sql_escape_percent(sql), args) File "/usr/local/lib/python2.4/site-packages/trac/db/util.py", line 47, in execute return self.cursor.execute(sql_escape_percent(sql), args) File "/usr/local/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute self.errorhandler(self, exc, value) File "/usr/local/lib/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler raise errorclass, errorvalue IntegrityError: (1062, "Duplicate entry '820-Development/trunk/... (some stubified repository path) ...' for key 1") I tried trac-admin /var/trac/projects resync, but it fails with either Resyncing repository history... Command failed: (1062, "Duplicate entry '820-Development/trunk/... (some stubified repository path) ...' for key 1") or Resyncing repository history... Command failed: (1205, 'Lock wait timeout exceeded; try restarting transaction') (which I had hoped I had solved - see link above) In the Trac log, a veeerry long list of 2006-11-14 11:09:21,300 Trac[cache] DEBUG: Caching node change in [820]: ... entries is followed by the traceback message shown above. What can I do ? TIA, CU z00m1n --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---