| Ladsgroup | |
| Jul 8 2025, 11:36 AM2025-07-08 11:36:58 (UTC+0) |
We currently check for tables catalog and ignore the "database", "dblist" and so on. It is important to look in dbs to make sure tables exist only where they are supposed to. For example, we had cases of FlaggedRevs uninstalled in frwiki but tables were not fully dropped.
P78808 is the original script running on stat machines.
| 1 | table exists where it should not: flaggedpage_config frwiki |
|---|---|
| 2 | table exists where it should not: flaggedpages frwiki |
| 3 | table exists where it should not: flaggedrevs frwiki |
| 4 | table exists where it should not: flaggedrevs_promote frwiki |
| 5 | table exists where it should not: flaggedrevs_statistics frwiki |
| 6 | table exists where it should not: flaggedrevs_tracking frwiki |
| 7 | table exists where it should not: thread labswiki |
| 8 | table exists where it should not: thread_history labswiki |
| 9 | table exists where it should not: thread_pending_relationship labswiki |
| 10 | table exists where it should not: thread_reaction labswiki |
| 11 | table exists where it should not: user_message_state labswiki |
| 12 | table exists where it should not: cn_assignments idwikivoyage |
| 13 | table exists where it should not: cn_known_devices idwikivoyage |
| 14 | table exists where it should not: cn_known_mobile_carriers idwikivoyage |
| 15 | table exists where it should not: cn_notice_countries idwikivoyage |
| 16 | table exists where it should not: cn_notice_languages idwikivoyage |
| 17 | table exists where it should not: cn_notice_log idwikivoyage |
| 18 | table exists where it should not: cn_notice_mixin_params idwikivoyage |
| 19 | table exists where it should not: cn_notice_mixins idwikivoyage |
| 20 | table exists where it should not: cn_notice_mobile_carriers idwikivoyage |
| 21 | table exists where it should not: cn_notice_regions idwikivoyage |
| 22 | table exists where it should not: cn_notices idwikivoyage |
| 23 | table exists where it should not: cn_template_devices idwikivoyage |
| 24 | table exists where it should not: cn_template_log idwikivoyage |
| 25 | table exists where it should not: cn_template_mixins idwikivoyage |
| 26 | table exists where it should not: cn_templates idwikivoyage |
| 27 | table exists where it should not: globalimagelinks idwikivoyage |
| 28 | table exists where it should not: cn_assignments kncwiki |
| 29 | table exists where it should not: cn_known_devices kncwiki |
| 30 | table exists where it should not: cn_known_mobile_carriers kncwiki |
| 31 | table exists where it should not: cn_notice_countries kncwiki |
| 32 | table exists where it should not: cn_notice_languages kncwiki |
| 33 | table exists where it should not: cn_notice_log kncwiki |
| 34 | table exists where it should not: cn_notice_mixin_params kncwiki |
| 35 | table exists where it should not: cn_notice_mixins kncwiki |
| 36 | table exists where it should not: cn_notice_mobile_carriers kncwiki |
| 37 | table exists where it should not: cn_notice_regions kncwiki |
| 38 | table exists where it should not: cn_notices kncwiki |
| 39 | table exists where it should not: cn_template_devices kncwiki |
| 40 | table exists where it should not: cn_template_log kncwiki |
| 41 | table exists where it should not: cn_template_mixins kncwiki |
| 42 | table exists where it should not: cn_templates kncwiki |
| 43 | table exists where it should not: globalimagelinks kncwiki |
| 44 | table exists where it should not: cn_assignments satwiktionary |
| 45 | table exists where it should not: cn_known_devices satwiktionary |
| 46 | table exists where it should not: cn_known_mobile_carriers satwiktionary |
| 47 | table exists where it should not: cn_notice_countries satwiktionary |
| 48 | table exists where it should not: cn_notice_languages satwiktionary |
| 49 | table exists where it should not: cn_notice_log satwiktionary |
| 50 | table exists where it should not: cn_notice_mixin_params satwiktionary |
| 51 | table exists where it should not: cn_notice_mixins satwiktionary |
| 52 | table exists where it should not: cn_notice_mobile_carriers satwiktionary |
| 53 | table exists where it should not: cn_notice_regions satwiktionary |
| 54 | table exists where it should not: cn_notices satwiktionary |
| 55 | table exists where it should not: cn_template_devices satwiktionary |
| 56 | table exists where it should not: cn_template_log satwiktionary |
| 57 | table exists where it should not: cn_template_mixins satwiktionary |
| 58 | table exists where it should not: cn_templates satwiktionary |
| 59 | table exists where it should not: globalimagelinks satwiktionary |
| 60 | table exists where it should not: cn_assignments sylwiki |
| 61 | table exists where it should not: cn_known_devices sylwiki |
| 62 | table exists where it should not: cn_known_mobile_carriers sylwiki |
| 63 | table exists where it should not: cn_notice_countries sylwiki |
| 64 | table exists where it should not: cn_notice_languages sylwiki |
| 65 | table exists where it should not: cn_notice_log sylwiki |
| 66 | table exists where it should not: cn_notice_mixin_params sylwiki |
| 67 | table exists where it should not: cn_notice_mixins sylwiki |
| 68 | table exists where it should not: cn_notice_mobile_carriers sylwiki |
| 69 | table exists where it should not: cn_notice_regions sylwiki |
| 70 | table exists where it should not: cn_notices sylwiki |
| 71 | table exists where it should not: cn_template_devices sylwiki |
| 72 | table exists where it should not: cn_template_log sylwiki |
| 73 | table exists where it should not: cn_template_mixins sylwiki |
| 74 | table exists where it should not: cn_templates sylwiki |
| 75 | table exists where it should not: globalimagelinks sylwiki |
| 76 | table exists where it should not: cn_assignments tigwiki |
| 77 | table exists where it should not: cn_known_devices tigwiki |
| 78 | table exists where it should not: cn_known_mobile_carriers tigwiki |
| 79 | table exists where it should not: cn_notice_countries tigwiki |
| 80 | table exists where it should not: cn_notice_languages tigwiki |
| 81 | table exists where it should not: cn_notice_log tigwiki |
| 82 | table exists where it should not: cn_notice_mixin_params tigwiki |
| 83 | table exists where it should not: cn_notice_mixins tigwiki |
| 84 | table exists where it should not: cn_notice_mobile_carriers tigwiki |
| 85 | table exists where it should not: cn_notice_regions tigwiki |
| 86 | table exists where it should not: cn_notices tigwiki |
| 87 | table exists where it should not: cn_template_devices tigwiki |
| 88 | table exists where it should not: cn_template_log tigwiki |
| 89 | table exists where it should not: cn_template_mixins tigwiki |
| 90 | table exists where it should not: cn_templates tigwiki |
| 91 | table exists where it should not: globalimagelinks tigwiki |
| 92 | table exists where it should not: revsrc aswikisource |
| 93 | table exists where it should not: srcwork aswikisource |
| 94 | table exists where it should not: swsite aswikisource |
| 95 | table exists where it should not: flaggedpage_config bawiki |
| 96 | table exists where it should not: flaggedpages bawiki |
| 97 | table exists where it should not: flaggedrevs bawiki |
| 98 | table exists where it should not: flaggedrevs_promote bawiki |
| 99 | table exists where it should not: flaggedrevs_statistics bawiki |
| 100 | table exists where it should not: flaggedrevs_tracking bawiki |
| 101 | table exists where it should not: pr_index frrwiki |
| 102 | table exists where it should not: wikilove_log hiwikisource |
| 103 | table exists where it should not: oauth2_access_tokens mediawikiwiki |
| 104 | table exists where it should not: oauth_accepted_consumer mediawikiwiki |
| 105 | table exists where it should not: oauth_registered_consumer mediawikiwiki |
| 106 | table exists where it should not: revtag officewiki |
| 107 | table exists where it should not: translate_cache officewiki |
| 108 | table exists where it should not: translate_groupreviews officewiki |
| 109 | table exists where it should not: translate_groupstats officewiki |
| 110 | table exists where it should not: translate_message_group_subscriptions officewiki |
| 111 | table exists where it should not: translate_messageindex officewiki |
| 112 | table exists where it should not: translate_metadata officewiki |
| 113 | table exists where it should not: translate_reviews officewiki |
| 114 | table exists where it should not: translate_sections officewiki |
| 115 | table exists where it should not: translate_translatable_bundles officewiki |
| 116 | table exists where it should not: flaggedpage_config siwiki |
| 117 | table exists where it should not: flaggedpages siwiki |
| 118 | table exists where it should not: flaggedrevs siwiki |
| 119 | table exists where it should not: flaggedrevs_promote siwiki |
| 120 | table exists where it should not: flaggedrevs_statistics siwiki |
| 121 | table exists where it should not: flaggedrevs_tracking siwiki |
| 122 | table exists where it should not: pr_index sourceswiki |
| 123 | table exists where it should not: pr_index test2wiki |
| 124 | table exists where it should not: wikifunctionsclient_usage test2wiki |
| 125 | table exists where it should not: thread wikimania2011wiki |
| 126 | table exists where it should not: thread_history wikimania2011wiki |
| 127 | table exists where it should not: user_message_state wikimania2011wiki |
They are mostly either: 1- Undeployed extension in one wiki (e.g. flaggedrevs in frwiki) or 2- T397348: addWiki.php create tables it should not
Mentioned in SAL (#wikimedia-operations) [2025-07-29T11:56:46Z] <Amir1> dropping flaggedrevs tables in frwiki, bawiki, siwiki (T398944)