@lubosmj @iballou FYI: We at ATIX now have at least two internal systems that appear to be affected by this issue.
The systems in question are running foreman-3.5.3, katello-4.7.6, python39-pulpcore-3.21.17, and postgresql-12.15.
I have confirmed that this includes the change Enhance get_content() by omitting the version_membership lookup by lubosmj · Pull Request #4275 · pulp/pulpcore · GitHub
We are testing to see if reverting this change solves the issue.
Feel free to reach out if you have any questions or ideas.