MohamedRhimii commented on issue #24521: URL: https://github.com/apache/superset/issues/24521#issuecomment-2288903952
Ok, for reference, I'm using superset **helm**, **appVersion: "3.1.0"**, **version: 0.12.3** **Example screenshot:** This screenshot is an example. All superset example dashboards/charts are broken, in this same way. <img width="927" alt="screenshot-example" src="https://github.com/user-attachments/assets/5fb14357-971b-4b03-8c05-7623040e65a0";> --- **Logs generated after accessing the dashboard:** WARNING:superset.views.base:Superset.explore_json This API endpoint is deprecated and will be removed in version 4.0.0 DEBUG:parsedatetime:eval - with context - False, False Cache key: c4eaa8267cee23dd01548b85a3c127db INFO:superset.viz:Cache key: c4eaa8267cee23dd01548b85a3c127db Superset.explore_json This API endpoint is deprecated and will be removed in version 4.0.0 WARNING:superset.views.base:Superset.explore_json This API endpoint is deprecated and will be removed in version 4.0.0 DEBUG:parsedatetime:eval - with context - False, False Cache key: 350f59f6383a87ae03b43cedca52db5e INFO:superset.viz:Cache key: 350f59f6383a87ae03b43cedca52db5e Query SELECT sum(sales) AS "(Sales)" FROM main.cleaned_sales_data LIMIT 50000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data WARNING:superset.connectors.sqla.models:Query SELECT sum(sales) AS "(Sales)" FROM main.cleaned_sales_data LIMIT 50000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data Query SELECT DATETIME(order_date, 'start of month', printf('-%d month', (strftime('%m', order_date) - 1) % 3)) AS __timestamp, sum(sales) AS "SUM(Sales)" FROM main.cleaned_sales_data GROUP BY DATETIME(order_date, 'start of month', printf('-%d month', (strftime('%m', order_date) - 1) % 3)) ORDER BY "SUM(Sales)" DESC LIMIT 10000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data WARNING:superset.connectors.sqla.models:Query SELECT DATETIME(order_date, 'start of month', printf('-%d month', (strftime('%m', order_date) - 1) % 3)) AS __timestamp, sum(sales) AS "SUM(Sales)" FROM main.cleaned_sales_data GROUP BY DATETIME(order_date, 'start of month', printf('-%d month', (strftime('%m', order_date) - 1) % 3)) ORDER BY "SUM(Sales)" DESC LIMIT 10000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data Query SELECT sum(quantity_ordered) AS "SUM(Sales)" FROM main.cleaned_sales_data LIMIT 50000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data WARNING:superset.connectors.sqla.models:Query SELECT sum(quantity_ordered) AS "SUM(Sales)" FROM main.cleaned_sales_data LIMIT 50000 OFFSET 0 on schema main failed Traceback (most recent call last): File "/app/superset/connectors/sqla/models.py", line 1795, in query df = self.database.get_df(sql, self.schema, mutator=assign_column_label) File "/app/superset/models/core.py", line 612, in get_df self.db_engine_spec.execute(cursor, sqls[-1]) File "/app/superset/db_engine_specs/base.py", line 1596, in execute raise cls.get_dbapi_mapped_exception(ex) from ex File "/app/superset/db_engine_specs/base.py", line 1594, in execute cursor.execute(query) sqlite3.OperationalError: no such table: main.cleaned_sales_data --- My workaround, as stated above, was to just run `superset load-examples` within the superset main pod. That reloaded all broken dashboard examples. Thanks! -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
