You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2022/12/15 05:19:55 UTC
[GitHub] [airflow] ChandelAnushka opened a new issue, #28373: Webserver IntegrityError When Loaded
ChandelAnushka opened a new issue, #28373:
URL: https://github.com/apache/airflow/issues/28373
### Apache Airflow version
Other Airflow 2 version (please specify below)
### What happened
**Airflow version: 2.4.3**
I just upgraded from Airflow 2.1.2 to 2.4.3. Whenever I load the webserver, it gives the following errors in webserver.log and doesnt load the application.
```
File "/a/lib/python3.7/site-packages/flask_session/sessions.py", line 578, in save_session
self.db.session.commit()
File "<string>", line 2, in commit
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 1428, in commit
self._transaction.commit(_to_root=self.future)
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 829, in commit
self._prepare_impl()
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 808, in _prepare_impl
self.session.flush()
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 3339, in flush
self._flush(objects)
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 3479, in _flush
transaction.rollback(_capture_exception=True)
File "/a/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 72, in __exit__
with_traceback=exc_tb,
File "/a/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 3439, in _flush
flush_context.execute()
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 456, in execute
rec.execute(self)
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 633, in execute
uow,
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 247, in save_obj
insert,
File "/a/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 1222, in _emit_insert_statements
execution_options=execution_options,
File "/a/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1611, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/a/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 324, in _execute_on_connection
self, multiparams, params, execution_options
File "/a/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1488, in _execute_clauseelement
cache_hit=cache_hit,
File "/a/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1843, in _execute_context
e, statement, parameters, cursor, context
File "/a/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2024, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/a/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/a/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1800, in _execute_context
cursor, statement, parameters, context
File "/a/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 717, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "session_session_id_key"
DETAIL: Key (session_id)=(249cba6d-7fdf-4788-9a96-3bbe0b61012e) already exists.
[SQL: INSERT INTO session (session_id, data, expiry) VALUES (%(session_id)s, %(data)s, %(expiry)s) RETURNING session.id]
[parameters: {'session_id': '249cba6d-7fdf-4788-9a96-3bbe0b61012e', 'data': <psycopg2.extensions.Binary object at 0x7f773a397420>, 'expiry': datetime.datetime(2022, 12, 15, 4, 29, 42, 513681, tzinfo=datetime.timezone.utc)}]
```
### What you think should happen instead
The webserver should display the normal login page without any errors.
### How to reproduce
We are using 'airflow.www.security.AirflowSecurityManager' as our FAB_SECURITY_MANAGER_CLASS in the webserver_config.py. We are currently running Airflow 2.4.3. We are also using a postgres external database as our metadata db.
### Operating System
Mac OS Monterey
### Versions of Apache Airflow Providers
apache-airflow-providers-amazon==6.0.0
apache-airflow-providers-apache-hive==4.0.1
apache-airflow-providers-apache-spark==3.0.0
apache-airflow-providers-celery==3.1.0
apache-airflow-providers-common-sql==1.3.1
apache-airflow-providers-ftp==3.2.0
apache-airflow-providers-http==4.0.0
apache-airflow-providers-imap==3.1.0
apache-airflow-providers-papermill==3.1.0
apache-airflow-providers-postgres==5.2.0
apache-airflow-providers-redis==3.1.0
apache-airflow-providers-sqlite==3.3.1
apache-airflow-providers-ssh==3.3.0
### Deployment
Virtualenv installation
### 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
[GitHub] [airflow] ChandelAnushka commented on issue #28373: Webserver IntegrityError When Loaded
Posted by GitBox <gi...@apache.org>.
ChandelAnushka commented on issue #28373:
URL: https://github.com/apache/airflow/issues/28373#issuecomment-1358825133
Update
--
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
[GitHub] [airflow] ChandelAnushka closed issue #28373: Webserver IntegrityError When Loaded
Posted by GitBox <gi...@apache.org>.
ChandelAnushka closed issue #28373: Webserver IntegrityError When Loaded
URL: https://github.com/apache/airflow/issues/28373
--
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
[GitHub] [airflow] tirkarthi commented on issue #28373: Webserver IntegrityError When Loaded
Posted by GitBox <gi...@apache.org>.
tirkarthi commented on issue #28373:
URL: https://github.com/apache/airflow/issues/28373#issuecomment-1356722396
Similar report : https://github.com/apache/airflow/discussions/28099
--
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