UnicodeDecodeError: 'utf8' codec can't decode bytes in position 8-10: unexpected end of data

[evan.watson@…]

We receive this error on daily basis, to resolve we must stop and restart the apache server.

Windows 2003 Server Apache 2.0.55 Python 2.4 MySql 5.0.11

Python Traceback

Traceback (most recent call last):
  File "E:\Program Files\Python24\Lib\site-packages\trac\web\main.py", line 387, in dispatch_request
    dispatcher.dispatch(req)
  File "E:\Program Files\Python24\Lib\site-packages\trac\web\main.py", line 237, in dispatch
    resp = chosen_handler.process_request(req)
  File "E:\Program Files\Python24\Lib\site-packages\trac\ticket\query.py", line 390, in process_request
    constraints = self._get_constraints(req)
  File "E:\Program Files\Python24\Lib\site-packages\trac\ticket\query.py", line 450, in _get_constraints
    ticket_fields = [f['name'] for f in
  File "E:\Program Files\Python24\Lib\site-packages\trac\ticket\api.py", line 104, in get_ticket_fields
    for username, name, email in self.env.get_known_users(db):
  File "E:\Program Files\Python24\Lib\site-packages\trac\env.py", line 285, in get_known_users
    cursor.execute("SELECT DISTINCT s.sid, n.value, e.value "
  File "E:\Program Files\Python24\Lib\site-packages\trac\db\util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "E:\Program Files\Python24\Lib\site-packages\trac\db\util.py", line 51, in execute
    return self.cursor.execute(sql)
  File "E:\Program Files\Python24\Lib\site-packages\MySQLdb\cursors.py", line 163, in execute
    self.errorhandler(self, exc, value)
  File "E:\Program Files\Python24\Lib\site-packages\MySQLdb\connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
UnicodeDecodeError: 'utf8' codec can't decode bytes in position 8-10: unexpected end of data

[Christian Boos]

Looks like you're not the only one… see #3723.

[anonymous]

We have noticed the same problem. It helps to open and save config file. The strange thing is, that it only happens during the night when nobody is working with the system. I tryed to iconv config file and encoding was OK.