Unable to access UI locally: Internal Server Error

[pablomc87]

Hello everyone:
I have a project I'm working on locally, and I've followed the Running Airflow in Docker documentation, but I've come across a problem I didn't have a couple of weeks ago.
I'm using the docker compose yml from the documentation with some tweaks to add kafka and adding some schemas to the postgres database. I don't think these tweaks affect my airflow configuration.
It looks like everything works fine except for the webserver UI, that throws an Internal Server Error when I try to acces it and the logs look like this:

airflow-webserver-1  | [2024-08-24T21:01:47.413+0000] {app.py:1744} ERROR - Exception on /home [GET]
airflow-webserver-1  | Traceback (most recent call last):
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask/app.py", line 2528, in wsgi_app
airflow-webserver-1  |     ctx.push()
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask/ctx.py", line 375, in push
airflow-webserver-1  |     self.session = session_interface.open_session(self.app, self.request)
airflow-webserver-1  |                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask_session/sessions.py", line 525, in open_session
airflow-webserver-1  |     if saved_session and saved_session.expiry <= datetime.utcnow():
airflow-webserver-1  |                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  | TypeError: can't compare offset-naive and offset-aware datetimes
airflow-webserver-1  | [2024-08-24 21:01:47 +0000] [41] [ERROR] Error handling request /home
airflow-webserver-1  | Traceback (most recent call last):
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask/app.py", line 2528, in wsgi_app
airflow-webserver-1  |     ctx.push()
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask/ctx.py", line 375, in push
airflow-webserver-1  |     self.session = session_interface.open_session(self.app, self.request)
airflow-webserver-1  |                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask_session/sessions.py", line 525, in open_session
airflow-webserver-1  |     if saved_session and saved_session.expiry <= datetime.utcnow():
airflow-webserver-1  |                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  | TypeError: can't compare offset-naive and offset-aware datetimes
airflow-webserver-1  | 
airflow-webserver-1  | During handling of the above exception, another exception occurred:
airflow-webserver-1  | 
airflow-webserver-1  | Traceback (most recent call last):
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/gunicorn/workers/sync.py", line 134, in handle
airflow-webserver-1  |     self.handle_request(listener, req, client, addr)
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/gunicorn/workers/sync.py", line 177, in handle_request
airflow-webserver-1  |     respiter = self.wsgi(environ, resp.start_response)
airflow-webserver-1  |                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask/app.py", line 2552, in __call__
airflow-webserver-1  |     return self.wsgi_app(environ, start_response)
airflow-webserver-1  | 172.28.0.1 - - [24/Aug/2024:21:01:47 +0000] "GET /home HTTP/1.1" 500 0 "-" "-"
airflow-webserver-1  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask/app.py", line 2532, in wsgi_app
airflow-webserver-1  |     response = self.handle_exception(e)
airflow-webserver-1  |                ^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask/app.py", line 1727, in handle_exception
airflow-webserver-1  |     server_error = self.ensure_sync(handler)(server_error)
airflow-webserver-1  |                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/airflow/www/views.py", line 702, in show_traceback
airflow-webserver-1  |     is_logged_in = get_auth_manager().is_logged_in()
airflow-webserver-1  |                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/airflow/providers/fab/auth_manager/fab_auth_manager.py", line 183, in is_logged_in
airflow-webserver-1  |     return not self.get_user().is_anonymous
airflow-webserver-1  |                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/werkzeug/local.py", line 316, in __get__
airflow-webserver-1  |     obj = instance._get_current_object()
airflow-webserver-1  |           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/werkzeug/local.py", line 520, in _get_current_object
airflow-webserver-1  |     return get_name(local())  # type: ignore
airflow-webserver-1  |                     ^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask_login/utils.py", line 25, in <lambda>
airflow-webserver-1  |     current_user = LocalProxy(lambda: _get_user())
airflow-webserver-1  |                                       ^^^^^^^^^^^
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask_login/utils.py", line 370, in _get_user
airflow-webserver-1  |     current_app.login_manager._load_user()
airflow-webserver-1  |   File "/home/airflow/.local/lib/python3.12/site-packages/flask_login/login_manager.py", line 362, in _load_user
airflow-webserver-1  |     user_id = session.get("_user_id")
airflow-webserver-1  |               ^^^^^^^^^^^
airflow-webserver-1  | AttributeError: 'NoneType' object has no attribute 'get'

I have checked the logs from the init and the base airflow user is created, and it is also in its table in postgres.
I'm not sure what could be wrong here, I'd appreciate any help.

[pablomc87]

I still can't fix this. Can anyone at least tell me any more information they'd need to guide me through a solution?

[potiuk]

Looks like you've some problem with database date missing timezone. No idea where it could be from - likely your modificatoins were not as innocent as you thought.

My suggestion: start from scratch, use clean DB, install latest airflow. And attempt to do whatever customizations you've done one-by-one checking if thngs still work after every change.

[pablomc87]

Thank you. I had tried doing that but it looks like I wasn't starting enough from scratch. It worked last time.
I'll try and document my modifications (that I need) to see which is the one causing the problem.

[pablomc87]

Hi! Just to update: I ended up setting another postgres instance in my docker compose for metabase, which was changing the public schema of the other database. Thank you again!