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
-~----------~----~----~----~------~----~------~--~---

Reply via email to