search

thegraphnetwork / EpiGraphHub

Software platform to Gather, transmform, harmonize and store epidemiological data for analytical purposes.
https://epigraphhub.org
GNU General Public License v3.0
8 stars 10 forks source link

chore(superset): bump superset version to 2.* #195

Closed luabida closed 1 year ago

luabida commented 1 year ago

image

2023-08-23 20:47:18,936:WARNING:superset.db_engine_specs:Unable to load dialect <class 'sqlalchemy.dialects.mssql.pyodbc.MSDialect_pyodbc'>: libodbc.so.2: cannot open shared object file: No such file or directory
Unable to load dialect <class 'sqlalchemy.dialects.mssql.pyodbc.MSDialect_pyodbc'>: libodbc.so.2: cannot open shared object file: No such file or directory
2023-08-23 20:47:18,937:WARNING:superset.db_engine_specs:Unable to load dialect <class 'sqlalchemy.dialects.mssql.pyodbc.MSDialect_pyodbc'>: libodbc.so.2: cannot open shared object file: No such file or directory
Unable to load dialect <class 'sqlalchemy.dialects.mysql.pyodbc.MySQLDialect_pyodbc'>: libodbc.so.2: cannot open shared object file: No such file or directory
2023-08-23 20:47:18,940:WARNING:superset.db_engine_specs:Unable to load dialect <class 'sqlalchemy.dialects.mysql.pyodbc.MySQLDialect_pyodbc'>: libodbc.so.2: cannot open shared object file: No such file or directory
Unable to load dialect <class 'sqlalchemy.dialects.sybase.pyodbc.SybaseDialect_pyodbc'>: libodbc.so.2: cannot open shared object file: No such file or directory
2023-08-23 20:47:18,944:WARNING:superset.db_engine_specs:Unable to load dialect <class 'sqlalchemy.dialects.sybase.pyodbc.SybaseDialect_pyodbc'>: libodbc.so.2: cannot open shared object file: No such file or directory
Unable to load dialect <class 'sqlalchemy.dialects.sybase.pyodbc.SybaseDialect_pyodbc'>: libodbc.so.2: cannot open shared object file: No such file or directory
2023-08-23 20:47:18,944:WARNING:superset.db_engine_specs:Unable to load dialect <class 'sqlalchemy.dialects.sybase.pyodbc.SybaseDialect_pyodbc'>: libodbc.so.2: cannot open shared object file: No such file or directory
Unable to load SQLAlchemy dialect <class 'sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2'>: The 'enum34' distribution was not found and is required by the application
2023-08-23 20:47:19,032:WARNING:superset.db_engine_specs:Unable to load SQLAlchemy dialect <class 'sqlalchemy.dialects.postgresql.psycopg2.PGDialect_psycopg2'>: The 'enum34' distribution was not found and is required by the application
Unable to load SQLAlchemy dialect <class 'shillelagh.backends.apsw.dialects.safe.APSWSafeDialect'>: libodbc.so.2: cannot open shared object file: No such file or directory
2023-08-23 20:47:19,040:WARNING:superset.db_engine_specs:Unable to load SQLAlchemy dialect <class 'shillelagh.backends.apsw.dialects.safe.APSWSafeDialect'>: libodbc.so.2: cannot open shared object file: No such file or directory

fixed libodbc.so.2: cannot open shared object file

http://0.0.0.0:8088/superset/welcome/:

2023-08-23 20:58:05,121:WARNING:superset.views.base:HTTPException
Traceback (most recent call last):
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask/app.py", line 1517, in full_dispatch_request
    rv = self.dispatch_request()
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask/app.py", line 1503, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask/scaffold.py", line 322, in send_static_file
    return send_from_directory(
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask/helpers.py", line 676, in send_from_directory
    return werkzeug.utils.send_from_directory(  # type: ignore
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/werkzeug/utils.py", line 586, in send_from_directory
    raise NotFound()
werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again.
2023-08-23 20:58:05,123:INFO:werkzeug:172.21.0.1 - - [23/Aug/2023 20:58:05] "GET /static/appbuilder/css/font-awesome.min.css HTTP/1.1" 404 -

image image

luabida commented 1 year ago

ERROR w/ Flask-SQLAlchemy >= 3.0:

Traceback (most recent call last):
  File "/opt/conda/envs/epigraphhub/bin/superset", line 6, in <module>
    from superset.cli.main import superset
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/superset/__init__.py", line 21, in <module>
    from superset.app import create_app
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/superset/app.py", line 23, in <module>
    from superset.initialization import SupersetAppInitializer
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/superset/initialization/__init__.py", line 27, in <module>
    from flask_appbuilder import expose, IndexView
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask_appbuilder/__init__.py", line 5, in <module>
    from .api import ModelRestApi  # noqa: F401
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask_appbuilder/api/__init__.py", line 23, in <module>
    from flask_appbuilder.models.sqla import Model
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask_appbuilder/models/sqla/__init__.py", line 5, in <module>
    from flask_sqlalchemy import (
ImportError: cannot import name '_QueryProperty' from 'flask_sqlalchemy' (/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask_sqlalchemy/__init__.py)

ERROR w/ sqlalchemy >= 2.0

Traceback (most recent call last):
  File "/opt/conda/envs/epigraphhub/bin/superset", line 6, in <module>
    from superset.cli.main import superset
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/superset/__init__.py", line 21, in <module>
    from superset.app import create_app
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/superset/app.py", line 23, in <module>
    from superset.initialization import SupersetAppInitializer
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/superset/initialization/__init__.py", line 33, in <module>
    from superset.extensions import (
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/superset/extensions/__init__.py", line 119, in <module>
    db = SQLA()
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask_sqlalchemy/__init__.py", line 758, in __init__
    _include_sqlalchemy(self, query_class)
  File "/opt/conda/envs/epigraphhub/lib/python3.9/site-packages/flask_sqlalchemy/__init__.py", line 112, in _include_sqlalchemy
    for key in module.__all__:
AttributeError: module 'sqlalchemy' has no attribute '__all__'

Fixed by pinning deps