Corrupted changetime field prevents viewing of tickets

[mellis@…]

Somehow the changetime field in a ticket of ours got changed to a non-integer number (1129000177.4728). This meant that any report including the ticket in question failed. I was able to go into the database and edit the offending record manually and restore service that way without having to use our daily backup.

We have 30+ users on 3 individual tracs for about 5 months now, this is the first time we've seen this particular error. We upgraded less than a week ago to 0.9b2-intertrac (I think it's [2320]) on a completely new server.

Here is the traceback:

Python traceback

Traceback (most recent call last):
  File "/usr/lib/python2.3/site-packages/trac/web/modpython_frontend.py", line 206, in handler
    dispatch_request(mpr.path_info, mpr, env)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 139, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.3/site-packages/trac/web/main.py", line 107, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.3/site-packages/trac/ticket/report.py", line 116, in process_request
    resp = self._render_view(req, db, id)
  File "/usr/lib/python2.3/site-packages/trac/ticket/report.py", line 354, in _render_view
    value['date'] = util.format_date(cell)
  File "/usr/lib/python2.3/site-packages/trac/util.py", line 201, in format_date
    return format_datetime(t, format, gmt)
  File "/usr/lib/python2.3/site-packages/trac/util.py", line 195, in format_datetime
    t = time.localtime(int(t))
ValueError: invalid literal for int(): 1129000177.47

[mellis@…]

OK, so I think we know what caused this. I deleted a milestone from within the View Milestones page which changed the milestone for this particular ticket to None. The exact change is recorded as:

10/10/05 20:09:37: Modified by mellis

milestone deleted.
Milestone Test Milestone deleted

This ticket had a non-integer changetime and the last change made to it was by the delete milestone function.

[anonymous]

Fixed in [2404].

[cmlenz]

That anonymous was me. Sorry.