You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "dbaltor (via GitHub)" <gi...@apache.org> on 2023/12/27 13:51:58 UTC
Re: [I] apache/superset latest 7502beb92ce5, load_examples -> dashboards not creating for me [superset]
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org