Comment 1 for bug 536641

Looking at https://edge.launchpad.net/ubuntu/lucid/+source/sun-java6 you can see there are actually 2 6.18-2 releases listed, which indicates that there are two releases with the save version in two separate distro archives.

Running a query on staging shows this is the case:
16:05 < noodles> Can you run this for me (on staging):
16:05 < noodles> http://pastebin.ubuntu.com/392585/
17:20 < bigjools> noodles: haha
17:20 < bigjools> id | version | name
17:20 < bigjools> --------+---------+---------
17:20 < bigjools> 549031 | 6-16-1 | primary
17:20 < bigjools> 468586 | 6-15-1 | primary
17:20 < bigjools> 618325 | 6.18-2 | primary
17:20 < bigjools> 620648 | 6.18-2 | partner
17:20 < bigjools> (4 rows)

So we might want to think about not allowing the same version to exist in the same series of two separate *distro archives* (MAIN_ARCHIVE_PURPOSES, which also includes debug). It seems to break the url traversal and confuses apt locally (given that most people will have main and partner enabled). Are there other options?