Create member tables has missing dependency between communities and requests

[jurajtrappl]

Package version (if known): 4.1.2

Describe the bug

There is a missing dependency between request_metadata and invenio communities db tables.
The bug happens when I try to create member tables (fbe746957cfc_create_member_tables.py). Therefore the process is not able to create the FK fk_communities_members_request_id_request_metadata.

Steps to Reproduce

It is non-deterministic and depends on the alembic entrypoints load order (communities and then requests or vice versa)

Additional context

Workaround:
Use the revision a14fa442680f and then upgrade heads.

pipenv run invenio alembic upgrade a14fa442680f
pipenv run invenio alembic upgrade heads