Data integrity error: some hashes recorded as babel_source lack status in babel_source_status table
>>> [!note] Migrated issue
<!-- Drupal.org comment -->
<!-- Migrated from issue #3536782. -->
Reported by: [huzooka](https://www.drupal.org/user/281301)
Related to !22 !19
>>>
<h3 id="summary-problem-motivation">Steps to reproduce</h3>
<ol>
<li>Install Drupal with minimal profile: <code>drush si minimal -y</code></li>
<li>Enable Babel <code>drush en babel -y</code></li>
<li>Count the records with unique hashes in "babel_source": <code>SELECT COUNT(innerQuery.*) FROM (SELECT DISTINCT hash FROM babel_source) innerQuery</code>. On my system with the current core, this is 75.</li>
<li>Count the records with unique hashes in "babel_source_status": <code>SELECT COUNT(innerQuery.*) FROM (SELECT DISTINCT hash FROM babel_source_status) innerQuery</code>. On my system with the current core, this is 41.</li>
</ol>
<p>Without involving the UI translation (these are only configs), we have only config strings recorded so far, some of them have records, some of them don't.</p>
<h3 id="summary-proposed-resolution">Proposed resolution</h3>
<p>Find the cause and fix this integrity issue.<br>
Maybe, rethink how statuses are stored. Imho they should belong to a source rather than to a string + context pair.</p>
<h3 id="summary-remaining-tasks">Remaining tasks</h3>
<h3 id="summary-ui-changes">User interface changes</h3>
<h3 id="summary-api-changes">API changes</h3>
<p>TBD</p>
<h3 id="summary-data-model-changes">Data model changes</h3>
<p>TBD</p>
issue