Get patch download statistics to inform core issue triage

hestenet gave me read access to existing data that includes the patch downloads.

The default time period was the past month, which is too short for what is needed to help with issue triage. So, I tried two longer periods, one starting from the beginning of the calendar year and the other starting 1 year ago. The results listed by most downloads first. Some issues are listed more than once because there is more than one patch in the file that is being downloaded.

1 Jan 2023 - 3 May 2023

1. #696: Add filter to logs and referrer lists →
2. #930876: PDOException: SQLSTATE[08004] [1040] Too many connections in lock_may_be_available() →
3. #1059718: Additional uncaught exception thrown while handling exception. →
4. 🐛 (canard?) Big Bos of Random Fails is ChainedFastBackend::markAsOutdated() Needs work
5. #77875: Allow administrator to set logging level for Watchdog →
6. #212088: watchdog: enable/disable the logging of WATCHDOG_DEBUG severity messages. →
7. #2322949: Implement generic entity link view field handlers →
8. #2710793: Views Exposed Filter Date Fields Use Text Input Type →
9. #2761409: The latest revision isn't always the current revision →
10. ✨ Taxonomy Index for unpublished entities Needs work
11. ✨ Taxonomy Index for unpublished entities Needs work
12. #2580473: Increase size of info column in system table. →
13. #2580473: Increase size of info column in system table. →
14. #189568: Overriding module CSS with theme CSS →
15. #17303: PHP session settings to relocate to support multiple sites →
16. #2418587: Set entity values to NULL instead of using unset() method: unset() is misleading →
17. #504012: Index content when created →
18. 📌 Replace custom password hashing library with PHP password_hash() Fixed
19. 🐛 Avoid loading all terms on the taxonomy overview form Needs work
20. #2612222: Provide a better way to alter entity revision overview →
21. #2738637: Inline JS blocked when strict MIME type checking is enabled. →
22. #2324649: Migrate text fields correctly based on their text_processing setting. →
23. #2876343: Return an empty array from \Drupal\Core\Menu\MenuTreeStorageInterface::save() if no storage update done →
24. #2179083: Rendered menus (e.g. menu blocks) should set cache tags to inform the page cache →
25. 🐛 Imported PO files have no public URL but have a link at admin/content/files Needs review
26. #2208617: Add key value entity storage →
27. #2797639: For multi language private files FileDownloadController is used for the ImageStyle instead of ImageStyleDownloadController →
28. #2781599: "Flood" table isn't being created automatically →
29. #2481751: Don't use full namespace for \Drupal\views\ViewExecutable in views.module →
30. #2364343: Fix robots.txt to allow search engines access to CSS, JavaScript and image files →
31. #2482295: Rebuilding field map with many bundles/fields is very slow →
32. #732992: Allow filter_xss_admin() to accept HTML5 tags →
33. #2640496: Revision ID in {node} and {node_revision} can get out of sync →
34. #2640086: Editor routes don't use the ajax_base_page theme negotiator →
35. #2308783: Remove format_interval() →
36. 📌 Clean up menu_contextual_links() Closed: outdated
37. #444344: jQuery .once() method for adding behaviors once →
38. 📌 Add hook_form_view_alter() Postponed: needs info
39. #17303: PHP session settings to relocate to support multiple sites →
40. 🐛 Default value for link text is not saved Needs work
41. #1164766: Two menu items with the same name (but different paths) cannot be distinguished. →
42. 📌 Make pager start counting from 1, not 0 Active
43. #2927356: Support SRI for external assets →
44. ✨ Add support for typed data selection Needs work
45. #154471: Refine menu permissions - add separate one for menu OTF →
46. #2295469: Add support for static permission definitions with *.permissions.yml →
47. #189568: Overriding module CSS with theme CSS →
48. #2767243: Create a theme suggestion for taxonomy terms by view mode →
49. ✨ Allow query strings in URL aliases Needs work
50. #2716019: View titles in breadcrumb and metatag title don't get properly translated →
51. #2582309: Cookies get lost during RedirectResponse replacement →
52. #2182055: Comment module causes Circular reference error on a REST request →
53. #654796: Identify fix bugs with checkbox element →
54. #313145: Support X-Forwarded-* HTTP headers alternates →
55. #2475749: Allow to set #cache metadata in hook_page_attachments() →
56. ✨ Allow setting #attributes for form select options Needs work
57. ✨ Allow range when editing a number field Needs work
58. ✨ Allow range when editing a number field Needs work
59. ✨ Allow range when editing a number field Needs work
60. #2533768: Add the user entity cache tag to user.* cache contexts that need it →
61. #472646: Can't install on PostgreSQL →
62. #472646: Can't install on PostgreSQL →
63. 📌 Introduce proper Form API #types for 'option' and 'optgroup', and make #options consistent. Needs work
64. #2937945: Add messenger to ControllerBase and FormBase →

3 May 2022 - 3 May 2023

1. #2761409: The latest revision isn't always the current revision →
2. ✨ Taxonomy Index for unpublished entities Needs work
3. ✨ Taxonomy Index for unpublished entities Needs work
4. #2580473: Increase size of info column in system table. →
5. #2580473: Increase size of info column in system table. →
6. #17303: PHP session settings to relocate to support multiple sites →
7. 📌 Replace custom password hashing library with PHP password_hash() Fixed
8. #2738637: Inline JS blocked when strict MIME type checking is enabled. →
9. #2324649: Migrate text fields correctly based on their text_processing setting. →
10. #2481751: Don't use full namespace for \Drupal\views\ViewExecutable in views.module →
11. #2364343: Fix robots.txt to allow search engines access to CSS, JavaScript and image files →
12. #2482295: Rebuilding field map with many bundles/fields is very slow →
13. #2640086: Editor routes don't use the ajax_base_page theme negotiator →
14. 📌 Add hook_form_view_alter() Postponed: needs info
15. #17303: PHP session settings to relocate to support multiple sites →
16. 🐛 Default value for link text is not saved Needs work
17. 📌 Make pager start counting from 1, not 0 Active
18. #2767243: Create a theme suggestion for taxonomy terms by view mode →
19. ✨ Allow query strings in URL aliases Needs work
20. #2475749: Allow to set #cache metadata in hook_page_attachments() →
21. #2533768: Add the user entity cache tag to user.* cache contexts that need it →
22. #2937945: Add messenger to ControllerBase and FormBase →
23. #2928685: File::toUrl() does not work. →
24. #2767857: Add destination to edit, delete, enable, disable links in entity list builders →
25. #2754477: Unexpected config entity delete due to dependency calculations →
26. #2670730: Provide a delete action for each content entity type →
27. #2639686: Replace get('entity.manager')->getStorage() with get('entity_type.manager')->getStorage() in all tests →
28. #2599594: Multilingual content: Menu link is not correctly stored on translation. →
29. #2538228: Document that Config save/delete/rename events may be dispatched during hook_update_N(), what that means for subscribers, and fix core subscribers accordingly →
30. #2513586: Remove the word "positive" from the "Must include a positive keyword with three characters or more." error message →
31. #2500931: Views feed doesn't encode embedded HTML anymore →
32. #2500931: Views feed doesn't encode embedded HTML anymore →
33. #2419825: Make serialization_class optional →
34. #2389335: Deprecate entity.query service and replace with using the entity storage's getQuery() method →
35. #2347287: Provide a trait for setting messages →
36. #2342593: Remove mixed SSL support from core →
37. 🐛 Batch operation fails silently if an operation callback is not found Needs work
38. #2228393: Decouple session from cookie based user authentication →
39. 🐛 Xss::filterAdmin() incorrectly filters datetime attribute Fixed
40. 🐛 Leftover D10 deprecations in ajax.js Needs work
41. ✨ Make it easier for theme builders to enable Twig debugging and disable render cache Fixed
42. 🐛 Multiple usages of FieldPluginBase::getEntity do not check for NULL, leading to WSOD Fixed
43. 🐛 Correct vertical tab does not focus on form validation Fixed
44. 🐛 Attribute hreflang not allowed on element li at this point Needs review
45. 📌 Fork laminas/laminas-diactoros Fixed
46. 📌 Fork laminas/laminas-diactoros Fixed
47. 📌 Fork laminas/laminas-diactoros Fixed
48. ✨ Improve the Vocabulary edit form title Closed: duplicate
49. 📌 Drupal 9 uses PHP syntax that's deprecated in PHP 8.2, so exclude that from error_reporting() and DeprecationListenerTrait Fixed
50. 🐛 Views exposed form block options are not updated immediately when adding additional sorts, filters, etc (Caching?) Needs work
51. ✨ Add configurable description to content type title field. Needs work
52. 💬 Update aborted by system_post_update_sort_all_config. Drush command terminated abnormally. Output is empty. Postponed: needs info
53. 🐛 Fix regression caused by ::class constant Fixed
54. 🐛 Error: Call to a member function getConfigDependencyKey() on null in web/core/modules/taxonomy/src/Plugin/views/filter/TaxonomyIndexTid.php Postponed: needs info
55. 🐛 Layout builder does not protect against recursion Needs work
56. 📌 Allow multiple instances of the same exposed filter form on a single page Needs work
57. 🐛 Error: Call to a member function getConfigDependencyKey() on null in web/core/modules/taxonomy/src/Plugin/views/filter/TaxonomyIndexTid.php Postponed: needs info
58. 🐛 Drupal\Component\Utility\Html::normalize() leaves messy in certain situations Fixed
59. 🐛 Image Media thumbnail alt text cannot be changed without reuploading the image Needs work
60. ✨ Add Exception for TypeError Argument must be String in \Drupal\Component\Utility\Html escape{} Needs work
61. 🐛 strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated Needs work
62. 📌 Allow multiple instances of the same exposed filter form on a single page Needs work
63. 🐛 TimestampDatetimeWidget::massageFormValues does not allow NULL value Closed: works as designed
64. 🐛 Views hardcodes exposed filter block form ID's which breaks AJAX when the same form is shown multiple times on one page Needs review
65. 🐛 "Has taxonomy term" contextual filter does not take the language value into account Needs work
66. 🐛 Tabledrag is broken in layout builder sidebar Needs work
67. 🐛 Multiple usages of FieldPluginBase::getEntity do not check for NULL, leading to WSOD Fixed

Thanks to hestenet who told me how to filter I was able to get the top 100 for the past 12 months. This is probably a better set of data to consider.

Top 100 core issues for 3 May 2022 - 3 May 2023

1. #2761409: The latest revision isn't always the current revision →
2. ✨ Taxonomy Index for unpublished entities Needs work
3. ✨ Taxonomy Index for unpublished entities Needs work
4. #2580473: Increase size of info column in system table. →
5. #2580473: Increase size of info column in system table. →
6. #17303: PHP session settings to relocate to support multiple sites →
7. 📌 Replace custom password hashing library with PHP password_hash() Fixed
8. #2738637: Inline JS blocked when strict MIME type checking is enabled. →
9. #2324649: Migrate text fields correctly based on their text_processing setting. →
10. #2481751: Don't use full namespace for \Drupal\views\ViewExecutable in views.module →
11. #2364343: Fix robots.txt to allow search engines access to CSS, JavaScript and image files →
12. #2482295: Rebuilding field map with many bundles/fields is very slow →
13. #2640086: Editor routes don't use the ajax_base_page theme negotiator →
14. 📌 Add hook_form_view_alter() Postponed: needs info
15. #17303: PHP session settings to relocate to support multiple sites →
16. 🐛 Default value for link text is not saved Needs work
17. 📌 Make pager start counting from 1, not 0 Active
18. #2767243: Create a theme suggestion for taxonomy terms by view mode →
19. ✨ Allow query strings in URL aliases Needs work
20. #2475749: Allow to set #cache metadata in hook_page_attachments() →
21. #2533768: Add the user entity cache tag to user.* cache contexts that need it →
22. #2937945: Add messenger to ControllerBase and FormBase →
23. #2928685: File::toUrl() does not work. →
24. #2767857: Add destination to edit, delete, enable, disable links in entity list builders →
25. #2754477: Unexpected config entity delete due to dependency calculations →
26. #2670730: Provide a delete action for each content entity type →
27. #2639686: Replace get('entity.manager')->getStorage() with get('entity_type.manager')->getStorage() in all tests →
28. #2599594: Multilingual content: Menu link is not correctly stored on translation. →
29. #2538228: Document that Config save/delete/rename events may be dispatched during hook_update_N(), what that means for subscribers, and fix core subscribers accordingly →
30. #2513586: Remove the word "positive" from the "Must include a positive keyword with three characters or more." error message →
31. #2500931: Views feed doesn't encode embedded HTML anymore →
32. #2500931: Views feed doesn't encode embedded HTML anymore →
33. #2419825: Make serialization_class optional →
34. #2389335: Deprecate entity.query service and replace with using the entity storage's getQuery() method →
35. #2347287: Provide a trait for setting messages →
36. #2342593: Remove mixed SSL support from core →
37. 🐛 Batch operation fails silently if an operation callback is not found Needs work
38. #2228393: Decouple session from cookie based user authentication →
39. 🐛 Xss::filterAdmin() incorrectly filters datetime attribute Fixed
40. 🐛 Leftover D10 deprecations in ajax.js Needs work
41. ✨ Make it easier for theme builders to enable Twig debugging and disable render cache Fixed
42. 🐛 Multiple usages of FieldPluginBase::getEntity do not check for NULL, leading to WSOD Fixed
43. 🐛 Correct vertical tab does not focus on form validation Fixed
44. 🐛 Attribute hreflang not allowed on element li at this point Needs review
45. 📌 Fork laminas/laminas-diactoros Fixed
46. 📌 Fork laminas/laminas-diactoros Fixed
47. 📌 Fork laminas/laminas-diactoros Fixed
48. ✨ Improve the Vocabulary edit form title Closed: duplicate
49. 📌 Drupal 9 uses PHP syntax that's deprecated in PHP 8.2, so exclude that from error_reporting() and DeprecationListenerTrait Fixed
50. 🐛 Views exposed form block options are not updated immediately when adding additional sorts, filters, etc (Caching?) Needs work
51. ✨ Add configurable description to content type title field. Needs work
52. 💬 Update aborted by system_post_update_sort_all_config. Drush command terminated abnormally. Output is empty. Postponed: needs info
53. 🐛 Fix regression caused by ::class constant Fixed
54. 🐛 Error: Call to a member function getConfigDependencyKey() on null in web/core/modules/taxonomy/src/Plugin/views/filter/TaxonomyIndexTid.php Postponed: needs info
55. 🐛 Layout builder does not protect against recursion Needs work
56. 📌 Allow multiple instances of the same exposed filter form on a single page Needs work
57. 🐛 Error: Call to a member function getConfigDependencyKey() on null in web/core/modules/taxonomy/src/Plugin/views/filter/TaxonomyIndexTid.php Postponed: needs info
58. 🐛 Drupal\Component\Utility\Html::normalize() leaves messy in certain situations Fixed
59. 🐛 Image Media thumbnail alt text cannot be changed without reuploading the image Needs work
60. ✨ Add Exception for TypeError Argument must be String in \Drupal\Component\Utility\Html escape{} Needs work
61. 🐛 strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated Needs work
62. 📌 Allow multiple instances of the same exposed filter form on a single page Needs work
63. 🐛 TimestampDatetimeWidget::massageFormValues does not allow NULL value Closed: works as designed
64. 🐛 Views hardcodes exposed filter block form ID's which breaks AJAX when the same form is shown multiple times on one page Needs review
65. 🐛 "Has taxonomy term" contextual filter does not take the language value into account Needs work
66. 🐛 Tabledrag is broken in layout builder sidebar Needs work
67. 🐛 Multiple usages of FieldPluginBase::getEntity do not check for NULL, leading to WSOD Fixed
68. 🐛 Remove sample date from date field error message and title attribute Fixed
69. 📌 Set SameSite on session cookies Fixed
70. 📌 Remove trailing slashes on void elements Closed: duplicate
71. 🐛 PHP 8.1 - Deprecated function: unserialize(): Passing null to parameter #1 ($data) of type string is deprecated in Drupal\Core\Entity\Sql\SqlContentEntityStorage->mapFromStorageRecords() Closed: duplicate
72. 🐛 Hide the "Publish Content" button if there are no changes to publish Needs work
73. ✨ Content moderations shows the state label instead of transition label on the default ModerationStateWidget Needs work
74. 📌 [PP-1] Expose Layout Builder data to REST and JSON:API Postponed
75. 🐛 CKEditor 5 isn't respecting field widgets row settings Fixed
76. 🐛 Installer does not warn the user that cookies must be enabled with the correct cookie domain (and fails when they aren't) Needs work
77. 🐛 TypeError: Cannot access offset of type string on string Needs work
78. ✨ Add support for OR in block visibility conditions Needs work
79. ✨ Add support for OR in block visibility conditions Needs work
80. 🐛 Undefined array key in prepareUpdateData Active
81. ✨ Allow book navigation title to be overridden by top-level node title Postponed
82. 🐛 [PP-1] Performance issues with path alias generated queries on PostgreSQL Postponed
83. 🐛 EntityMalformedException: Missing bundle property on entity of type node in entity_extract_ids() line 8097 Needs work
84. 📌 Allow synced Layout override Translations: translating labels and inline blocks Needs work
85. ✨ Allow book navigation title to be overridden by top-level node title Postponed
86. 🐛 CSRF check always fails for users without a session Needs work
87. 🐛 Warning: Undefined array key 1 in Drupal\Core\Asset\LibraryDependencyResolver->doGetDependencies() Closed: duplicate
88. 🐛 TypeError: key(): Argument #1 ($array) must be of type array, string given in key() Needs work
89. 🐛 TypeError: array_merge(): Argument #1 must be of type array, string given in array_merge() Needs work
90. 🐛 Deprecated function: Implicit conversion from float-string to int loses precision in Drupal\Component\Datetime\DateTimePlus Needs work
91. 📌 Review/update $adminTags variable for new html elements to be whitelisted Needs work
92. #2580473: Increase size of info column in system table. →
93. 🐛 Representative Node Views fails due to invalid SQL Needs work
94. 🐛 Illegal string offset 'value' in Drupal\views\Plugin\views\filter\NumericFilter Needs work
95. 🐛 Illegal string offset 'value' in Drupal\views\Plugin\views\filter\NumericFilter Needs work
96. 🐛 Deprecated function: strpos(): Passing null to parameter #1 ($haystack) of type string is deprecated in Drupal\views\Plugin\views\display\DisplayPluginBase Closed: cannot reproduce
97. 🐛 Batch operation fails silently if an operation callback is not found Needs work
98. 🐛 Enabling aggregation breaks views with "Moderation state" fields Needs work
99. ✨ Add a token for the site logo Needs work
100. 🐛 Twig LoaderError after upgrading Twig to 2.15.3 Closed: outdated

The top result from the list in #4 is an issue closed in 2016. Why are patches from this issue being downloaded? It there are more like this then it doesn't seem like this data is all that meaningful unfortunately.

Isn't it just a matter of filtering out duplicates and closed issues?

Could still be useful after that.

There are also a few duplicates, and only 86 unique issues.