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
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%'" glib2.0/ 2.77.3- 1|20230904_ 021459_ 84fbc@| 8 webkit2gtk/ 2.41.91- 2|20230907_ 075337_ 8d55b@| 4 gsettings- desktop- schemas/ 45~rc-1ubuntu1| 20230907_ 195316_ 59de4@| 8 webkit2gtk/ 2.41.92- 1|20230909_ 052611_ fd604@| 4 glib2.0/ 2.78.0- 1|20230909_ 105044_ 9533a@| 8 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%'" glib2.0/ 2.77.3- 1|20230904_ 021459_ 84fbc@| 8 webkit2gtk/ 2.41.91- 2|20230907_ 075337_ 8d55b@| 4 gsettings- desktop- schemas/ 45~rc-1ubuntu1| 20230907_ 195316_ 59de4@| 8 webkit2gtk/ 2.41.92- 1|20230909_ 052611_ fd604@| 4 glib2.0/ 2.78.0- 1|20230909_ 105044_ 9533a@| 8
amd64|devhelp|
amd64|devhelp|
amd64|devhelp|
amd64|devhelp|
amd64|devhelp|
ubuntu@
amd64|devhelp|
amd64|devhelp|
amd64|devhelp|
amd64|devhelp|
amd64|devhelp|