dbaltor commented on issue #24521: URL: https://github.com/apache/superset/issues/24521#issuecomment-1870325837
I'm having the same issue with **Superset 3.0.1** on Kubernetes. Here is the end of the `superset-init-db` pod logs ``` Downloading data from https://github.com/apache-superset/examples-data/raw/master/datasets/examples/fcc_survey_2018.csv.gz 2023-12-27 13:37:23,438:INFO:superset.datasets.commands.importers.v1.utils:Downloading data from https://github.com/apache-superset/examples-data/raw/master/datasets/examples/fcc_survey_2018.csv.gz Loading data outside the import transaction 2023-12-27 13:37:25,123:WARNING:superset.datasets.commands.importers.v1.utils:Loading data outside the import transaction Importing new slices Work Location Preference 2023-12-27 13:38:54,667:INFO:superset.models.helpers:Importing new slices Work Location Preference Importing new slices Weekly Threads 2023-12-27 13:38:54,680:INFO:superset.models.helpers:Importing new slices Weekly Threads Importing new slices Weekly Messages 2023-12-27 13:38:54,694:INFO:superset.models.helpers:Importing new slices Weekly Messages Importing new slices Video Game Sales filter 2023-12-27 13:38:54,705:INFO:superset.models.helpers:Importing new slices Video Game Sales filter Importing new slices Vehicle Sales Filter 2023-12-27 13:38:54,717:INFO:superset.models.helpers:Importing new slices Vehicle Sales Filter Importing new slices Vaccine Candidates per Phase 2023-12-27 13:38:54,732:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Phase Importing new slices Vaccine Candidates per Phase 2023-12-27 13:38:54,749:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Phase Importing new slices Vaccine Candidates per Country & Stage 2023-12-27 13:38:54,759:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Country & Stage Importing new slices Vaccine Candidates per Country & Stage 2023-12-27 13:38:54,769:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Country & Stage Importing new slices Vaccine Candidates per Country 2023-12-27 13:38:54,778:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Country Importing new slices Vaccine Candidates per Country 2023-12-27 13:38:54,790:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Country Importing new slices Vaccine Candidates per Approach & Stage 2023-12-27 13:38:54,807:INFO:superset.models.helpers:Importing new slices Vaccine Candidates per Approach & Stage Importing new slices Unicode Cloud 2023-12-27 13:38:54,817:INFO:superset.models.helpers:Importing new slices Unicode Cloud Importing new slices Total Sales per Market (Grouped by Genre) 2023-12-27 13:38:54,827:INFO:superset.models.helpers:Importing new slices Total Sales per Market (Grouped by Genre) Importing new slices Total Revenue 2023-12-27 13:38:54,838:INFO:superset.models.helpers:Importing new slices Total Revenue Importing new slices Total Items Sold (By Product Line) 2023-12-27 13:38:54,847:INFO:superset.models.helpers:Importing new slices Total Items Sold (By Product Line) Importing new slices Total Items Sold 2023-12-27 13:38:54,857:INFO:superset.models.helpers:Importing new slices Total Items Sold Importing new slices Top Timezones 2023-12-27 13:38:54,867:INFO:superset.models.helpers:Importing new slices Top Timezones Importing new slices Top 15 Languages Spoken at Home 2023-12-27 13:38:54,876:INFO:superset.models.helpers:Importing new slices Top 15 Languages Spoken at Home Importing new slices Top 10 Games: Proportion of Sales in Markets 2023-12-27 13:38:54,888:INFO:superset.models.helpers:Importing new slices Top 10 Games: Proportion of Sales in Markets Importing new slices Seasonality of Revenue (per Product Line) 2023-12-27 13:38:54,899:INFO:superset.models.helpers:Importing new slices Seasonality of Revenue (per Product Line) Importing new slices Rise & Fall of Video Game Consoles 2023-12-27 13:38:54,910:INFO:superset.models.helpers:Importing new slices Rise & Fall of Video Game Consoles Importing new slices Revenue by Deal Size 2023-12-27 13:38:54,921:INFO:superset.models.helpers:Importing new slices Revenue by Deal Size Importing new slices ✈️ Relocation ability 2023-12-27 13:38:54,934:INFO:superset.models.helpers:Importing new slices ✈️ Relocation ability Importing new slices Quarterly Sales (By Product Line) 2023-12-27 13:38:54,945:INFO:superset.models.helpers:Importing new slices Quarterly Sales (By Product Line) Importing new slices Quarterly Sales 2023-12-27 13:38:54,956:INFO:superset.models.helpers:Importing new slices Quarterly Sales Importing new slices Publishers With Most Titles 2023-12-27 13:38:54,967:INFO:superset.models.helpers:Importing new slices Publishers With Most Titles Importing new slices Proportion of Revenue by Product Line 2023-12-27 13:38:54,977:INFO:superset.models.helpers:Importing new slices Proportion of Revenue by Product Line Importing new slices Preferred Employment Style 2023-12-27 13:38:54,989:INFO:superset.models.helpers:Importing new slices Preferred Employment Style Importing new slices Popular Genres Across Platforms 2023-12-27 13:38:55,004:INFO:superset.models.helpers:Importing new slices Popular Genres Across Platforms Importing new slices Overall Sales (By Product Line) 2023-12-27 13:38:55,017:INFO:superset.models.helpers:Importing new slices Overall Sales (By Product Line) Importing new slices Number of Members 2023-12-27 13:38:55,029:INFO:superset.models.helpers:Importing new slices Number of Members Importing new slices # of Games That Hit 100k in Sales By Release Year 2023-12-27 13:38:55,044:INFO:superset.models.helpers:Importing new slices # of Games That Hit 100k in Sales By Release Year Importing new slices Number of Deals (for each Combination) 2023-12-27 13:38:55,055:INFO:superset.models.helpers:Importing new slices Number of Deals (for each Combination) Importing new slices Number of Aspiring Developers 2023-12-27 13:38:55,071:INFO:superset.models.helpers:Importing new slices Number of Aspiring Developers Importing new slices New Members per Month 2023-12-27 13:38:55,083:INFO:superset.models.helpers:Importing new slices New Members per Month Importing new slices Most Dominant Platforms 2023-12-27 13:38:55,104:INFO:superset.models.helpers:Importing new slices Most Dominant Platforms Importing new slices Messages per Channel 2023-12-27 13:38:55,119:INFO:superset.models.helpers:Importing new slices Messages per Channel Importing new slices Members per Channel 2023-12-27 13:38:55,137:INFO:superset.models.helpers:Importing new slices Members per Channel Importing new slices Location of Current Developers 2023-12-27 13:38:55,154:INFO:superset.models.helpers:Importing new slices Location of Current Developers Importing new slices Last Year Income Distribution 2023-12-27 13:38:55,168:INFO:superset.models.helpers:Importing new slices Last Year Income Distribution Importing new slices How much do you expect to earn? ($0 - 100k) 2023-12-27 13:38:55,179:INFO:superset.models.helpers:Importing new slices How much do you expect to earn? ($0 - 100k) Importing new slices How do you prefer to work? 2023-12-27 13:38:55,200:INFO:superset.models.helpers:Importing new slices How do you prefer to work? Importing new slices Highest degree held 2023-12-27 13:38:55,221:INFO:superset.models.helpers:Importing new slices Highest degree held Importing new slices Gender 2023-12-27 13:38:55,237:INFO:superset.models.helpers:Importing new slices Gender Importing new slices Games per Genre over time 2023-12-27 13:38:55,251:INFO:superset.models.helpers:Importing new slices Games per Genre over time Importing new slices Games per Genre 2023-12-27 13:38:55,262:INFO:superset.models.helpers:Importing new slices Games per Genre Importing new slices Games 2023-12-27 13:38:55,275:INFO:superset.models.helpers:Importing new slices Games Importing new slices First Time Developer & Commute Time 2023-12-27 13:38:55,287:INFO:superset.models.helpers:Importing new slices First Time Developer & Commute Time Importing new slices First Time Developer? 2023-12-27 13:38:55,304:INFO:superset.models.helpers:Importing new slices First Time Developer? Importing new slices Filtering Vaccines 2023-12-27 13:38:55,319:INFO:superset.models.helpers:Importing new slices Filtering Vaccines Importing new slices Filter Segments 2023-12-27 13:38:55,330:INFO:superset.models.helpers:Importing new slices Filter Segments Importing new slices Ethnic Minority & Gender 2023-12-27 13:38:55,343:INFO:superset.models.helpers:Importing new slices Ethnic Minority & Gender Importing new slices Degrees vs Income 2023-12-27 13:38:55,354:INFO:superset.models.helpers:Importing new slices Degrees vs Income Importing new slices Current Developers: Is this your first development job? 2023-12-27 13:38:55,365:INFO:superset.models.helpers:Importing new slices Current Developers: Is this your first development job? Importing new slices Cross Channel Relationship heatmap 2023-12-27 13:38:55,376:INFO:superset.models.helpers:Importing new slices Cross Channel Relationship heatmap Importing new slices Cross Channel Relationship 2023-12-27 13:38:55,389:INFO:superset.models.helpers:Importing new slices Cross Channel Relationship Importing new slices Country of Citizenship 2023-12-27 13:38:55,411:INFO:superset.models.helpers:Importing new slices Country of Citizenship Importing new slices Commute Time 2023-12-27 13:38:55,421:INFO:superset.models.helpers:Importing new slices Commute Time Importing new slices Breakdown of Developer Type 2023-12-27 13:38:55,430:INFO:superset.models.helpers:Importing new slices Breakdown of Developer Type Importing new slices Are you an ethnic minority in your city? 2023-12-27 13:38:55,445:INFO:superset.models.helpers:Importing new slices Are you an ethnic minority in your city? Importing new slices Age distribution of respondents 2023-12-27 13:38:55,459:INFO:superset.models.helpers:Importing new slices Age distribution of respondents Importing new dashboards Dashboard<None> 2023-12-27 13:38:55,477:INFO:superset.models.helpers:Importing new dashboards Dashboard<None> Importing new dashboards Dashboard<unicode-test> 2023-12-27 13:38:55,493:INFO:superset.models.helpers:Importing new dashboards Dashboard<unicode-test> Importing new dashboards Dashboard<None> 2023-12-27 13:38:55,503:INFO:superset.models.helpers:Importing new dashboards Dashboard<None> Importing new dashboards Dashboard<None> 2023-12-27 13:38:55,515:INFO:superset.models.helpers:Importing new dashboards Dashboard<None> Importing new dashboards Dashboard<None> 2023-12-27 13:38:55,527:INFO:superset.models.helpers:Importing new dashboards Dashboard<None> Importing new dashboards Dashboard<None> 2023-12-27 13:38:55,540:INFO:superset.models.helpers:Importing new dashboards Dashboard<None> Loaded your LOCAL configuration at [/app/pythonpath/superset_config.py] Loading examples metadata and related data into examples Creating default CSS templates Loading [World Bank's Health Nutrition and Population Stats] Creating table [wb_health_population] reference Creating a World's Health Bank dashboard Loading [Birth names] Done loading table! -------------------------------------------------------------------------------- Creating table [birth_names] reference Creating some slices Creating a dashboard Loading [Random long/lat data] Done loading table! -------------------------------------------------------------------------------- Creating table reference Creating a slice Loading [Country Map data] Done loading table! -------------------------------------------------------------------------------- Creating table reference Creating a slice Loading [San Francisco population polygons] Creating table sf_population_polygons reference Loading [Flights data] Done loading table! Loading [BART lines] Creating table bart_lines reference Loading [Misc Charts] dashboard Creating the dashboard Loading DECK.gl demo Loading deck.gl dashboard Creating Scatterplot slice Creating Screen Grid slice Creating Hex slice Creating Grid slice Creating Polygon slice Creating Arc slice Creating Path slice Creating a dashboard ``` I can't find any errors in the logs but this warning: `2023-12-27 13:37:25,123:WARNING:superset.datasets.commands.importers.v1.utils:Loading data outside the import transaction` Here is a snippet from the Superset node logs when I try to open an example dashboard: ``` Query SELECT country_name AS country_name, COUNT(*) AS count FROM main.covid_vaccines GROUP BY country_name LIMIT 10000 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.covid_vaccines 2023-12-27 13:40:35,855:WARNING:superset.connectors.sqla.models:Query SELECT country_name AS country_name, COUNT(*) AS count FROM main.covid_vaccines GROUP BY country_name LIMIT 10000 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.covid_vaccines ``` It looks like `superset-init-db` silently fails to create the tables and load the data. -- 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]
