superset: Superset 3.0 - Example charts throw SQLite Error - no such table: main.FCC 2018 Survey

I have deployed Apache Superset 3.0 using Helm charts. The Helm chart version is superset-0.10.11, and the app version is 3.0.1. I’ve configured Superset to load example data (loadExamples set to true), but I’m encountering an issue on the dashboard with the error message ‘no such table: main.FCC 2018 Survey’ while opening one of the example charts. Below is the stack strace from app pods.

2023-11-01 14:46:36,834:WARNING:superset.connectors.sqla.models:Query SELECT country_live AS country_live
FROM main."FCC 2018 Survey"
GROUP BY country_live
LIMIT 1000
OFFSET 0 on schema main failed
Traceback (most recent call last):
  File "/app/superset/connectors/sqla/models.py", line 1214, in query
    df = self.database.get_df(sql, self.schema, mutator=assign_column_label)
  File "/app/superset/models/core.py", line 611, in get_df
    self.db_engine_spec.execute(cursor, sqls[-1])
  File "/app/superset/db_engine_specs/base.py", line 1535, in execute
    raise cls.get_dbapi_mapped_exception(ex) from ex
  File "/app/superset/db_engine_specs/base.py", line 1533, in execute
    cursor.execute(query)
sqlite3.OperationalError: no such table: main.FCC 2018 Survey

How to reproduce the bug

  • Install Apache Superset Helm chart with version 0.10.11 and set loadExamples to true
  • Login to Superset to app and open FCC New Coder Survey 2018 chart

Expected results

  • It should load chart data

Actual results

  • It throws error - no such table: main.FCC 2018 Survey

About this issue

  • Original URL
  • State: open
  • Created 8 months ago
  • Reactions: 3
  • Comments: 24 (9 by maintainers)

Most upvoted comments

@dpgaspar Could you please take a look at this. I am not able to access any of the charts and getting no such table error. When I exec into superset pod, I can see that superset_home/examples.db file has zero size. When I run superset load_examples within pod, examples.db file gets recreated and then I am able to access all the charts.

Re-opening the issue…

We’re trying to get to a sustainable Issues backlog, and it’s extremely helpful when Issues cover one reproducible bug, which would preferably be fixed by one PR. When issues contain two bugs and multiple PRs, it gets confusing, long discussion threads ensue, and tend not to get closed (we’re currently tidying up antique issues and are seeing a lot of this).