Bug 224051

Summary:	Bugs with modified dates from the future
Product:	Services	Reporter:	Tobias Kortkamp <tobik>
Component:	Bug Tracker	Assignee:	Oleksandr Tymoshenko <gonzo>
Status:	Closed FIXED
Severity:	Affects Only Me	CC:	bugmeister, gonzo
Priority:	---
Version:	unspecified
Hardware:	Any
OS:	Any
See Also:	https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3497 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3481

Description Tobias Kortkamp freebsd_committer

2017-12-03 10:46:03 UTC

For some reason bug #3497 and bug #3481 have modified dates from the future.
This means that they always appear in the "Bugs changed in the last 24 hours" 
search results.

Can they be reset to something more appropriate?

Comment 1 Oleksandr Tymoshenko freebsd_committer

2017-12-04 01:30:29 UTC

Fixed. Probably some glitch in GNATS to bugzilla conversion

Comment 2 Kubilay Kocak freebsd_committer

2017-12-04 01:32:24 UTC

Assign to committer that resolved.

@gonzo, could you detail (for our future selves and others) how this was resolved?

Comment 3 Oleksandr Tymoshenko freebsd_committer

2017-12-04 02:41:16 UTC

(In reply to Kubilay Kocak from comment #2)

Sure, should have done in the first place, my bad.
I had to manually fix delta_ts value in database by running something like this:

update bugs set delta_ts='1997-05-03 23:25:30' where bug_id=3481;

I got the date from the last entry in bugs_activity table: 

select * from bugs_activity where bug_id=3481 order by bug_when desc limit 1; 

If last activity in bug was comment you can get this information from longdescs table:

select * from longdescs where bug_id=3481 order by bug_when desc limit 1;