Comment 10 for bug 499095

Revision history for this message
Michael Nelson (michael.nelson) wrote :

Some more candidates without start-dates have turned up on the builders:

https://edge.launchpad.net/~n-muench/+archive/gnu-programs/+build/1428814
https://edge.launchpad.net/~n-muench/+archive/gnu-programs/+build/1428815
https://edge.launchpad.net/~n-muench/+archive/gnu-programs/+build/1428816

I had thought this was because the query that was used to fix the previous builds:

https://pastebin.canonical.com/26156/

only fixed the data for builds that were currently stuck on builders (due to the bq.builder is not null clause), so I prepared the following to check for other examples of the same data corruption that are *not* currently building:

https://pastebin.canonical.com/26187/

(btw: is there any reason why these queries can't go on the public pastebin? I'm just doing them there as we seem to always do so).

But then the date created for the above builds indicates that the build records were only created just before the building started. I checked with mthaddon and there haven't been any more occurrences of bug 499421, so it seems to be unrelated to fixing 499421.