[Trac-tickets] [The Trac Project] #2208: Corrupted changetime field prevents viewing of tickets

[The Trac Project]

#2208: Corrupted changetime field prevents viewing of tickets
--------------------------------+-------------------------------------------
 Reporter:  mellis at netblue.com  |       Owner:  jonas
     Type:  defect              |      Status:  new  
 Priority:  low                 |   Milestone:       
Component:  ticket system       |     Version:  0.9b2
 Severity:  major               |   Keywords:                      |  
--------------------------------+-------------------------------------------
 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
 }}}

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/2208>
The Trac Project <http://trac.edgewall.com/>