Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Joe Bordes
    @joebordes
    and again with the other unhealthy one
    AhmetKahyaoglu
    @AhmetKahyaoglu
    I am trying
    AhmetKahyaoglu
    @AhmetKahyaoglu
    I tried, the result did not change.
    Screen log ;
    superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    supersetapp | util.raise(
    supersetapp | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise
    superset_app | raise exception
    superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    superset_app | self.dialect.do_execute(
    superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    superset_app | cursor.execute(statement, parameters)
    superset_app | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) relation "ab_permission_view_role" does not exist
    superset_app | LINE 2: FROM ab_permission_view JOIN ab_permission_view_role ON ab_p...
    superset_app | ^
    superset_app |
    superset_app | [SQL: SELECT ab_permission_view.id AS ab_permission_view_id, ab_permission_view.permission_id AS ab_permission_view_permission_id, ab_permission_view.view_menu_id AS ab_permission_view_view_menu_id
    superset_app | FROM ab_permission_view JOIN ab_permission_view_role ON ab_permission_view.id = ab_permission_view_role.permission_view_id JOIN ab_role ON ab_role.id = ab_permission_view_role.role_id JOIN ab_permission ON ab_permission.id = ab_permission_view.permission_id JOIN ab_view_menu ON ab_view_menu.id = ab_permission_view.view_menu_id
    superset_app | WHERE ab_permission.name = %(name_1)s AND ab_role.id IN (%(id_1)s)]
    superset_app | [parameters: {'name_1': 'menu_access', 'id_1': 2}]
    superset_app | (Background on this error at: http://sqlalche.me/e/13/f405)
    superset_app | 172.18.0.1 - - [07/Mar/2022:15:09:19 +0000] "GET /login/ HTTP/1.1" 500 0 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0"
    superset_app | 127.0.0.1 - - [07/Mar/2022:15:09:35 +0000] "GET /health HTTP/1.1" 200 2 "-" "curl/7.74.0"
    superset_worker_beat | [2022-03-07 15:10:00,030: INFO/MainProcess] Scheduler: Sending due task reports.scheduler (reports.scheduler)
    docker status ;
    [root@ereteam ~]# docker ps
    CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
    1991ec6e9bd3 apache/superset:latest-dev "/app/docker/docker-…" 26 minutes ago Up 26 minutes (unhealthy) 8088/tcp superset_worker
    80e0e565f0f3 apache/superset:latest-dev "/app/docker/docker-…" 26 minutes ago Up 26 minutes (healthy) 0.0.0.0:8088->8088/tcp, :::8088->8088/tcp superset_app
    b2a151609df5 apache/superset:latest-dev "/app/docker/docker-…" 26 minutes ago Up 26 minutes (unhealthy) 8088/tcp superset_worker_beat
    a4df52b39dba postgres:10 "docker-entrypoint.s…" 26 minutes ago Up 26 minutes 5432/tcp superset_db
    27baf7be3eef redis:latest "docker-entrypoint.s…" 26 minutes ago Up 26 minutes 6379/tcp superset_cache
    [root@ereteam ~]# docker stop 1991ec6e9bd3
    1991ec6e9bd3
    [root@ereteam ~]# docker ps
    CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
    80e0e565f0f3 apache/superset:latest-dev "/app/docker/docker-…" About an hour ago Up About an hour (healthy) 0.0.0.0:8088->8088/tcp, :::8088->8088/tcp superset_app
    b2a151609df5 apache/superset:latest-dev "/app/docker/docker-…" About an hour ago Up About an hour (unhealthy) 8088/tcp superset_worker_beat
    a4df52b39dba postgres:10 "docker-entrypoint.s…" About an hour ago Up About an hour 5432/tcp superset_db
    27baf7be3eef redis:latest "docker-entrypoint.s…" About an hour ago Up About an hour 6379/tcp superset_cache
    [root@ereteam ~]#
    Joe Bordes
    @joebordes
    try accessing the IP directly
    docker inspect 80e0e565f0f3
    get the IP of the container and access directly http://{ip}:8088
    AhmetKahyaoglu
    @AhmetKahyaoglu
    Hello,
    Good morning everybody. I couldn't access from Docker IP's either. Anyone have any other suggestions? It's a critical issue for me. :/
    AhmetKahyaoglu
    @AhmetKahyaoglu
    CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
    1991ec6e9bd3 apache/superset:latest-dev "/app/docker/docker-…" 17 hours ago Up 5 minutes (unhealthy) 8088/tcp superset_worker
    80e0e565f0f3 apache/superset:latest-dev "/app/docker/docker-…" 17 hours ago Up 5 minutes (healthy) 0.0.0.0:8088->8088/tcp, :::8088->8088/tcp superset_app
    b2a151609df5 apache/superset:latest-dev "/app/docker/docker-…" 17 hours ago Up 4 minutes (unhealthy) 8088/tcp superset_worker_beat
    a4df52b39dba postgres:10 "docker-entrypoint.s…" 17 hours ago Up 5 minutes 5432/tcp superset_db
    27baf7be3eef redis:latest "docker-entrypoint.s…" 17 hours ago Up 5 minutes 6379/tcp superset_cache
    AhmetKahyaoglu
    @AhmetKahyaoglu
    Hello everyone, @joebordes I solved the problem. I leave the link below.
    Thanks for your support.
    Joe Bordes
    @joebordes
    great!!
    have a wonderful day
    salah alhashmi
    @alguerocode

    All-In-One, free resources and collections related to javascript. we provide useful links to help you learn JavaScript, web development and other related stuff along with some of the best resources available online.

    https://github.com/devSupporters/masterJS

    di-coder
    @di-coder
    Hi All, I have enabled the ALERT_REPORTS feature and also configured SMTP. The scheduler is working properly but I don't receive any emails.
    Can any help ???
    EMAIL_NOTIFICATIONS = True # all the emails are sent using dryrun
    SMTP_HOST = "smtp.gmail.com"
    SMTP_STARTTLS = True
    SMTP_SSL = False
    SMTP_USER = "XXXXXXX"
    SMTP_PORT = 587
    SMTP_PASSWORD = "XXXXXXX"
    SMTP_MAIL_FROM = "XXXXXXX"
    ALERT_REPORTS = TRUE
    ilex
    @ilex:oakforest.in
    [m]
    @di-coder: did you try with port 465, SSL true and STARTTLS false?
    di-coder
    @di-coder
    Okay Sure I'll Check.
    di-coder
    @di-coder
    @ilex:oakforest.in I tired but same issue. Not getting email and any errors
    milad000cu
    @milad000cu
    I installed Superset and connected the PostGres database to it, but the database list in the dataset creation form is empty and there is no database
    rahul ranjan
    @ranjanrahul910
    Hi All,
    when i am trying to embed chart in html page getting error Blocked autofocusing on a <input> element in a cross-origin subframe. - anyone any idea how to resolve this
    michaelhagel
    @michaelhagel

    Hey all - creating an API workflow for auto-generating dashboards. Context: ML model monitoring for our enterprise. Problem: Currently stuck on generating a query_context for a POST api/v1/chart/ request, based off of a saved_query.

    Is there a defined way of generating this query_context? Or example repos containing a programatic workflow that I could refer to instead?

    minsu-jo
    @minsu-jo
    What should I do when I need to execute a query with Trino datasource?
    I installed sqlalchemy-trino and trino(trino-python-client) before deploying Superset, and I saw the message when I connected with my Trino cluster: "connection looks good."
    And I also saw the schema and table through the connection with Trino in SQL lab .
    But when I executed a query to Trino, I got an error: "__init__() got an unexpected keyword argument 'user'."
    Mark Thielen
    @MarkThielen

    Hi there, we are looking into working ob the current Alert/Reports area to
    1) Use the Alert/Report Owner to generate the Data within the Celery Worker Code as we are using Row Level Security for Multi Tentant Type Integration
    2) Add a S3 Data Drop as an addition to the already available Email and Slack
    3) Use the Chart Data API to use a configured Chart Context instead of the pre-set Chart Context

    We want to do this based on 1.5.0 Code at this time.

    • Are there any instructions available what we need to take into consideration when forking, etc ?
    • Is there a a responsible group of people that are working on this area (Alerts / Reports) to make sure our approaches are okay ?
      Thanks, Mark