With a combination of failed and successful syncs, it is possible to have modulemd content with no artifact associated

[dralley]

Version
3.14, 3.17, possibly main branch

Describe the bug

With a combination of multiple failed and successful sync attempts on a repo like "Appstream 8", It may happen that, One or more artifacts related to modulemd metdata is physically missing from the filesystem. But if we check the pulpcore database, then the same artifact is having an artifact_id associated with it which means pulp thinks the file is alredy created\downloaded on the filesystem.

note from dalley: this means the artifact associated with modulemd content which stores the snippets

@pavelpicka This might cause problems for #2707

To Reproduce

See bugzilla for details

Expected behavior
This should never happen

Additional context
BZ: https://bugzilla.redhat.com/show_bug.cgi?id=2107701

[dralley]

Action item: determine whether this is something that can happen in normal usage, or if you need to do something weird, like cloning the database without copying the file storage.

If it is the latter, then this issue can be closed as not applicable.