I am trying to deploy an airflow worker who points to the main airflow host, the problem is I am getting this error, I already tried airflow update db
or airflow reset db
but no luck, how to fix it?
version: '3'
services:
airflow-worker:
image: apache/airflow:latest
environment:
- AIRFLOW__CORE__EXECUTOR=CeleryExecutor
- AIRFLOW__CORE__SQL_ALCHEMY_CONN=postgresql+psycopg2://airflow:yourpassword@<postgres_server_ip>:5432/airflow
- AIRFLOW__CELERY__RESULT_BACKEND=db+postgresql://airflow:yourpassword@<postgres_server_ip>:5432/airflow
- AIRFLOW__CELERY__BROKER_URL=redis://<redis_server_ip>:6379/0
command: airflow celery worker