zcattacz opened a new issue, #29259: URL: https://github.com/apache/airflow/issues/29259
### Apache Airflow version 2.5.1 ### What happened I was really new to airflow weeks ago (on 2.5.0 atm), installed airflow for local db sync task testing without celery/rapidmq. Airflow is setup with local postgresql 14 instance in schema `airflow`. I started with simple steps. With SequentialExecutor, tutorial task ran fine, then I decided use LocalExecutor. Things suddenly fell apart, the `ID None` exception starts to pops up, the tutorial dag simply fails all the time. But since the url logs flood anything else away really quick I didn't pay enough attention. At the same time, I saw the warning `Only works with the Celery, CeleryKubernetes or Kubernetes executors` on webUI when debugging in the diagram view, Then all my attention is diverted to running it with CeleryExecutor and rapidmq etc. As you can expect, even with rapidmq + celeryexecutor in place, things fail as usual, only SequentialExecutor works. `airflow tasks test tutorial` always works during the whole process. Since I am new, with every switching between executors the database is deliberately dropped to reset the setup. As I run down the settings one by one, I decided to not use `schema`. Then suddenly everything works as usual, even with LocalExecutor. The `ID None` behavior also applies to 2.5.1 ### What you think should happen instead LocalExecutor/CeleryExectuor should run fine like SequentialExecutor without `ID None` error. ### How to reproduce Install apache-airflow with contraint.txt for py3.9 into a venv folder run `airflow standalone`, stop it, cp $pyvenv/airflow/lib/python3.9/site-packages/airflow/example_dags/tutorial.py ~/airflow/dags/ edit `~/airflow/airflow.cfg`, set executor= LocalExecutor set database= `postgresql+psycopg2://postgres:[email protected]:5432/testdb1?application_name=airflow` set sql_alchemy_schema=airflow1 set load_example=False set load_default_connection to false sudo -u postgres; \c testdb1; create schema airflow1; \q restart airflow ### Operating System Debian 11.6 ### Versions of Apache Airflow Providers (airflow) user@localhost:~/repos/apach-airflow$ pip freeze|grep airflow apache-airflow==2.5.1 apache-airflow-providers-common-sql==1.3.2 apache-airflow-providers-ftp==3.3.0 apache-airflow-providers-http==4.1.0 apache-airflow-providers-imap==3.1.1 apache-airflow-providers-sqlite==3.3.1 ### Deployment Other ### Deployment details _No response_ ### Anything else _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
