incorrect FirstSeen version for a problem

[Brian Murray]

The following problem - https://errors.ubuntu.com/problem/b79dc7b7fd2aa0b86f84127dd4abe57b1f455b08 - exists for multiple versions of mal-notification including 5.4.dfsg.1-6ubuntu4, however the first seen version found in BucketMetadata is 5.4.dfsg.1-6ubuntu4.1.

In [7]: cassandra.get_metadata_for_bucket('/usr/bin/mail-notification:11:_gtk_widget_invalidate_style_context:reset_style_recurse:gtk_box_forall:gtk_widget_reset_style:gtk_style_context_reset_widgets')
Out[7]: OrderedDict([(u'FirstSeen', '5.4.dfsg.1-6ubuntu4.1'), (u'LastSeen', '5.4.dfsg.1-6ubuntu6'), (u'LaunchpadBug', '1156185'), (u'Source', 'mail-notification')])

[Brian Murray (brian-murray)]

Looking at update_bucket_metadata in oops-repository and how it is called in daisy/utils.py I don't see anything immediately wrong. There is a check in daisy/utils.py to make sure that:

    if (package and version) and release.startswith('Ubuntu '):

However, all many of the ubuntu4 incidents are from Ubuntu 12.10 so that should pass.

One idea Evan had was that perhaps the submission process crashed before update_bucket_metadata was reached.

[Brian Murray (brian-murray)]

I wonder if resubmitting one of the crashes from a previous version of the package would correctly update the FirstSeen field.

[Brian Murray (brian-murray)]

Some more examples are:

https://errors.ubuntu.com/problem/a7ac1cd0d0229930be920775bdb2aae2a178a480
https://errors.ubuntu.com/bucket/?id=/usr/bin/tccat%3A11%3Advd_read%3Atccat_thread%3Amain
https://errors.ubuntu.com/problem/19da482fd86c0cd0c6fb9cdbfcaf1bfc262f59c1

However, out of 39 problems that I have checked I only found 4 incidents of this issue.

[Brian Murray (brian-murray)]

It'd be possible to update the non-release specific FirstSeen column by using data from BucketVersions CF.

As we can see this has the correct information for the mail-notification problem referenced in the description:

In [3]: cassandra.get_versions_for_bucket('/usr/bin/mail-notification:11:_gtk_widget_invalidate_style_context:reset_style_recurse:gtk_box_forall:gtk_widget_reset_style:gtk_style_context_reset_widgets')
Out[3]: OrderedDict([(u'5.4.dfsg.1-6ubuntu1', 4), (u'5.4.dfsg.1-6ubuntu3', 5), (u'5.4.dfsg.1-6ubuntu4', 21), (u'5.4.dfsg.1-6ubuntu4.1', 39), (u'5.4.dfsg.1-6ubuntu5', 6), (u'5.4.dfsg.1-6ubuntu6', 1)])