Hello team! I'm working on getting my environment...
# troubleshooting
j
Hello team! I'm working on getting my environment setup but am running into issues when attempting to use airflow with the postgres system db. I followed the steps in the documentation, first creating the Meltano project, then setting the database_uri parameter to my local postgres instance. I then installed the airflow as a utility and set the core executor and sql alchemy conn. However, when I attempt to run
meltano invoke airflow:initialize
I see the tables are created in the database but I get an error:
Copy code
alembic.util.exc.CommandError: Can't locate revision identified by '6828cc5b1a4f' cmd=airflow db init stdio_stream=stderr
                               cmd=airflow db init stdio_stream=stderr
error invoking airflow db init error_message=airflow db init failed returncode=1
I've dropped all the tables and tried again with the same results. I then created a new Meltano project and went through the process again in case I missed something, however the results are still the same. Has anyone else encountered this issue or know a solution?
👀 1
So I got it working by having the Meltano system db and the Airflow db separate instead of using the same db for both of them like I was trying originally. I'm assuming there was some sort of table name collisions or something when trying use the same db for both.
e
Ah, Airflow also uses Alembic to manage migrations it seems