(UnicodeDecodeError) browser & changeset summary in timeline

[artur.kwiatkowski@…]

Hi there, I've got problem with trac 0.10.4

running on debian box with virtual python.

it seems that when there are no calls to the application for more than 5-6 hours, something between trac and svn is crashing. here are the errors which I can provide. Maybe someone have a similar issue.

the trac project on which I've discovered the error:

Repository checkins event provider (ChangesetModule) failed:

UnicodeDecodeError: 'utf8' codec can't decode byte 0xb3 in position 29: unexpected code byte

this error does not exist on all of the projects, it exist only on some of them - cant say why exacly.

Now, while entering the browser/trunk catalog:

Traceback (most recent call last):
  File "/home/users/admin/system_tools/virtual-python/lib/python2.3/site-packages/trac/web/main.py", line 406, in dispatch_request
    dispatcher.dispatch(req)
  File "/home/users/admin/system_tools/virtual-python/lib/python2.3/site-packages/trac/web/main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "/home/users/admin/system_tools/virtual-python/lib/python2.3/site-packages/trac/versioncontrol/web_ui/browser.py", line 143, in process_request
    self._render_directory(req, repos, node, rev)
  File "/home/users/admin/system_tools/virtual-python/lib/python2.3/site-packages/trac/versioncontrol/web_ui/browser.py", line 168, in _render_directory
    changes = get_changes(self.env, repos, [i['rev'] for i in info])
  File "/home/users/admin/system_tools/virtual-python/lib/python2.3/site-packages/trac/versioncontrol/web_ui/util.py", line 37, in get_changes
    changeset = repos.get_changeset(rev)
  File "/home/users/admin/system_tools/virtual-python/lib/python2.3/site-packages/trac/versioncontrol/cache.py", line 45, in get_changeset
    self.authz)
  File "/home/users/admin/system_tools/virtual-python/lib/python2.3/site-packages/trac/versioncontrol/cache.py", line 247, in __init__
    "WHERE rev=%s", (rev,))
  File "/home/users/admin/system_tools/virtual-python/lib/python2.3/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/home/users/admin/system_tools/virtual-python/lib/python2.3/site-packages/trac/db/util.py", line 50, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 137, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
    raise errorclass, errorvalue
UnicodeDecodeError: 'utf8' codec can't decode byte 0xb1 in position 10: unexpected code byte

and the project logs look just like this:

2008-02-11 07:44:20,046 Trac[__init__] WARNING: 403 Forbidden (WIKI_VIEW privileges are required to perform this operation)
2008-02-11 07:44:20,046 Trac[__init__] WARNING: 403 Forbidden (WIKI_VIEW privileges are required to perform this operation)
2008-02-11 07:44:23,864 Trac[__init__] WARNING: 500 Internal Error (Repository checkins  event provider (<tt>ChangesetModule<
/tt>) failed:<br /><br />UnicodeDecodeError: 'utf8' codec can't decode byte 0xb3 in position 29: unexpected code byte<p>You m
ay want to see the other kind of events from the <a href="/myproject/timeline?milestone=on&amp;ticket=on&amp;wiki=on">Timeline</
a></p>)

so You see, the internall error in the project logs - it just appears when I click "timeline" or when I click "browser/some_catalogue".

I've checked if it is not a problem connected to making the changes on the repositories. No it isnt. I've added to hooks post-commit line which indicated the resync option (trac-admin /project/env resync) - i've readed on one of the other tickets that this should help (​http://trac.edgewall.org/ticket/5169) - no it doesnt in my case.

Im not sure if it is a error related to svn commit comments which can have some code in non utf encoding or maybe if it is something more than just this. Hard to say - maybe yes or maybe no - this is the major problem.

my debian goes with:

- virtual-python http://peak.telecommunity.com/DevCenter/EasyInstall#creating-a-virtual-python
- Python 2.3.5 (#2, Oct 16 2006, 19:19:48)
- mysql 5.0.51-2+tld2-log
- svnadmin, version 1.4.2 (r22196)
- svn, version 1.4.2 (r22196)

my trac runs with:

/home/users/admin/system_tools/virtual-python/bin/tracd --port=10000 --auth=*,/home/users/admin/dev/trac/passwd,mydomain.com -e /home/users/admin/dev/trac/projects -d -r

when I kill the trac process and start it again - the error does not appears till next time, and hard to say when is the next time or what is crashing the app svn support.

I would be very grateful for any help, any hints or any more questions which could lead me to the source of the problem !

[Christian Boos]

Could you please try this patch?

​http://trac-hacks.org/attachment/ticket/1493/mysql-autologoutbug.patch

[artur.kwiatkowski@…]

yes, this patch resolved my problem.

thanks !

[Christian Boos]

Thanks for testing it. Closing as duplicate of #5783.