Michael Bi
09/22/2025, 6:04 PMvisch
09/23/2025, 1:12 AMMichael Bi
09/23/2025, 1:28 PMvisch
09/23/2025, 6:45 PMI was using the meltano python wrapper to run the airflow containers with meltano, but the wrapper itself was causing issues by injecting logs into the airflow.cfg file, corrupting the file and causing the airflow containers to continuously crash.I don't think that's what happens to most folks, so sharing the issue you're running into can be helpful
Given this problem, I wanted to ask if people typically use the meltano python wrapper in prod to run airflow, or do they just run airflow without the meltano python wrapper.Run it how you want, Meltano is pretty easy to orchestrate yourself so that's what I do personally. I tried to count the other day how many orchestration systems I've setup Meltano on. Windows Task Scheduler, Crontab, SQL Agent Job's, Docker Containers ran via you name the place, Github Actions, Gitlab Actions, Prefect, Dagster, Amazon ECS, Google Cloud Run, Airflow, Snowflake containers Given all that experiance I actually recommend folks just spin up a VM, and schedule the stuff themselves with cron at first, unless their company already uses an orchestrator. It's so easy to run it's really not even worth an orchestrator so if your team uses gitlab or github, I'd just use gitlab / github CI/Actions. Anyway you're allowed to complicate it however you want to is the mode I operate on now!
Michael Bi
09/24/2025, 1:02 PMconfigparser.DuplicateSectionError: While reading from '/project/orchestrate/airflow/airflow.cfg' [line  5]: section '2025-09-23T23:21:54.954+0000' already exists cmd=airflow db init stdio_stream=stderr2025-09-23T23:21:54.954+0000files:
    - name: files-airflow
      variant: meltano
      pip_url: git+<https://github.com/meltano/files-airflow.git>
    utilities:
    - name: airflow
      variant: apache
      pip_url: git+<https://github.com/meltano/airflow-ext.git@main> apache-airflow==2.10.5
        psycopg2-binary --constraint 
        <https://raw.githubusercontent.com/apache/airflow/constraints-2.10.5/constraints-no-providers-${MELTANO__PYTHON_VERSION}.txt>
      config:
        core:
          dags_are_paused_at_creation: true
          executor: LocalExecutor
        webserver:
          web_server_port: 8080
        database:
          sql_alchemy_conn: <postgresql://postgres:postgres@airflow-metadata-db/airflow>Michael Bi
09/24/2025, 1:12 PMvisch
09/24/2025, 7:29 PMvisch
09/24/2025, 7:29 PMvisch
09/24/2025, 7:57 PMMichael Bi
09/24/2025, 11:02 PM