airflow-init is stuck

[WanPi13]

When I deployed Airflow (version 3.1.7) managed by MySQL in Docker, executing "docker-compose up airflow-init" would get stuck at the creation of the fab-related tables. The MySQL process reported: CREATE TABLE alembic_version_fab (
        version_num VARCHAR(32) NOT NULL, 
        CONSTRAINT alembic_version_f
Currently, it is in the state of "Waiting for table metadata lock".
Could you please tell me how to solve this problem?

[potiuk]

I think you might have some long running operation that has not completed and is hanging - what exactly it is, hard to say - but you need to find the transaction the causes it and kill it.

There are a number of articles you can find that can guide you there https://stackoverflow.com/questions/13148630/how-do-i-find-which-transaction-is-causing-a-waiting-for-table-metadata-lock-s and https://dba.stackexchange.com/questions/195018/mysql-safe-to-kill-transaction-that-is-stuck-in-waiting-for-table-metadata-loc