543899 - 4294967295 Add-ons in this Collection

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Collections, defect, P3)

Description

[Daniel Veditz [:dveditz]]

Was browsing collections and was surprised by one claiming "4294967295 Add-ons in this Collection" on the Collections search page and also in the collection itself.

The collection appears to be empty, not sure how "0" turned into "-1" internally. Fixing this collection might be just a database update, but there is probably also a code bug that leads to this bogus number.  (or maybe it's a simple display error.)

https://addons.mozilla.org/en-US/firefox/collection/b32f548b-74c1-a079-7690-af61fc08d6b6

Comment 1

[Jorge Villalobos [:jorgev] (he/him)]

I'm really tempted to send this to the DailyWTF :)

Comment 2

[Wil Clouser [:clouserw]]

That collection has no add-ons in it, that number is managed through triggers in the database.  I can't tell what happened to put this into the state it's in, but I don't see a bug in the triggers - I'm guessing mysql hiccuped and the connection died outside of a transaction or something.

There are a total of 4 collections that are affected, all of them empty.  I'll commit a fix that will update their count with the next push.  I'm not going to investigate further since I don't know of a way to reproduce and collections is being redone in the next couple months.