Comment 5 for bug 2035101

Example 2 could happen in the event that the autopkgtest.db files were out of sync on the autopkgtest-web units and britney used the one with old results. However, querying the database we can see that there are results for webkit2gtk and devhelp in both databases.

ubuntu@juju-4d1272-prod-proposed-migration-11:~$ sqlite3 autopkgtest.db "SELECT DISTINCT test.arch, test.package, result.triggers, result.run_id, result.exitcode FROM RESULT INNER JOIN test on result.test_id=test.id WHERE test.arch = 'amd64' AND test.package = 'devhelp' AND result.run_id LIKE '%202309%'"
amd64|devhelp|glib2.0/2.77.3-1|20230904_021459_84fbc@|8
amd64|devhelp|webkit2gtk/2.41.91-2|20230907_075337_8d55b@|4
amd64|devhelp|gsettings-desktop-schemas/45~rc-1ubuntu1|20230907_195316_59de4@|8
amd64|devhelp|webkit2gtk/2.41.92-1|20230909_052611_fd604@|4
amd64|devhelp|glib2.0/2.78.0-1|20230909_105044_9533a@|8
ubuntu@juju-4d1272-prod-proposed-migration-10:~/public$ sqlite3 autopkgtest.db "SELECT DISTINCT test.arch, test.package, result.triggers, result.run_id, result.exitcode FROM RESULT INNER JOIN test on result.test_id=test.id WHERE test.arch = 'amd64' AND test.package = 'devhelp' AND result.run_id LIKE '%202309%'"
amd64|devhelp|glib2.0/2.77.3-1|20230904_021459_84fbc@|8
amd64|devhelp|webkit2gtk/2.41.91-2|20230907_075337_8d55b@|4
amd64|devhelp|gsettings-desktop-schemas/45~rc-1ubuntu1|20230907_195316_59de4@|8
amd64|devhelp|webkit2gtk/2.41.92-1|20230909_052611_fd604@|4
amd64|devhelp|glib2.0/2.78.0-1|20230909_105044_9533a@|8