4 ms·

>It's not every day you can say you found and helped troubleshoot a bug that literally could be affected 100s of millions of users! With today's mindset of let

>It's not every day you can say you found and helped troubleshoot a bug that literally could be affected 100s of millions of users! With today's mindset of letting users do most of the testing, it is actually quite common to find bugs like that. However, really nice job of the SQLite devs to follow through so fast.

dalke 10y ago
You write "it is actually quite common to find bugs like that" Your definition of "common" is quite different than mine. There are only a handful of packages which are used by "100s of millions of users." If finding and helping to troubleshoot a bug is "common" then that's, what, 1 million user-reported bugs? Mozilla's bug tracker has only 1.3M entries. Now, I've submitted a bug to Mozilla. But I've submitted far more bugs to smaller packages, which don't have 100s of millions of users. So I think it's not that "common to find bugs like that."
- yAnonymous 10y ago
  >Mozilla's bug tracker has only 1.3M entries Your definition of "only" is quite different than mine. :) Dozens of these bugs have been reported by me (same for Chromium) and I'm not even that much of a bug hunter. So yeah, I'd say it's common.
  - dalke 10y ago
    The "only" is as a ratio. If there are >100M users and only 1.3M bugs then that implies <76 users per reported bug. Given that some of those are developers, or people like you, who report dozens of bugs, the odds of a user reporting a bug is well less than 1:100. I submit that it's far less. The odds of someone finding and helping to troubleshoot the bug are even lower. By comparison, most of the bug report I've sent in are to packages with fewer than 10,000 users.
  - chris_wot 10y ago
    It wasn't that I reported it, it was more that I had a stab at troubleshooting it :-) If I hadn't traced out the SQL statement that was causing the segfaults I think it might not have been found!

dalke 10y ago

You write "it is actually quite common to find bugs like that" Your definition of "common" is quite different than mine. There are only a handful of packages which are used by "100s of millions of users." If finding and helping to troubleshoot a bug is "common" then that's, what, 1 million user-reported bugs? Mozilla's bug tracker has only 1.3M entries. Now, I've submitted a bug to Mozilla. But I've submitted far more bugs to smaller packages, which don't have 100s of millions of users. So I think it's not that "common to find bugs like that."

yAnonymous 10y ago
>Mozilla's bug tracker has only 1.3M entries Your definition of "only" is quite different than mine. :) Dozens of these bugs have been reported by me (same for Chromium) and I'm not even that much of a bug hunter. So yeah, I'd say it's common.
- dalke 10y ago
  The "only" is as a ratio. If there are >100M users and only 1.3M bugs then that implies <76 users per reported bug. Given that some of those are developers, or people like you, who report dozens of bugs, the odds of a user reporting a bug is well less than 1:100. I submit that it's far less. The odds of someone finding and helping to troubleshoot the bug are even lower. By comparison, most of the bug report I've sent in are to packages with fewer than 10,000 users.
- chris_wot 10y ago
  It wasn't that I reported it, it was more that I had a stab at troubleshooting it :-) If I hadn't traced out the SQL statement that was causing the segfaults I think it might not have been found!