Take 3 as this is the third investigation of holes.
Holes identified in T219301#5844113
>>! In T219301#5844113, @Addshore wrote:
> ```
> mysql:research@dbstore1005.eqiad.wmnet [wikidatawiki]> SELECT wbpt_property_id as id, wby_name as type, wbxl_language as language, wbx_text as text FROM wbt_property_terms LEFT JOIN wbt_term_in_ lang ON wbpt_term_in_lang_id = wbtl_id LEFT JOIN wbt_type ON wbtl_type_id = wby_id LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE wbx_text
> IS NULL;
> +------+-------+----------+------+
> | id | type | language | text |
> +------+-------+----------+------+
> | 7850 | alias | NULL | NULL |
> | 7786 | alias | NULL | NULL |
> | 7884 | alias | NULL | NULL |
> | 7885 | alias | NULL | NULL |
> | 1416 | alias | NULL | NULL |
> | 932 | alias | NULL | NULL |
> | 846 | alias | NULL | NULL |
> | 2326 | alias | NULL | NULL |
> | 590 | alias | NULL | NULL |
> | 1566 | alias | NULL | NULL |
> | 356 | alias | NULL | NULL |
> +------+-------+----------+------+
> 11 rows in set (6.33 sec)
> ```
>
> Checking this again today it appears there might still be one situation that is causing issue that we should investigate.