CODEWITHSUNDEEP
airflowwarnings
Canovice
Canovice

Reputation: 10303

Airflow v2 warning No module named 'airflow.providers.mysql' despite not using this module

We recently upgraded from Airflow v1 to v2 and are currently debugging the new issues that come with such an upgrade. Currently we're getting the following warning message:

webserver_1  | [2021-08-21 18:13:45,565] {providers_manager.py:299} WARNING - Exception 
when importing 'airflow.providers.google.cloud.hooks.cloud_sql.CloudSQLHook' from 
'apache-airflow-providers-google' package: No module named 'airflow.providers.mysql'

I text-searched our entire project, and there are zero references of CloudSQLHook, zero references of apache-airflow-providers-google, and zero references of mysql... Because of this, we're not sure where to start with eliminating this warning message. How can we resolve this?

Upvotes: 0

Views: 1273

Answers (1)

Jarek Potiuk
Jarek Potiuk

Reputation: 20077

The Google provider has optional dependency on mysql (due to Cloud SQL using mysql as a backend). The easiest way to get rid of the warning is to install apache-airflow-providers-mysql package or use [mysql] extra when installing airflow. I also believe newer versions of airflow (quite sure 2.1+) will not log this as a warning.

Upvotes: 1

Related Questions