MySQL-Error with Changesets

[antondollmaier@…]

How to Reproduce

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

The database is complete UTF8, including a column-type-change to utf_bin for node_change.path.

Other Trac-Projects with the same environment, but with different repository and database, work great.

recreating the trac-project does not help: the svn-resync-process fails because of duplicate path-names (file.jpg and file.JPG), after changing column-type the sync works, but no changeset-view is possible.

The revisionlog in browser-view works, but "Last Change" does not, same error with the same traceback.

upgrading to latest svn-revision (r6814) does not fix the issue.

thanks in advance!

Request parameters:

{'new': u'194'}

System Information

Trac	0.11dev-r6669
Python	2.4.4 (#1, Apr 5 2007, 20:09:06) [GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)]
setuptools	0.6c8
MySQL	server: "5.0.32-Debian_7etch5-log", client: "5.0.32", thread-safe: 0
MySQLdb	1.2.1_p2
Genshi	0.4.4
mod_python	3.2.10
Subversion	1.4.2 (r22196)

Python Traceback

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6669-py2.4.egg/trac/web/main.py", line 419, in _dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6669-py2.4.egg/trac/web/main.py", line 196, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6669-py2.4.egg/trac/versioncontrol/web_ui/changeset.py", line 323, in process_request
    self._render_html(req, repos, chgset, restricted, xhr, data)
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6669-py2.4.egg/trac/versioncontrol/web_ui/changeset.py", line 541, in _render_html
    for old_node, new_node, kind, change in get_changes():
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6669-py2.4.egg/trac/versioncontrol/web_ui/changeset.py", line 364, in get_changes
    for npath, kind, change, opath, orev in chgset.get_changes():
  File "/usr/lib/python2.4/site-packages/Trac-0.11dev_r6669-py2.4.egg/trac/versioncontrol/cache.py", line 282, in get_changes
    path.strip('/'))):
AttributeError: 'array.array' object has no attribute 'strip'

[cboos]

IIRC, it's a known bug in MySQLdb 1.2.1_p2.
Please upgrade to 1.2.2 (see MySqlDb) and tell us if that worked.

If not, maybe it's because you did the "column-type-change to utf_bin for node_change.path" (see #4288).

[anonymous]

Ok ... manual installation of MySQLDB 1.2.2 from the site solves the issue, sorry for new ticket ...

but I really wonder: why does mysqldb of debian stable have such a bug? ... this does not make much sense ...

thanks!