Edgewall Software

Opened 17 years ago

Closed 17 years ago

Last modified 16 years ago

#2208 closed defect (fixed)

Corrupted changetime field prevents viewing of tickets

Reported by: mellis@… Owned by: Christopher Lenz
Priority: low Milestone: 0.9
Component: timeline Version: 0.9b2
Severity: major Keywords:
Cc: Christian Boos Branch:
Release Notes:
API Changes:
Internal Changes:


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
  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

Attachments (0)

Change History (4)

comment:1 by mellis@…, 17 years ago

Component: ticket systemtimeline

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.

comment:2 by Christopher Lenz, 17 years ago

Milestone: 0.9
Owner: changed from Jonas Borgström to Christopher Lenz
Status: newassigned

comment:3 by anonymous, 17 years ago

Resolution: fixed
Status: assignedclosed

Fixed in [2404].

comment:4 by Christopher Lenz, 17 years ago

That anonymous was me. Sorry.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Christopher Lenz.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Christopher Lenz to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.