Navid61 commented on issue #20914:
URL: https://github.com/apache/superset/issues/20914#issuecomment-1199215119
I got this error, I think this version is not stable!
-----------------------------------------------------------------------------
WARNING
--------------------------------------------------------------------------------
A Default SECRET_KEY was detected, please use superset_config.py to override
it.
Use a strong complex alphanumeric string and use a tool to help you generate
a sufficiently random sequence, ex: openssl rand -base64 42
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
logging was configured successfully
2022-07-29 16:48:39,145:INFO:superset.utils.logging_configurator:logging was
configured successfully
2022-07-29 16:48:39,152:INFO:root:Configured event logger of type <class
'superset.utils.log.DBEventLogger'>
Falling back to the built-in cache, that stores data in the metadata
database, for the following cache: `FILTER_STATE_CACHE_CONFIG`. It is
recommended to use `RedisCache`, `MemcachedCache` or another dedicated caching
backend for production deployments
2022-07-29 16:48:39,156:WARNING:superset.utils.cache_manager:Falling back to
the built-in cache, that stores data in the metadata database, for the
following cache: `FILTER_STATE_CACHE_CONFIG`. It is recommended to use
`RedisCache`, `MemcachedCache` or another dedicated caching backend for
production deployments
Falling back to the built-in cache, that stores data in the metadata
database, for the following cache: `EXPLORE_FORM_DATA_CACHE_CONFIG`. It is
recommended to use `RedisCache`, `MemcachedCache` or another dedicated caching
backend for production deployments
2022-07-29 16:48:39,161:WARNING:superset.utils.cache_manager:Falling back to
the built-in cache, that stores data in the metadata database, for the
following cache: `EXPLORE_FORM_DATA_CACHE_CONFIG`. It is recommended to use
`RedisCache`, `MemcachedCache` or another dedicated caching backend for
production deployments
No PIL installation found
2022-07-29 16:48:39,419:INFO:superset.utils.screenshots:No PIL installation
found
Syncing role definition
2022-07-29 16:48:42,015:INFO:superset.security.manager:Syncing role
definition
Syncing Admin perms
2022-07-29 16:48:42,027:INFO:superset.security.manager:Syncing Admin perms
Syncing Alpha perms
2022-07-29 16:48:42,110:INFO:superset.security.manager:Syncing Alpha perms
Syncing Gamma perms
2022-07-29 16:48:42,187:INFO:superset.security.manager:Syncing Gamma perms
Syncing granter perms
2022-07-29 16:48:42,265:INFO:superset.security.manager:Syncing granter perms
Syncing sql_lab perms
2022-07-29 16:48:42,343:INFO:superset.security.manager:Syncing sql_lab perms
Fetching a set of all perms to lookup which ones are missing
2022-07-29 16:48:42,418:INFO:superset.security.manager:Fetching a set of all
perms to lookup which ones are missing
Creating missing datasource permissions.
2022-07-29 16:48:42,488:INFO:superset.security.manager:Creating missing
datasource permissions.
Traceback (most recent call last):
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line
1276, in _execute_context
self.dialect.do_execute(
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py",
line 608, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: tables
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/sigma/venv/bin/superset", line 11, in <module>
load_entry_point('apache-superset', 'console_scripts', 'superset')()
File "/home/sigma/venv/lib/python3.9/site-packages/click/core.py", line
1128, in __call__
return self.main(*args, **kwargs)
File "/home/sigma/venv/lib/python3.9/site-packages/flask/cli.py", line
601, in main
return super().main(*args, **kwargs)
File "/home/sigma/venv/lib/python3.9/site-packages/click/core.py", line
1053, in main
rv = self.invoke(ctx)
File "/home/sigma/venv/lib/python3.9/site-packages/click/core.py", line
1659, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/home/sigma/venv/lib/python3.9/site-packages/click/core.py", line
1395, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/home/sigma/venv/lib/python3.9/site-packages/click/core.py", line
754, in invoke
return __callback(*args, **kwargs)
File "/home/sigma/venv/lib/python3.9/site-packages/click/decorators.py",
line 26, in new_func
return f(get_current_context(), *args, **kwargs)
File "/home/sigma/venv/lib/python3.9/site-packages/flask/cli.py", line
445, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/home/sigma/venv/lib/python3.9/site-packages/click/core.py", line
754, in invoke
return __callback(*args, **kwargs)
File "/home/sigma/venv/lib/python3.9/site-packages/click/decorators.py",
line 26, in new_func
return f(get_current_context(), *args, **kwargs)
File "/home/sigma/venv/lib/python3.9/site-packages/flask/cli.py", line
445, in decorator
return __ctx.invoke(f, *args, **kwargs)
File "/home/sigma/venv/lib/python3.9/site-packages/click/core.py", line
754, in invoke
return __callback(*args, **kwargs)
File
"/home/sigma/Downloads/apache-superset-2.0.0rc2/superset/cli/main.py", line 62,
in init
security_manager.sync_role_definitions()
File
"/home/sigma/Downloads/apache-superset-2.0.0rc2/superset/security/manager.py",
line 731, in sync_role_definitions
self.create_missing_perms()
File
"/home/sigma/Downloads/apache-superset-2.0.0rc2/superset/security/manager.py",
line 677, in create_missing_perms
datasources = ConnectorRegistry.get_all_datasources(self.get_session)
File
"/home/sigma/Downloads/apache-superset-2.0.0rc2/superset/connectors/connector_registry.py",
line 74, in get_all_datasources
datasources.extend(qry.all())
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line
3373, in all
return list(self)
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line
3535, in __iter__
return self._execute_and_instances(context)
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line
3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line
1011, in execute
return meth(self, multiparams, params)
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line
298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line
1124, in _execute_clauseelement
ret = self._execute_context(
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line
1316, in _execute_context
self._handle_dbapi_exception(
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line
1510, in _handle_dbapi_exception
util.raise_(
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line
182, in raise_
raise exception
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line
1276, in _execute_context
self.dialect.do_execute(
File
"/home/sigma/venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py",
line 608, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table:
tables
[SQL: SELECT tables.uuid AS tables_uuid, tables.created_on AS
tables_created_on, tables.changed_on AS tables_changed_on, tables.id AS
tables_id, tables.description AS tables_description, tables.default_endpoint AS
tables_default_endpoint, tables.is_featured AS tables_is_featured,
tables.filter_select_enabled AS tables_filter_select_enabled, tables."offset"
AS tables_offset, tables.cache_timeout AS tables_cache_timeout, tables.params
AS tables_params, tables.perm AS tables_perm, tables.schema_perm AS
tables_schema_perm, tables.is_managed_externally AS
tables_is_managed_externally, tables.external_url AS tables_external_url,
tables.table_name AS tables_table_name, tables.main_dttm_col AS
tables_main_dttm_col, tables.database_id AS tables_database_id,
tables.fetch_values_predicate AS tables_fetch_values_predicate, tables.schema
AS tables_schema, tables.sql AS tables_sql, tables.is_sqllab_view AS
tables_is_sqllab_view, tables.template_params AS tables_template_params,
tables.extra AS
tables_extra, tables.created_by_fk AS tables_created_by_fk,
tables.changed_by_fk AS tables_changed_by_fk
FROM tables
WHERE tables.is_sqllab_view = 0]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]