You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "habibutsu (via GitHub)" <gi...@apache.org> on 2024/01/19 04:31:57 UTC
[I] TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments [airflow]
habibutsu opened a new issue, #36883:
URL: https://github.com/apache/airflow/issues/36883
### Apache Airflow version
2.8.0
### If "Other Airflow 2 version" selected, which one?
_No response_
### What happened?
airflow is not started
### What you think should happen instead?
_No response_
### How to reproduce
Install the latest version of Airflow. In the new release [Flask-Session==0.6.0](https://pypi.org/project/Flask-Session/0.6.0/) has introduced backward-incompatible [changes](https://github.com/pallets-eco/flask-session/blob/0.6.1rc1/src/flask_session/sessions.py#L559)
### Operating System
Linux/docker
### Versions of Apache Airflow Providers
_No response_
### Deployment
Official Apache Airflow Helm Chart
### 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: commits-unsubscribe@airflow.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on issue #36883:
URL: https://github.com/apache/airflow/issues/36883#issuecomment-1959709549
Use constaints to install airflow : https://airflow.apache.org/docs/apache-airflow/stable/installation/installing-from-pypi.html
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments [airflow]
Posted by "aiqc (via GitHub)" <gi...@apache.org>.
aiqc commented on issue #36883:
URL: https://github.com/apache/airflow/issues/36883#issuecomment-1959728703
@potiuk thanks. couldn't the airflow and python versions be inferred at runtime instead of pushing that complexity onto the user? in situations where a constraint file(s) is not defined, couldn't an error be raised?
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments [airflow]
Posted by "Taragolis (via GitHub)" <gi...@apache.org>.
Taragolis commented on issue #36883:
URL: https://github.com/apache/airflow/issues/36883#issuecomment-1900518098
We noticed that when if failed in our CI and this is fine when new version package breaks something.
- Temporary we upper bound limit it by https://github.com/apache/airflow/pull/36895
- The target solution could be tracked in: https://github.com/apache/airflow/issues/36897
For end users there the base recommendation is follow:
- [Installation of Airflowâ„¢](https://airflow.apache.org/docs/apache-airflow/stable/installation/index.html#using-pypi)
- [[Reminder] How to reproducibly install Airflow](https://lists.apache.org/thread/b8q1t3pvtky7y7mb2kjt4r2bz5bvz8qy)
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments [airflow]
Posted by "SaadTPTW (via GitHub)" <gi...@apache.org>.
SaadTPTW commented on issue #36883:
URL: https://github.com/apache/airflow/issues/36883#issuecomment-1948323165
the use of the installation on the official website using the constraints.txt + the command airflow standalone solve the problem
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments [airflow]
Posted by "aiqc (via GitHub)" <gi...@apache.org>.
aiqc commented on issue #36883:
URL: https://github.com/apache/airflow/issues/36883#issuecomment-1959645672
Ran into this on a fresh install today
I'm using 3.8 because that's what PyPI says: "Requires: Python <3.12, ~=3.8"
```
pip show apache-airflow
Name: apache-airflow
Version: 2.8.1
python --version
Python 3.8.18
lsb_release -a
Description: Ubuntu 22.04.3 LTS
Release: 22.04
Codename: jammy
```
## Steps to reproduce
Setup
```bash
conda create -n pipeline python=3.8.18
conda activate pipeline
pip install apache-airflow
airflow db init
```
Produces the following output
```
/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/cli/commands/db_command.py:47 DeprecationWarning: `db init` is deprecated. Use `db migrate` instead to migrate the db and/or airflow connections create-default-connections to create the default connections
DB: sqlite:////home/layne/airflow/airflow.db
[2024-02-22T09:57:42.303-0500] {migration.py:216} INFO - Context impl SQLiteImpl.
[2024-02-22T09:57:42.304-0500] {migration.py:219} INFO - Will assume non-transactional DDL.
Traceback (most recent call last):
File "/home/layne/anaconda3/envs/pipeline/bin/airflow", line 8, in <module>
sys.exit(main())
File "/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/__main__.py", line 57, in main
args.func(args)
File "/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/cli/cli_config.py", line 49, in command
return func(*args, **kwargs)
File "/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/utils/providers_configuration_loader.py", line 55, in wrapped_function
return func(*args, **kwargs)
File "/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/cli/commands/db_command.py", line 53, in initdb
db.initdb()
File "/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/utils/session.py", line 79, in wrapper
return func(*args, session=session, **kwargs)
File "/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/utils/db.py", line 733, in initdb
_create_db_from_orm(session=session)
File "/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/utils/db.py", line 718, in _create_db_from_orm
_create_flask_session_tbl(engine.url)
File "/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/utils/db.py", line 711, in _create_flask_session_tbl
db = _get_flask_db(sql_database_uri)
File "/home/layne/anaconda3/envs/pipeline/lib/python3.8/site-packages/airflow/utils/db.py", line 700, in _get_flask_db
AirflowDatabaseSessionInterface(app=flask_app, db=db, table="session", key_prefix="")
TypeError: __init__() missing 6 required positional arguments: 'sequence', 'schema', 'bind_key', 'use_signer', 'permanent', and 'sid_length'
```
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on issue #36883:
URL: https://github.com/apache/airflow/issues/36883#issuecomment-1959730859
@potiuk thanks. couldn't the airflow and python versions be inferred at runtime instead of pushing that complexity onto the user? in situations where a constraint file(s) is not defined, couldn't an error be raised?
No and No
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments [airflow]
Posted by "potiuk (via GitHub)" <gi...@apache.org>.
potiuk commented on issue #36883:
URL: https://github.com/apache/airflow/issues/36883#issuecomment-1959735898
And the reason for both is explained in the link I posted. You can also watch my presentation from Airlfow Summit if you want to know all the technical details https://airflowsummit.org/sessions/2023/mastering-dependencies-the-airflow-way/
Those two sources go into deep dive why the answer for both your questions is no.
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments [airflow]
Posted by "Taragolis (via GitHub)" <gi...@apache.org>.
Taragolis closed issue #36883: TypeError: SqlAlchemySessionInterface.__init__() missing 6 required positional arguments
URL: https://github.com/apache/airflow/issues/36883
--
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: commits-unsubscribe@airflow.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org