search

apache / superset

Apache Superset is a Data Visualization and Data Exploration Platform
https://superset.apache.org/
Apache License 2.0
61.87k stars 13.55k forks source link

apache/superset latest 7502beb92ce5, load_examples -> dashboards not creating for me #24521

Open pcrozer opened 1 year ago

pcrozer commented 1 year ago

Hello there,

I'm having trouble getting started with the current release @ 2023-06-27 After load_examples and init, many of the dashboards don't work, complaining that tables don't exist I removed the image and restarted from the beginning and still get the same.

image

Some of the dashboards do work: FCC New Coder Survey 2018, deck.gl Demo, Unicode Test, some of Misc Charts, USA Births Names, World Bank's Data

The others all seem to have missing tables.

During load_examples I get various warnings, for some tables I'm seeing "couldn't check if the table exists, assuming it does" But, for example, the one shown in the image above, is one that according to the logs did get created.

Logs

... Creating a dashboard /app/superset/commands/importers/v1/utils.py:112: SAWarning: TypeDecorator EncryptedType() will not produce a cache key because the cache_ok attribute is not set to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf) for uuid, password in db.session.query(Database.uuid, Database.password).all() /app/superset/commands/importers/v1/utils.py:117: SAWarning: TypeDecorator EncryptedType() will not produce a cache key because the cache_ok attribute is not set to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf) for uuid, password in db.session.query(SSHTunnel.uuid, SSHTunnel.password).all() /app/superset/commands/importers/v1/utils.py:122: SAWarning: TypeDecorator EncryptedType() will not produce a cache key because the cache_ok attribute is not set to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf) for uuid, private_key in db.session.query( /app/superset/commands/importers/v1/utils.py:129: SAWarning: TypeDecorator EncryptedType() will not produce a cache key because the cache_ok attribute is not set to True. This can have significant performance implications including some performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this type object's state is safe to use in a cache key, or False to disable this warning. (Background on this error at: https://sqlalche.me/e/14/cprf) for uuid, private_key_password in db.session.query( Importing new tables main.threads 2023-06-27 06:54:18,382:INFO:superset.models.helpers:Importing new tables main.threads Dataset has no database will retry with database_id to set permission 2023-06-27 06:54:18,385:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning. obj = obj_query.one_or_none() Importing new sql_metrics count 2023-06-27 06:54:18,401:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns ts 2023-06-27 06:54:18,406:INFO:superset.models.helpers:Importing new table_columns ts Importing new table_columns client_msg_id 2023-06-27 06:54:18,409:INFO:superset.models.helpers:Importing new table_columns client_msg_id Importing new table_columns channel_id 2023-06-27 06:54:18,413:INFO:superset.models.helpers:Importing new table_columns channel_id Importing new table_columns thread_ts 2023-06-27 06:54:18,417:INFO:superset.models.helpers:Importing new table_columns thread_ts Importing new table_columns latest_reply 2023-06-27 06:54:18,420:INFO:superset.models.helpers:Importing new table_columns latest_reply Importing new table_columns team 2023-06-27 06:54:18,422:INFO:superset.models.helpers:Importing new table_columns team Importing new table_columns type 2023-06-27 06:54:18,426:INFO:superset.models.helpers:Importing new table_columns type Importing new table_columns user 2023-06-27 06:54:18,430:INFO:superset.models.helpers:Importing new table_columns user Importing new table_columns text 2023-06-27 06:54:18,434:INFO:superset.models.helpers:Importing new table_columns text Importing new table_columns subscribed 2023-06-27 06:54:18,436:INFO:superset.models.helpers:Importing new table_columns subscribed Importing new table_columns reply_count 2023-06-27 06:54:18,439:INFO:superset.models.helpers:Importing new table_columns reply_count Importing new table_columns reply_users 2023-06-27 06:54:18,442:INFO:superset.models.helpers:Importing new table_columns reply_users Importing new table_columns blocks 2023-06-27 06:54:18,446:INFO:superset.models.helpers:Importing new table_columns blocks Importing new table_columns reply_users_count 2023-06-27 06:54:18,449:INFO:superset.models.helpers:Importing new table_columns reply_users_count Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/threads.csv 2023-06-27 06:54:18,454:INFO:superset.datasets.commands.importers.v1.utils:Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/threads.csv Loading data inside the import transaction 2023-06-27 06:54:18,732:INFO:superset.datasets.commands.importers.v1.utils:Loading data inside the import transaction Importing new tables main.unicode_test 2023-06-27 06:54:18,787:INFO:superset.models.helpers:Importing new tables main.unicode_test Dataset has no database will retry with database_id to set permission 2023-06-27 06:54:18,789:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning. obj = obj_query.one_or_none() Importing new sql_metrics count 2023-06-27 06:54:18,799:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns with_missing 2023-06-27 06:54:18,802:INFO:superset.models.helpers:Importing new table_columns with_missing Importing new table_columns phrase 2023-06-27 06:54:18,805:INFO:superset.models.helpers:Importing new table_columns phrase Importing new table_columns short_phrase 2023-06-27 06:54:18,807:INFO:superset.models.helpers:Importing new table_columns short_phrase Importing new table_columns dttm 2023-06-27 06:54:18,810:INFO:superset.models.helpers:Importing new table_columns dttm Importing new table_columns value 2023-06-27 06:54:18,813:INFO:superset.models.helpers:Importing new table_columns value Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/unicode_test.csv 2023-06-27 06:54:18,819:INFO:superset.datasets.commands.importers.v1.utils:Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/unicode_test.csv Loading data inside the import transaction 2023-06-27 06:54:19,109:INFO:superset.datasets.commands.importers.v1.utils:Loading data inside the import transaction Importing new tables main.users_channels 2023-06-27 06:54:19,144:INFO:superset.models.helpers:Importing new tables main.users_channels Dataset has no database will retry with database_id to set permission 2023-06-27 06:54:19,147:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning. obj = obj_query.one_or_none() Importing new sql_metrics count 2023-06-27 06:54:19,156:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns user_id 2023-06-27 06:54:19,159:INFO:superset.models.helpers:Importing new table_columns user_id Importing new table_columns name 2023-06-27 06:54:19,163:INFO:superset.models.helpers:Importing new table_columns name Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/users_channels.csv 2023-06-27 06:54:19,168:INFO:superset.datasets.commands.importers.v1.utils:Downloading data from https://raw.githubusercontent.com/apache-superset/examples-data/master/datasets/examples/slack/users_channels.csv Loading data inside the import transaction 2023-06-27 06:54:19,415:INFO:superset.datasets.commands.importers.v1.utils:Loading data inside the import transaction Importing new tables main.messages_channels 2023-06-27 06:54:19,904:INFO:superset.models.helpers:Importing new tables main.messages_channels Dataset has no database will retry with database_id to set permission 2023-06-27 06:54:19,906:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning. obj = obj_query.one_or_none() Importing new sql_metrics count 2023-06-27 06:54:19,916:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns ts 2023-06-27 06:54:19,919:INFO:superset.models.helpers:Importing new table_columns ts Importing new table_columns name 2023-06-27 06:54:19,922:INFO:superset.models.helpers:Importing new table_columns name Importing new table_columns text 2023-06-27 06:54:19,925:INFO:superset.models.helpers:Importing new table_columns text Importing new tables main.members_channels_2 2023-06-27 06:54:19,936:INFO:superset.models.helpers:Importing new tables main.members_channels_2 Dataset has no database will retry with database_id to set permission 2023-06-27 06:54:19,938:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:54:19,948:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns channel_name 2023-06-27 06:54:19,951:INFO:superset.models.helpers:Importing new table_columns channel_name Importing new table_columns member_name 2023-06-27 06:54:19,954:INFO:superset.models.helpers:Importing new table_columns member_name Importing new tables main.new_members_daily 2023-06-27 06:54:19,965:INFO:superset.models.helpers:Importing new tables main.new_members_daily Dataset has no database will retry with database_id to set permission 2023-06-27 06:54:19,967:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:54:19,974:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns date 2023-06-27 06:54:19,977:INFO:superset.models.helpers:Importing new table_columns date Importing new table_columns new_members 2023-06-27 06:54:19,981:INFO:superset.models.helpers:Importing new table_columns new_members Importing new tables main.users_channels-uzooNNtSRO 2023-06-27 06:54:19,992:INFO:superset.models.helpers:Importing new tables main.users_channels-uzooNNtSRO Dataset has no database will retry with database_id to set permission 2023-06-27 06:54:19,993:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:54:20,002:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns channel_1 2023-06-27 06:54:20,005:INFO:superset.models.helpers:Importing new table_columns channel_1 Importing new table_columns channel_2 2023-06-27 06:54:20,008:INFO:superset.models.helpers:Importing new table_columns channel_2 Importing new table_columns cnt 2023-06-27 06:54:20,011:INFO:superset.models.helpers:Importing new table_columns cnt Importing new tables main.FCC 2018 Survey 2023-06-27 06:54:20,021:INFO:superset.models.helpers:Importing new tables main.FCC 2018 Survey Dataset has no database will retry with database_id to set permission 2023-06-27 06:54:20,023:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:54:20,031:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns highest_degree_earned 2023-06-27 06:54:20,036:INFO:superset.models.helpers:Importing new table_columns highest_degree_earned Importing new table_columns job_location_preference 2023-06-27 06:54:20,040:INFO:superset.models.helpers:Importing new table_columns job_location_preference Importing new table_columns ethnic_minority 2023-06-27 06:54:20,043:INFO:superset.models.helpers:Importing new table_columns ethnic_minority Importing new table_columns willing_to_relocate 2023-06-27 06:54:20,047:INFO:superset.models.helpers:Importing new table_columns willing_to_relocate Importing new table_columns developer_type 2023-06-27 06:54:20,050:INFO:superset.models.helpers:Importing new table_columns developer_type Importing new table_columns first_time_developer 2023-06-27 06:54:20,053:INFO:superset.models.helpers:Importing new table_columns first_time_developer Importing new table_columns gender 2023-06-27 06:54:20,056:INFO:superset.models.helpers:Importing new table_columns gender Importing new table_columns calc_first_time_dev 2023-06-27 06:54:20,060:INFO:superset.models.helpers:Importing new table_columns calc_first_time_dev Importing new table_columns yt_codingtuts360 2023-06-27 06:54:20,064:INFO:superset.models.helpers:Importing new table_columns yt_codingtuts360 Importing new table_columns is_recv_disab_bnft 2023-06-27 06:54:20,067:INFO:superset.models.helpers:Importing new table_columns is_recv_disab_bnft Importing new table_columns job_intr_qa_engn 2023-06-27 06:54:20,070:INFO:superset.models.helpers:Importing new table_columns job_intr_qa_engn Importing new table_columns has_high_spd_ntnet 2023-06-27 06:54:20,073:INFO:superset.models.helpers:Importing new table_columns has_high_spd_ntnet Importing new table_columns is_first_dev_job 2023-06-27 06:54:20,075:INFO:superset.models.helpers:Importing new table_columns is_first_dev_job Importing new table_columns job_intr_ux_engn 2023-06-27 06:54:20,079:INFO:superset.models.helpers:Importing new table_columns job_intr_ux_engn Importing new table_columns bootcamp_have_loan 2023-06-27 06:54:20,083:INFO:superset.models.helpers:Importing new table_columns bootcamp_have_loan Importing new table_columns podcast_js_jabber 2023-06-27 06:54:20,086:INFO:superset.models.helpers:Importing new table_columns podcast_js_jabber Importing new table_columns job_intr_datasci 2023-06-27 06:54:20,089:INFO:superset.models.helpers:Importing new table_columns job_intr_datasci Importing new table_columns job_intr_dataengn 2023-06-27 06:54:20,091:INFO:superset.models.helpers:Importing new table_columns job_intr_dataengn Importing new table_columns rsrc_khan_acdm 2023-06-27 06:54:20,095:INFO:superset.models.helpers:Importing new table_columns rsrc_khan_acdm Importing new table_columns has_finance_depends 2023-06-27 06:54:20,098:INFO:superset.models.helpers:Importing new table_columns has_finance_depends Importing new table_columns has_served_military 2023-06-27 06:54:20,101:INFO:superset.models.helpers:Importing new table_columns has_served_military Importing new table_columns job_intr_backend 2023-06-27 06:54:20,104:INFO:superset.models.helpers:Importing new table_columns job_intr_backend Importing new table_columns job_intr_teacher 2023-06-27 06:54:20,106:INFO:superset.models.helpers:Importing new table_columns job_intr_teacher Importing new table_columns months_job_search 2023-06-27 06:54:20,110:INFO:superset.models.helpers:Importing new table_columns months_job_search Importing new table_columns student_debt_has 2023-06-27 06:54:20,114:INFO:superset.models.helpers:Importing new table_columns student_debt_has Importing new table_columns student_debt_amt 2023-06-27 06:54:20,117:INFO:superset.models.helpers:Importing new table_columns student_debt_amt Importing new table_columns job_intr_gamedev 2023-06-27 06:54:20,120:INFO:superset.models.helpers:Importing new table_columns job_intr_gamedev Importing new table_columns rsrc_code_wars 2023-06-27 06:54:20,122:INFO:superset.models.helpers:Importing new table_columns rsrc_code_wars Importing new table_columns do_finance_support 2023-06-27 06:54:20,126:INFO:superset.models.helpers:Importing new table_columns do_finance_support Importing new table_columns last_yr_income 2023-06-27 06:54:20,130:INFO:superset.models.helpers:Importing new table_columns last_yr_income Importing new table_columns is_software_dev 2023-06-27 06:54:20,134:INFO:superset.models.helpers:Importing new table_columns is_software_dev Importing new table_columns money_for_learning 2023-06-27 06:54:20,137:INFO:superset.models.helpers:Importing new table_columns money_for_learning Importing new table_columns home_mrtg_has 2023-06-27 06:54:20,139:INFO:superset.models.helpers:Importing new table_columns home_mrtg_has Importing new table_columns job_intr_mobile 2023-06-27 06:54:20,143:INFO:superset.models.helpers:Importing new table_columns job_intr_mobile Importing new table_columns job_intr_infosec 2023-06-27 06:54:20,146:INFO:superset.models.helpers:Importing new table_columns job_intr_infosec Importing new table_columns job_intr_fllstck 2023-06-27 06:54:20,149:INFO:superset.models.helpers:Importing new table_columns job_intr_fllstck Importing new table_columns job_intr_frntend 2023-06-27 06:54:20,152:INFO:superset.models.helpers:Importing new table_columns job_intr_frntend Importing new table_columns job_intr_devops 2023-06-27 06:54:20,155:INFO:superset.models.helpers:Importing new table_columns job_intr_devops Importing new table_columns job_intr_projm 2023-06-27 06:54:20,158:INFO:superset.models.helpers:Importing new table_columns job_intr_projm Importing new table_columns rsrc_css_tricks 2023-06-27 06:54:20,161:INFO:superset.models.helpers:Importing new table_columns rsrc_css_tricks Importing new table_columns yt_cs_dojo 2023-06-27 06:54:20,165:INFO:superset.models.helpers:Importing new table_columns yt_cs_dojo Importing new table_columns is_ethnic_minority 2023-06-27 06:54:20,168:INFO:superset.models.helpers:Importing new table_columns is_ethnic_minority Importing new table_columns yt_mit_ocw 2023-06-27 06:54:20,171:INFO:superset.models.helpers:Importing new table_columns yt_mit_ocw Importing new table_columns is_self_employed 2023-06-27 06:54:20,175:INFO:superset.models.helpers:Importing new table_columns is_self_employed Importing new table_columns home_mrtg_owe 2023-06-27 06:54:20,179:INFO:superset.models.helpers:Importing new table_columns home_mrtg_owe Importing new table_columns yt_engn_truth 2023-06-27 06:54:20,182:INFO:superset.models.helpers:Importing new table_columns yt_engn_truth Importing new table_columns bootcamp_attend 2023-06-27 06:54:20,185:INFO:superset.models.helpers:Importing new table_columns bootcamp_attend Importing new table_columns yt_derekbanas 2023-06-27 06:54:20,189:INFO:superset.models.helpers:Importing new table_columns yt_derekbanas Importing new table_columns yt_learncodeacdm 2023-06-27 06:54:20,193:INFO:superset.models.helpers:Importing new table_columns yt_learncodeacdm Importing new table_columns podcast_changelog 2023-06-27 06:54:20,197:INFO:superset.models.helpers:Importing new table_columns podcast_changelog Importing new table_columns rsrc_hackerrank 2023-06-27 06:54:20,200:INFO:superset.models.helpers:Importing new table_columns rsrc_hackerrank Importing new table_columns podcast_devtea 2023-06-27 06:54:20,203:INFO:superset.models.helpers:Importing new table_columns podcast_devtea Importing new table_columns podcast_sedaily 2023-06-27 06:54:20,207:INFO:superset.models.helpers:Importing new table_columns podcast_sedaily Importing new table_columns podcast_seradio 2023-06-27 06:54:20,210:INFO:superset.models.helpers:Importing new table_columns podcast_seradio Importing new table_columns codeevnt_gamejam 2023-06-27 06:54:20,213:INFO:superset.models.helpers:Importing new table_columns codeevnt_gamejam Importing new table_columns podcast_geekspeak 2023-06-27 06:54:20,216:INFO:superset.models.helpers:Importing new table_columns podcast_geekspeak Importing new table_columns podcast_talkpythonme 2023-06-27 06:54:20,218:INFO:superset.models.helpers:Importing new table_columns podcast_talkpythonme Importing new table_columns podcast_hanselmnts 2023-06-27 06:54:20,222:INFO:superset.models.helpers:Importing new table_columns podcast_hanselmnts Importing new table_columns podcast_syntaxfm 2023-06-27 06:54:20,225:INFO:superset.models.helpers:Importing new table_columns podcast_syntaxfm Importing new table_columns podcast_shoptalk 2023-06-27 06:54:20,228:INFO:superset.models.helpers:Importing new table_columns podcast_shoptalk Importing new table_columns yt_mozillahacks 2023-06-27 06:54:20,231:INFO:superset.models.helpers:Importing new table_columns yt_mozillahacks Importing new table_columns podcast_codingblcks 2023-06-27 06:54:20,234:INFO:superset.models.helpers:Importing new table_columns podcast_codingblcks Importing new table_columns podcast_codenewbie 2023-06-27 06:54:20,238:INFO:superset.models.helpers:Importing new table_columns podcast_codenewbie Importing new table_columns bootcamp_recommend 2023-06-27 06:54:20,241:INFO:superset.models.helpers:Importing new table_columns bootcamp_recommend Importing new table_columns codeevnt_railsbrdg 2023-06-27 06:54:20,243:INFO:superset.models.helpers:Importing new table_columns codeevnt_railsbrdg Importing new table_columns bootcamp_finished 2023-06-27 06:54:20,246:INFO:superset.models.helpers:Importing new table_columns bootcamp_finished Importing new table_columns podcast_rubyrogues 2023-06-27 06:54:20,249:INFO:superset.models.helpers:Importing new table_columns podcast_rubyrogues Importing new table_columns job_relocate 2023-06-27 06:54:20,253:INFO:superset.models.helpers:Importing new table_columns job_relocate Importing new table_columns debt_amt 2023-06-27 06:54:20,256:INFO:superset.models.helpers:Importing new table_columns debt_amt Importing new table_columns rsrc_codeacdm 2023-06-27 06:54:20,258:INFO:superset.models.helpers:Importing new table_columns rsrc_codeacdm Importing new table_columns podcast_fcc 2023-06-27 06:54:20,261:INFO:superset.models.helpers:Importing new table_columns podcast_fcc Importing new table_columns podcast_codepenrd 2023-06-27 06:54:20,265:INFO:superset.models.helpers:Importing new table_columns podcast_codepenrd Importing new table_columns podcast_fullstckrd 2023-06-27 06:54:20,268:INFO:superset.models.helpers:Importing new table_columns podcast_fullstckrd Importing new table_columns codeevnt_hackthn 2023-06-27 06:54:20,271:INFO:superset.models.helpers:Importing new table_columns codeevnt_hackthn Importing new table_columns rsrc_udacity 2023-06-27 06:54:20,274:INFO:superset.models.helpers:Importing new table_columns rsrc_udacity Importing new table_columns podcast_ltcwm 2023-06-27 06:54:20,276:INFO:superset.models.helpers:Importing new table_columns podcast_ltcwm Importing new table_columns rsrc_coursera 2023-06-27 06:54:20,279:INFO:superset.models.helpers:Importing new table_columns rsrc_coursera Importing new table_columns codeevnt_djangogrls 2023-06-27 06:54:20,283:INFO:superset.models.helpers:Importing new table_columns codeevnt_djangogrls Importing new table_columns codeevnt_startupwknd 2023-06-27 06:54:20,286:INFO:superset.models.helpers:Importing new table_columns codeevnt_startupwknd Importing new table_columns podcast_progthrwdwn 2023-06-27 06:54:20,289:INFO:superset.models.helpers:Importing new table_columns podcast_progthrwdwn Importing new table_columns expected_earn 2023-06-27 06:54:20,292:INFO:superset.models.helpers:Importing new table_columns expected_earn Importing new table_columns rsrc_egghead 2023-06-27 06:54:20,295:INFO:superset.models.helpers:Importing new table_columns rsrc_egghead Importing new table_columns codeevnt_railsgrls 2023-06-27 06:54:20,299:INFO:superset.models.helpers:Importing new table_columns codeevnt_railsgrls Importing new table_columns has_children 2023-06-27 06:54:20,302:INFO:superset.models.helpers:Importing new table_columns has_children Importing new table_columns podcast_frnthppyhr 2023-06-27 06:54:20,304:INFO:superset.models.helpers:Importing new table_columns podcast_frnthppyhr Importing new table_columns yt_codingtrain 2023-06-27 06:54:20,307:INFO:superset.models.helpers:Importing new table_columns yt_codingtrain Importing new table_columns rsrc_lynda 2023-06-27 06:54:20,310:INFO:superset.models.helpers:Importing new table_columns rsrc_lynda Importing new table_columns rsrc_pluralsight 2023-06-27 06:54:20,314:INFO:superset.models.helpers:Importing new table_columns rsrc_pluralsight Importing new table_columns hours_learning 2023-06-27 06:54:20,317:INFO:superset.models.helpers:Importing new table_columns hours_learning Importing new table_columns yt_simplilearn 2023-06-27 06:54:20,320:INFO:superset.models.helpers:Importing new table_columns yt_simplilearn Importing new table_columns codeevnt_wkndbtcmp 2023-06-27 06:54:20,323:INFO:superset.models.helpers:Importing new table_columns codeevnt_wkndbtcmp Importing new table_columns codeevnt_fcc 2023-06-27 06:54:20,325:INFO:superset.models.helpers:Importing new table_columns codeevnt_fcc Importing new table_columns rsrc_fcc 2023-06-27 06:54:20,329:INFO:superset.models.helpers:Importing new table_columns rsrc_fcc Importing new table_columns codeevnt_coderdojo 2023-06-27 06:54:20,333:INFO:superset.models.helpers:Importing new table_columns codeevnt_coderdojo Importing new table_columns codeevnt_nodeschl 2023-06-27 06:54:20,336:INFO:superset.models.helpers:Importing new table_columns codeevnt_nodeschl Importing new table_columns codeevnt_womenwc 2023-06-27 06:54:20,338:INFO:superset.models.helpers:Importing new table_columns codeevnt_womenwc Importing new table_columns codeevnt_confs 2023-06-27 06:54:20,341:INFO:superset.models.helpers:Importing new table_columns codeevnt_confs Importing new table_columns yt_fcc 2023-06-27 06:54:20,343:INFO:superset.models.helpers:Importing new table_columns yt_fcc Importing new table_columns codeevnt_girldevit 2023-06-27 06:54:20,347:INFO:superset.models.helpers:Importing new table_columns codeevnt_girldevit Importing new table_columns codeevnt_meetup 2023-06-27 06:54:20,350:INFO:superset.models.helpers:Importing new table_columns codeevnt_meetup Importing new table_columns codeevnt_workshps 2023-06-27 06:54:20,353:INFO:superset.models.helpers:Importing new table_columns codeevnt_workshps Importing new table_columns rsrc_frntendmstr 2023-06-27 06:54:20,355:INFO:superset.models.helpers:Importing new table_columns rsrc_frntendmstr Importing new table_columns num_children 2023-06-27 06:54:20,358:INFO:superset.models.helpers:Importing new table_columns num_children Importing new table_columns rsrc_udemy 2023-06-27 06:54:20,361:INFO:superset.models.helpers:Importing new table_columns rsrc_udemy Importing new table_columns rsrc_edx 2023-06-27 06:54:20,364:INFO:superset.models.helpers:Importing new table_columns rsrc_edx Importing new table_columns rsrc_mdn 2023-06-27 06:54:20,367:INFO:superset.models.helpers:Importing new table_columns rsrc_mdn Importing new table_columns rsrc_treehouse 2023-06-27 06:54:20,370:INFO:superset.models.helpers:Importing new table_columns rsrc_treehouse Importing new table_columns yt_computerphile 2023-06-27 06:54:20,373:INFO:superset.models.helpers:Importing new table_columns yt_computerphile Importing new table_columns yt_funfunfunct 2023-06-27 06:54:20,376:INFO:superset.models.helpers:Importing new table_columns yt_funfunfunct Importing new table_columns rsrc_so 2023-06-27 06:54:20,379:INFO:superset.models.helpers:Importing new table_columns rsrc_so Importing new table_columns yt_googledevs 2023-06-27 06:54:20,382:INFO:superset.models.helpers:Importing new table_columns yt_googledevs Importing new table_columns yt_devtips 2023-06-27 06:54:20,385:INFO:superset.models.helpers:Importing new table_columns yt_devtips Importing new table_columns yt_simpleprog 2023-06-27 06:54:20,387:INFO:superset.models.helpers:Importing new table_columns yt_simpleprog Importing new table_columns yt_lvluptuts 2023-06-27 06:54:20,390:INFO:superset.models.helpers:Importing new table_columns yt_lvluptuts Importing new table_columns time_start 2023-06-27 06:54:20,394:INFO:superset.models.helpers:Importing new table_columns time_start Importing new table_columns time_total_sec 2023-06-27 06:54:20,397:INFO:superset.models.helpers:Importing new table_columns time_total_sec Importing new table_columns months_programming 2023-06-27 06:54:20,400:INFO:superset.models.helpers:Importing new table_columns months_programming Importing new table_columns age 2023-06-27 06:54:20,402:INFO:superset.models.helpers:Importing new table_columns age Importing new table_columns ID 2023-06-27 06:54:20,405:INFO:superset.models.helpers:Importing new table_columns ID Importing new table_columns reasons_to_code_other 2023-06-27 06:54:20,408:INFO:superset.models.helpers:Importing new table_columns reasons_to_code_other Importing new table_columns lang_at_home 2023-06-27 06:54:20,412:INFO:superset.models.helpers:Importing new table_columns lang_at_home Importing new table_columns when_appl_job 2023-06-27 06:54:20,415:INFO:superset.models.helpers:Importing new table_columns when_appl_job Importing new table_columns reasons_to_code 2023-06-27 06:54:20,418:INFO:superset.models.helpers:Importing new table_columns reasons_to_code Importing new table_columns live_city_population 2023-06-27 06:54:20,420:INFO:superset.models.helpers:Importing new table_columns live_city_population Importing new table_columns job_lctn_pref 2023-06-27 06:54:20,424:INFO:superset.models.helpers:Importing new table_columns job_lctn_pref Importing new table_columns job_intr_other 2023-06-27 06:54:20,428:INFO:superset.models.helpers:Importing new table_columns job_intr_other Importing new table_columns curr_employment_other 2023-06-27 06:54:20,432:INFO:superset.models.helpers:Importing new table_columns curr_employment_other Importing new table_columns marital_status 2023-06-27 06:54:20,435:INFO:superset.models.helpers:Importing new table_columns marital_status Importing new table_columns bootcamp_name 2023-06-27 06:54:20,438:INFO:superset.models.helpers:Importing new table_columns bootcamp_name Importing new table_columns podcast_other 2023-06-27 06:54:20,442:INFO:superset.models.helpers:Importing new table_columns podcast_other Importing new table_columns school_major 2023-06-27 06:54:20,445:INFO:superset.models.helpers:Importing new table_columns school_major Importing new table_columns job_pref 2023-06-27 06:54:20,448:INFO:superset.models.helpers:Importing new table_columns job_pref Importing new table_columns country_citizen 2023-06-27 06:54:20,451:INFO:superset.models.helpers:Importing new table_columns country_citizen Importing new table_columns school_degree 2023-06-27 06:54:20,454:INFO:superset.models.helpers:Importing new table_columns school_degree Importing new table_columns codeevnt_other 2023-06-27 06:54:20,458:INFO:superset.models.helpers:Importing new table_columns codeevnt_other Importing new table_columns curr_field 2023-06-27 06:54:20,462:INFO:superset.models.helpers:Importing new table_columns curr_field Importing new table_columns communite_time 2023-06-27 06:54:20,465:INFO:superset.models.helpers:Importing new table_columns communite_time Importing new table_columns rsrc_other 2023-06-27 06:54:20,468:INFO:superset.models.helpers:Importing new table_columns rsrc_other Importing new table_columns country_live 2023-06-27 06:54:20,472:INFO:superset.models.helpers:Importing new table_columns country_live Importing new table_columns curr_employment 2023-06-27 06:54:20,476:INFO:superset.models.helpers:Importing new table_columns curr_employment Importing new table_columns gender_other 2023-06-27 06:54:20,479:INFO:superset.models.helpers:Importing new table_columns gender_other Importing new table_columns time_end 2023-06-27 06:54:20,482:INFO:superset.models.helpers:Importing new table_columns time_end Importing new table_columns network_id 2023-06-27 06:54:20,486:INFO:superset.models.helpers:Importing new table_columns network_id Importing new table_columns yt_other 2023-06-27 06:54:20,490:INFO:superset.models.helpers:Importing new table_columns yt_other Updating table_columns gender 2023-06-27 06:54:20,493:INFO:superset.models.helpers:Updating table_columns gender Downloading data from https://github.com/apache-superset/examples-data/raw/master/datasets/examples/fcc_survey_2018.csv.gz 2023-06-27 06:54:20,501: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 inside the import transaction 2023-06-27 06:54:22,150:INFO:superset.datasets.commands.importers.v1.utils:Loading data inside the import transaction Importing new tables main.channels 2023-06-27 06:55:53,824:INFO:superset.models.helpers:Importing new tables main.channels Dataset has no database will retry with database_id to set permission 2023-06-27 06:55:53,826:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'related attribute set' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/connectors/sqla/models.py:1574: SAWarning: Usage of the 'collection append' operation is not currently supported within the execution stage of the flush process. Results may not be consistent. Consider using alternative event listeners or connection-level operations instead. self.database = session.query(Database).filter_by(id=self.database_id).one() /app/superset/models/helpers.py:297: SAWarning: Attribute history events accumulated on 1 previously clean instances within inner-flush event handlers have been reset, and will not result in database updates. Consider using set_committed_value() within inner-flush event handlers to avoid this warning. obj = obj_query.one_or_none() Importing new sql_metrics count 2023-06-27 06:55:53,837:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns topiclast_set 2023-06-27 06:55:53,841:INFO:superset.models.helpers:Importing new table_columns topiclast_set Importing new table_columns purposelast_set 2023-06-27 06:55:53,845:INFO:superset.models.helpers:Importing new table_columns purposelast_set Importing new table_columns created 2023-06-27 06:55:53,848:INFO:superset.models.helpers:Importing new table_columns created Importing new table_columns unlinked 2023-06-27 06:55:53,851:INFO:superset.models.helpers:Importing new table_columns unlinked Importing new table_columns topiccreator 2023-06-27 06:55:53,853:INFO:superset.models.helpers:Importing new table_columns topic__creator Importing new table_columns purposecreator 2023-06-27 06:55:53,856:INFO:superset.models.helpers:Importing new table_columns purposecreator Importing new table_columns topic__value 2023-06-27 06:55:53,859:INFO:superset.models.helpers:Importing new table_columns topicvalue Importing new table_columns purpose__value 2023-06-27 06:55:53,863:INFO:superset.models.helpers:Importing new table_columns purpose__value Importing new table_columns parent_conversation 2023-06-27 06:55:53,866:INFO:superset.models.helpers:Importing new table_columns parent_conversation Importing new table_columns name_normalized 2023-06-27 06:55:53,869:INFO:superset.models.helpers:Importing new table_columns name_normalized Importing new table_columns channel_id 2023-06-27 06:55:53,873:INFO:superset.models.helpers:Importing new table_columns channel_id Importing new table_columns creator 2023-06-27 06:55:53,877:INFO:superset.models.helpers:Importing new table_columns creator Importing new table_columns name 2023-06-27 06:55:53,881:INFO:superset.models.helpers:Importing new table_columns name Importing new table_columns id 2023-06-27 06:55:53,884:INFO:superset.models.helpers:Importing new table_columns id Importing new table_columns is_pending_ext_shared 2023-06-27 06:55:53,887:INFO:superset.models.helpers:Importing new table_columns is_pending_ext_shared Importing new table_columns is_ext_shared 2023-06-27 06:55:53,891:INFO:superset.models.helpers:Importing new table_columns is_ext_shared Importing new table_columns is_org_shared 2023-06-27 06:55:53,894:INFO:superset.models.helpers:Importing new table_columns is_org_shared Importing new table_columns is_archived 2023-06-27 06:55:53,897:INFO:superset.models.helpers:Importing new table_columns is_archived Importing new table_columns is_channel 2023-06-27 06:55:53,900:INFO:superset.models.helpers:Importing new table_columns is_channel Importing new table_columns is_shared 2023-06-27 06:55:53,903:INFO:superset.models.helpers:Importing new table_columns is_shared Importing new table_columns is_general 2023-06-27 06:55:53,906:INFO:superset.models.helpers:Importing new table_columns is_general Importing new table_columns is_private 2023-06-27 06:55:53,910:INFO:superset.models.helpers:Importing new table_columns is_private Importing new table_columns is_member 2023-06-27 06:55:53,913:INFO:superset.models.helpers:Importing new table_columns is_member Importing new table_columns is_group 2023-06-27 06:55:53,916:INFO:superset.models.helpers:Importing new table_columns is_group Importing new table_columns is_mpim 2023-06-27 06:55:53,920:INFO:superset.models.helpers:Importing new table_columns is_mpim Importing new table_columns is_im 2023-06-27 06:55:53,923:INFO:superset.models.helpers:Importing new table_columns is_im Importing new table_columns num_members 2023-06-27 06:55:53,927:INFO:superset.models.helpers:Importing new table_columns num_members Importing new table_columns pending_connected_team_ids 2023-06-27 06:55:53,930:INFO:superset.models.helpers:Importing new table_columns pending_connected_team_ids Importing new table_columns shared_team_ids 2023-06-27 06:55:53,932:INFO:superset.models.helpers:Importing new table_columns shared_team_ids Importing new table_columns pending_shared 2023-06-27 06:55:53,936:INFO:superset.models.helpers:Importing new table_columns pending_shared Importing new table_columns previous_names 2023-06-27 06:55:53,940:INFO:superset.models.helpers:Importing new table_columns previous_names Importing new table_columns members 2023-06-27 06:55:53,943:INFO:superset.models.helpers:Importing new table_columns members Couldn't check if table channels exists, assuming it does 2023-06-27 06:55:58,964:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table channels exists, assuming it does Importing new tables main.cleaned_sales_data 2023-06-27 06:55:58,988:INFO:superset.models.helpers:Importing new tables main.cleaned_sales_data Dataset has no database will retry with database_id to set permission 2023-06-27 06:55:58,991:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:55:59,007:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns order_date 2023-06-27 06:55:59,013:INFO:superset.models.helpers:Importing new table_columns order_date Importing new table_columns price_each 2023-06-27 06:55:59,019:INFO:superset.models.helpers:Importing new table_columns price_each Importing new table_columns sales 2023-06-27 06:55:59,022:INFO:superset.models.helpers:Importing new table_columns sales Importing new table_columns address_line1 2023-06-27 06:55:59,025:INFO:superset.models.helpers:Importing new table_columns address_line1 Importing new table_columns address_line2 2023-06-27 06:55:59,028:INFO:superset.models.helpers:Importing new table_columns address_line2 Importing new table_columns contact_last_name 2023-06-27 06:55:59,031:INFO:superset.models.helpers:Importing new table_columns contact_last_name Importing new table_columns contact_first_name 2023-06-27 06:55:59,035:INFO:superset.models.helpers:Importing new table_columns contact_first_name Importing new table_columns quantity_ordered 2023-06-27 06:55:59,038:INFO:superset.models.helpers:Importing new table_columns quantity_ordered Importing new table_columns year 2023-06-27 06:55:59,040:INFO:superset.models.helpers:Importing new table_columns year Importing new table_columns postal_code 2023-06-27 06:55:59,042:INFO:superset.models.helpers:Importing new table_columns postal_code Importing new table_columns customer_name 2023-06-27 06:55:59,046:INFO:superset.models.helpers:Importing new table_columns customer_name Importing new table_columns deal_size 2023-06-27 06:55:59,050:INFO:superset.models.helpers:Importing new table_columns deal_size Importing new table_columns state 2023-06-27 06:55:59,053:INFO:superset.models.helpers:Importing new table_columns state Importing new table_columns status 2023-06-27 06:55:59,056:INFO:superset.models.helpers:Importing new table_columns status Importing new table_columns order_line_number 2023-06-27 06:55:59,059:INFO:superset.models.helpers:Importing new table_columns order_line_number Importing new table_columns order_number 2023-06-27 06:55:59,063:INFO:superset.models.helpers:Importing new table_columns order_number Importing new table_columns month 2023-06-27 06:55:59,068:INFO:superset.models.helpers:Importing new table_columns month Importing new table_columns quarter 2023-06-27 06:55:59,072:INFO:superset.models.helpers:Importing new table_columns quarter Importing new table_columns msrp 2023-06-27 06:55:59,075:INFO:superset.models.helpers:Importing new table_columns msrp Importing new table_columns product_code 2023-06-27 06:55:59,079:INFO:superset.models.helpers:Importing new table_columns product_code Importing new table_columns product_line 2023-06-27 06:55:59,083:INFO:superset.models.helpers:Importing new table_columns product_line Importing new table_columns city 2023-06-27 06:55:59,086:INFO:superset.models.helpers:Importing new table_columns city Importing new table_columns country 2023-06-27 06:55:59,089:INFO:superset.models.helpers:Importing new table_columns country Importing new table_columns phone 2023-06-27 06:55:59,091:INFO:superset.models.helpers:Importing new table_columns phone Importing new table_columns territory 2023-06-27 06:55:59,094:INFO:superset.models.helpers:Importing new table_columns territory Couldn't check if table cleaned_sales_data exists, assuming it does 2023-06-27 06:56:04,114:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table cleaned_sales_data exists, assuming it does Importing new tables main.users 2023-06-27 06:56:04,125:INFO:superset.models.helpers:Importing new tables main.users Dataset has no database will retry with database_id to set permission 2023-06-27 06:56:04,128:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:56:04,145:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns updated 2023-06-27 06:56:04,153:INFO:superset.models.helpers:Importing new table_columns updated Importing new table_columns has_2fa 2023-06-27 06:56:04,160:INFO:superset.models.helpers:Importing new table_columns has_2fa Importing new table_columns real_name 2023-06-27 06:56:04,167:INFO:superset.models.helpers:Importing new table_columns real_name Importing new table_columns tz_label 2023-06-27 06:56:04,174:INFO:superset.models.helpers:Importing new table_columns tz_label Importing new table_columns team_id 2023-06-27 06:56:04,179:INFO:superset.models.helpers:Importing new table_columns team_id Importing new table_columns name 2023-06-27 06:56:04,183:INFO:superset.models.helpers:Importing new table_columns name Importing new table_columns color 2023-06-27 06:56:04,187:INFO:superset.models.helpers:Importing new table_columns color Importing new table_columns id 2023-06-27 06:56:04,190:INFO:superset.models.helpers:Importing new table_columns id Importing new table_columns tz 2023-06-27 06:56:04,193:INFO:superset.models.helpers:Importing new table_columns tz Importing new table_columns is_ultra_restricted 2023-06-27 06:56:04,196:INFO:superset.models.helpers:Importing new table_columns is_ultra_restricted Importing new table_columns is_primary_owner 2023-06-27 06:56:04,199:INFO:superset.models.helpers:Importing new table_columns is_primary_owner Importing new table_columns is_app_user 2023-06-27 06:56:04,203:INFO:superset.models.helpers:Importing new table_columns is_app_user Importing new table_columns is_admin 2023-06-27 06:56:04,206:INFO:superset.models.helpers:Importing new table_columns is_admin Importing new table_columns is_bot 2023-06-27 06:56:04,210:INFO:superset.models.helpers:Importing new table_columns is_bot Importing new table_columns is_restricted 2023-06-27 06:56:04,213:INFO:superset.models.helpers:Importing new table_columns is_restricted Importing new table_columns is_owner 2023-06-27 06:56:04,216:INFO:superset.models.helpers:Importing new table_columns is_owner Importing new table_columns deleted 2023-06-27 06:56:04,220:INFO:superset.models.helpers:Importing new table_columns deleted Importing new table_columns tz_offset 2023-06-27 06:56:04,224:INFO:superset.models.helpers:Importing new table_columns tz_offset Couldn't check if table users exists, assuming it does 2023-06-27 06:56:09,246:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table users exists, assuming it does Importing new tables main.covid_vaccines 2023-06-27 06:56:09,256:INFO:superset.models.helpers:Importing new tables main.covid_vaccines Dataset has no database will retry with database_id to set permission 2023-06-27 06:56:09,259:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:56:09,277:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns clinical_stage 2023-06-27 06:56:09,282:INFO:superset.models.helpers:Importing new table_columns clinical_stage Importing new table_columns fda_approved_indications 2023-06-27 06:56:09,287:INFO:superset.models.helpers:Importing new table_columns fda_approved_indications Importing new table_columns anticipated_next_steps 2023-06-27 06:56:09,291:INFO:superset.models.helpers:Importing new table_columns anticipated_next_steps Importing new table_columns ioc_country_code 2023-06-27 06:56:09,295:INFO:superset.models.helpers:Importing new table_columns ioc_country_code Importing new table_columns clinical_trials_for_other_diseases_or_related_use 2023-06-27 06:56:09,299:INFO:superset.models.helpers:Importing new table_columns clinical_trials_for_other_diseases_or_related_use Importing new table_columns country_name 2023-06-27 06:56:09,304:INFO:superset.models.helpers:Importing new table_columns country_name Importing new table_columns product_category 2023-06-27 06:56:09,308:INFO:superset.models.helpers:Importing new table_columns product_category Importing new table_columns clinical_trials 2023-06-27 06:56:09,311:INFO:superset.models.helpers:Importing new table_columns clinical_trials Importing new table_columns date_last_updated 2023-06-27 06:56:09,313:INFO:superset.models.helpers:Importing new table_columns date_last_updated Importing new table_columns product_description 2023-06-27 06:56:09,317:INFO:superset.models.helpers:Importing new table_columns product_description Importing new table_columns developer_or_researcher 2023-06-27 06:56:09,320:INFO:superset.models.helpers:Importing new table_columns developer_or_researcher Importing new table_columns stage_of_development 2023-06-27 06:56:09,323:INFO:superset.models.helpers:Importing new table_columns stage_of_development Importing new table_columns funder 2023-06-27 06:56:09,326:INFO:superset.models.helpers:Importing new table_columns funder Importing new table_columns published_results 2023-06-27 06:56:09,328:INFO:superset.models.helpers:Importing new table_columns published_results Importing new table_columns sources 2023-06-27 06:56:09,332:INFO:superset.models.helpers:Importing new table_columns sources Importing new table_columns treatment_vs_vaccine 2023-06-27 06:56:09,335:INFO:superset.models.helpers:Importing new table_columns treatment_vs_vaccine Couldn't check if table covid_vaccines exists, assuming it does 2023-06-27 06:56:14,358:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table covid_vaccines exists, assuming it does Importing new tables main.exported_stats 2023-06-27 06:56:14,379:INFO:superset.models.helpers:Importing new tables main.exported_stats Dataset has no database will retry with database_id to set permission 2023-06-27 06:56:14,382:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:56:14,400:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns new_members 2023-06-27 06:56:14,406:INFO:superset.models.helpers:Importing new table_columns new_members Importing new table_columns percent_of_messages_private_channels 2023-06-27 06:56:14,410:INFO:superset.models.helpers:Importing new table_columns percent_of_messages_private_channels Importing new table_columns percent_of_messages_public_channels 2023-06-27 06:56:14,414:INFO:superset.models.helpers:Importing new table_columns percent_of_messages_public_channels Importing new table_columns percent_of_views_private_channels 2023-06-27 06:56:14,417:INFO:superset.models.helpers:Importing new table_columns percent_of_views_private_channels Importing new table_columns percent_of_views_public_channels 2023-06-27 06:56:14,420:INFO:superset.models.helpers:Importing new table_columns percent_of_views_public_channels Importing new table_columns percent_of_messages_dms 2023-06-27 06:56:14,424:INFO:superset.models.helpers:Importing new table_columns percent_of_messages_dms Importing new table_columns percent_of_views_dms 2023-06-27 06:56:14,427:INFO:superset.models.helpers:Importing new table_columns percent_of_views_dms Importing new table_columns date 2023-06-27 06:56:14,430:INFO:superset.models.helpers:Importing new table_columns date Importing new table_columns daily_members_posting_messages 2023-06-27 06:56:14,433:INFO:superset.models.helpers:Importing new table_columns daily_members_posting_messages Importing new table_columns messages_in_shared_channels 2023-06-27 06:56:14,435:INFO:superset.models.helpers:Importing new table_columns messages_in_shared_channels Importing new table_columns messages_in_private_channels 2023-06-27 06:56:14,438:INFO:superset.models.helpers:Importing new table_columns messages_in_private_channels Importing new table_columns messages_in_public_channels 2023-06-27 06:56:14,442:INFO:superset.models.helpers:Importing new table_columns messages_in_public_channels Importing new table_columns weekly_members_posting_messages 2023-06-27 06:56:14,445:INFO:superset.models.helpers:Importing new table_columns weekly_members_posting_messages Importing new table_columns public_channels_single_workspace 2023-06-27 06:56:14,448:INFO:superset.models.helpers:Importing new table_columns public_channels_single_workspace Importing new table_columns messages_in_dms 2023-06-27 06:56:14,451:INFO:superset.models.helpers:Importing new table_columns messages_in_dms Importing new table_columns daily_active_members 2023-06-27 06:56:14,456:INFO:superset.models.helpers:Importing new table_columns daily_active_members Importing new table_columns weekly_active_members 2023-06-27 06:56:14,460:INFO:superset.models.helpers:Importing new table_columns weekly_active_members Importing new table_columns full_members 2023-06-27 06:56:14,463:INFO:superset.models.helpers:Importing new table_columns full_members Importing new table_columns messages_posted 2023-06-27 06:56:14,467:INFO:superset.models.helpers:Importing new table_columns messages_posted Importing new table_columns total_membership 2023-06-27 06:56:14,471:INFO:superset.models.helpers:Importing new table_columns total_membership Importing new table_columns guests 2023-06-27 06:56:14,475:INFO:superset.models.helpers:Importing new table_columns guests Importing new table_columns name 2023-06-27 06:56:14,478:INFO:superset.models.helpers:Importing new table_columns name Couldn't check if table exported_stats exists, assuming it does 2023-06-27 06:56:19,500:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table exported_stats exists, assuming it does Importing new tables main.messages 2023-06-27 06:56:19,516:INFO:superset.models.helpers:Importing new tables main.messages Dataset has no database will retry with database_id to set permission 2023-06-27 06:56:19,520:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:56:19,539:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns bot_profileupdated 2023-06-27 06:56:19,543:INFO:superset.models.helpers:Importing new table_columns bot_profileupdated Importing new table_columns last_read 2023-06-27 06:56:19,546:INFO:superset.models.helpers:Importing new table_columns last_read Importing new table_columns ts 2023-06-27 06:56:19,549:INFO:superset.models.helpers:Importing new table_columns ts Importing new table_columns bot_profileteam_id 2023-06-27 06:56:19,552:INFO:superset.models.helpers:Importing new table_columns bot_profile__team_id Importing new table_columns bot_profileapp_id 2023-06-27 06:56:19,554:INFO:superset.models.helpers:Importing new table_columns bot_profileapp_id Importing new table_columns bot_profilename 2023-06-27 06:56:19,557:INFO:superset.models.helpers:Importing new table_columns bot_profilename Importing new table_columns bot_profileid 2023-06-27 06:56:19,561:INFO:superset.models.helpers:Importing new table_columns bot_profileid Importing new table_columns parent_user_id 2023-06-27 06:56:19,564:INFO:superset.models.helpers:Importing new table_columns parent_user_id Importing new table_columns client_msg_id 2023-06-27 06:56:19,567:INFO:superset.models.helpers:Importing new table_columns client_msg_id Importing new table_columns iconsemoji 2023-06-27 06:56:19,570:INFO:superset.models.helpers:Importing new table_columns icons__emoji Importing new table_columns channel_id 2023-06-27 06:56:19,575:INFO:superset.models.helpers:Importing new table_columns channel_id Importing new table_columns source_team 2023-06-27 06:56:19,578:INFO:superset.models.helpers:Importing new table_columns source_team Importing new table_columns thread_ts 2023-06-27 06:56:19,581:INFO:superset.models.helpers:Importing new table_columns thread_ts ... Importing new table_columns reply_users_count 2023-06-27 06:56:19,660:INFO:superset.models.helpers:Importing new table_columns reply_users_count Importing new table_columns unread_count 2023-06-27 06:56:19,663:INFO:superset.models.helpers:Importing new table_columns unread_count Importing new table_columns reply_count 2023-06-27 06:56:19,666:INFO:superset.models.helpers:Importing new table_columns reply_count Importing new table_columns file_ids 2023-06-27 06:56:19,669:INFO:superset.models.helpers:Importing new table_columns file_ids Importing new table_columns pinned_to 2023-06-27 06:56:19,672:INFO:superset.models.helpers:Importing new table_columns pinned_to Importing new table_columns reply_users 2023-06-27 06:56:19,675:INFO:superset.models.helpers:Importing new table_columns reply_users Importing new table_columns reactions 2023-06-27 06:56:19,678:INFO:superset.models.helpers:Importing new table_columns reactions Importing new table_columns blocks 2023-06-27 06:56:19,680:INFO:superset.models.helpers:Importing new table_columns blocks Couldn't check if table messages exists, assuming it does 2023-06-27 06:56:24,702:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table messages exists, assuming it does Importing new tables main.video_game_sales 2023-06-27 06:56:24,712:INFO:superset.models.helpers:Importing new tables main.video_game_sales Dataset has no database will retry with database_id to set permission 2023-06-27 06:56:24,715:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:56:24,732:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns year 2023-06-27 06:56:24,739:INFO:superset.models.helpers:Importing new table_columns year Importing new table_columns na_sales 2023-06-27 06:56:24,746:INFO:superset.models.helpers:Importing new table_columns na_sales Importing new table_columns eu_sales 2023-06-27 06:56:24,754:INFO:superset.models.helpers:Importing new table_columns eu_sales Importing new table_columns global_sales 2023-06-27 06:56:24,761:INFO:superset.models.helpers:Importing new table_columns global_sales Importing new table_columns jp_sales 2023-06-27 06:56:24,764:INFO:superset.models.helpers:Importing new table_columns jp_sales Importing new table_columns other_sales 2023-06-27 06:56:24,767:INFO:superset.models.helpers:Importing new table_columns other_sales Importing new table_columns rank 2023-06-27 06:56:24,770:INFO:superset.models.helpers:Importing new table_columns rank Importing new table_columns genre 2023-06-27 06:56:24,773:INFO:superset.models.helpers:Importing new table_columns genre Importing new table_columns name 2023-06-27 06:56:24,776:INFO:superset.models.helpers:Importing new table_columns name Importing new table_columns platform 2023-06-27 06:56:24,779:INFO:superset.models.helpers:Importing new table_columns platform Importing new table_columns publisher 2023-06-27 06:56:24,783:INFO:superset.models.helpers:Importing new table_columns publisher Couldn't check if table video_game_sales exists, assuming it does 2023-06-27 06:56:29,804:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table video_game_sales exists, assuming it does Importing new tables main.channel_members 2023-06-27 06:56:29,826:INFO:superset.models.helpers:Importing new tables main.channel_members Dataset has no database will retry with database_id to set permission 2023-06-27 06:56:29,830:WARNING:superset.security.manager:Dataset has no database will retry with database_id to set permission Importing new sql_metrics count 2023-06-27 06:56:29,848:INFO:superset.models.helpers:Importing new sql_metrics count Importing new table_columns channel_id 2023-06-27 06:56:29,853:INFO:superset.models.helpers:Importing new table_columns channel_id Importing new table_columns user_id 2023-06-27 06:56:29,859:INFO:superset.models.helpers:Importing new table_columns user_id Couldn't check if table channel_members exists, assuming it does 2023-06-27 06:56:34,880:WARNING:superset.datasets.commands.importers.v1.utils:Couldn't check if table channel_members exists, assuming it does Importing new slices Total Items Sold 2023-06-27 06:56:34,904:INFO:superset.models.helpers:Importing new slices Total Items Sold

Environment

$ docker images REPOSITORY TAG IMAGE ID CREATED SIZE apache/superset latest 7502beb92ce5 15 hours ago 1.11GB

Running on Ubuntu 20.04 in WSL 2 on Windows 10 / Docker Desktop

Many thanks for any assistance!

moelfus commented 1 year ago

I was facing the same problem. I re-setup everything with a mysql backend and:

  1. superset upgrade db
  2. superset init
  3. superset load-examples

And I don't face the problems mentioned above, even though the warnings still appear.

onestarshang commented 11 months ago

have the same problems

sebastianliebscher commented 10 months ago

Hi @pcrozer does this issue still persist for you? I could not reproduce this with Superset 3.0.1. Can you provide more info about steps to reproduce?

dbaltor commented 8 months ago

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.

rusackas commented 4 months ago

This issue hasn't been touched since last year, so I'm assuming folks here have either solved it or moved along somehow. Let me know if you think it's a problem closing this, and I'll be happy to reopen it.

dbaltor commented 4 months ago

I had to deploy Superset without the examples to move forward. It's a shame as I think it would be helpful to have them around in some lower environments. I'd like to see this solved.

rusackas commented 4 months ago

@dbaltor the original bug reported is quote old... what issues are you facing? I run docker compose on each and every release to test the example dashboards, and they've all been fine. In fact, I'm testing the new 3.1.3 and 4.0.1 release candidates today, and all seems well so far.

MohamedRhimii commented 3 months ago

I'm viewing a similar issue. All load_examples dashboards are created on helm upgrade --install. But whenever I helm upgrade again, the dashboards/charts related to examples seem to be returning same issues as reported here.

Running manually these steps in the superset pod fixes the dashboards/charts again:

Is there anyway to persist them? Cache them? I want to get rid of this behaviour.

rusackas commented 3 months ago

@betodealmeida or @sadpandajoe might have some insights on that.

dbaltor commented 2 months ago

Thanks @rusackas for replying and apologies for not being able to look into this before. I'm still facing the same issues with the examples after upgrading the helm chart to the latest version, 0.12.11 which deploys Superset 4.0.1 on Kubernetes. Given that you're running it on compose and I'm using K8s, I think the issue isn't with the code but instead with the installation process, in other words, it might well be an issue with the helm chart. After reading the @MohamedRhimii comments above, I gave it a whirl and run superset load-examples in the superset pod. That fixed the examples over here as well.

dbaltor commented 1 month ago

Can we get this issue reopened please?

MohamedRhimii commented 1 month ago

@dbaltor I'm happy my workaround worked for you. This issue should be adressed, anyone has an idea of a possible permanent fix?

rusackas commented 1 month ago

Reopened... any updated context folks can add (versions, logs, errors, etc) to recapitulate the situation would probably help.

MohamedRhimii commented 1 month ago

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.

screenshot-example

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!

rusackas commented 1 month ago

Curious if @dosu-bot has any light to shed on this

dbaltor commented 1 month ago

The same issue with the latest version when deployed on Kubernetes: Superset "4.0.1", helm chart version: "0.12.11". The logs are exactly like above.