You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/04/29 11:38:24 UTC
[GitHub] [superset] rvsoni commented on issue #11080: Upgrade to 0.37.1 has bug: column dbs.allow_cvas does not exist
rvsoni commented on issue #11080:
URL: https://github.com/apache/superset/issues/11080#issuecomment-1113203088
I have just upgraded to 1.4.2 seeing a problem.
superset_app | [SQL: SELECT dbs.uuid AS dbs_uuid, dbs.created_on AS dbs_created_on, dbs.changed_on AS dbs_changed_on, dbs.id AS dbs_id, dbs.verbose_name AS dbs_verbose_name, dbs.database_name AS dbs_database_name, dbs.sqlalchemy_uri AS dbs_sqlalchemy_uri, dbs.password AS dbs_password, dbs.cache_timeout AS dbs_cache_timeout, dbs.select_as_create_table_as AS dbs_select_as_create_table_as, dbs.expose_in_sqllab AS dbs_expose_in_sqllab, dbs.configuration_method AS dbs_configuration_method, dbs.allow_run_async AS dbs_allow_run_async, dbs.allow_csv_upload AS dbs_allow_csv_upload, dbs.allow_ctas AS dbs_allow_ctas, dbs.allow_cvas AS dbs_allow_cvas, dbs.allow_dml AS dbs_allow_dml, dbs.force_ctas_schema AS dbs_force_ctas_schema, dbs.allow_multi_schema_metadata_fetch AS dbs_allow_multi_schema_metadata_fetch, dbs.extra AS dbs_extra, dbs.encrypted_extra AS dbs_encrypted_extra, dbs.impersonate_user AS dbs_impersonate_user, dbs.server_cert AS dbs_server_cert, dbs.created_by_fk AS dbs_c
reated_by_fk, dbs.changed_by_fk AS dbs_changed_by_fk
superset_app | FROM dbs
superset_app | WHERE dbs.id = %(param_1)s]
superset_app | [parameters: {'param_1': 1}]
superset_app | (Background on this error at: http://sqlalche.me/e/13/f405)
superset_app | Traceback (most recent call last):
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
superset_app | self.dialect.do_execute(
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
superset_app | cursor.execute(statement, parameters)
superset_app | psycopg2.errors.UndefinedColumn: column dbs.allow_csv_upload does not exist
superset_app | LINE 1: ...thod, dbs.allow_run_async AS dbs_allow_run_async, dbs.allow_...
superset_app | ^
superset_app |
superset_app |
superset_app | The above exception was the direct cause of the following exception:
superset_app |
superset_app | Traceback (most recent call last):
superset_app | File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1950, in full_dispatch_request
superset_app | rv = self.dispatch_request()
superset_app | File "/usr/local/lib/python3.8/site-packages/flask/app.py", line 1936, in dispatch_request
superset_app | return self.view_functions[rule.endpoint](**req.view_args)
superset_app | File "/usr/local/lib/python3.8/site-packages/flask_appbuilder/security/decorators.py", line 104, in wraps
superset_app | return f(self, *args, **kwargs)
superset_app | File "/app/superset/views/base_api.py", line 85, in wraps
superset_app | raise ex
superset_app | File "/app/superset/views/base_api.py", line 82, in wraps
superset_app | duration, response = time_function(f, self, *args, **kwargs)
superset_app | File "/app/superset/utils/core.py", line 1471, in time_function
superset_app | response = func(*args, **kwargs)
superset_app | File "/app/superset/utils/log.py", line 242, in wrapper
superset_app | value = f(*args, **kwargs)
superset_app | File "/app/superset/charts/api.py", line 736, in data
superset_app | return self.get_data_response(command)
superset_app | File "/app/superset/charts/api.py", line 547, in get_data_response
superset_app | result = command.run(force_cached=force_cached)
superset_app | File "/app/superset/charts/commands/data.py", line 50, in run
superset_app | payload = self._query_context.get_payload(
superset_app | File "/app/superset/common/query_context.py", line 305, in get_payload
superset_app | query_results = [
superset_app | File "/app/superset/common/query_context.py", line 306, in <listcomp>
superset_app | get_query_results(
superset_app | File "/app/superset/common/query_actions.py", line 186, in get_query_results
superset_app | return result_func(query_context, query_obj, force_cached)
superset_app | File "/app/superset/common/query_actions.py", line 98, in _get_full
superset_app | payload = query_context.get_df_payload(query_obj, force_cached=force_cached)
superset_app | File "/app/superset/common/query_context.py", line 468, in get_df_payload
superset_app | query_result = self.get_query_result(query_obj)
superset_app | File "/app/superset/common/query_context.py", line 254, in get_query_result
superset_app | result = self.datasource.query(query_object.to_dict())
superset_app | File "/app/superset/connectors/sqla/models.py", line 1472, in query
superset_app | query_str_ext = self.get_query_str_extended(query_obj)
superset_app | File "/app/superset/connectors/sqla/models.py", line 764, in get_query_str_extended
superset_app | sqlaq = self.get_sqla_query(**query_obj)
superset_app | File "/app/superset/connectors/sqla/models.py", line 1003, in get_sqla_query
superset_app | template_processor = self.get_template_processor(**template_kwargs)
superset_app | File "/app/superset/connectors/sqla/models.py", line 761, in get_template_processor
superset_app | return get_template_processor(table=self, database=self.database, **kwargs)
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/attributes.py", line 294, in __get__
superset_app | return self.impl.get(instance_state(instance), dict_)
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/attributes.py", line 730, in get
superset_app | value = self.callable_(state, passive)
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/strategies.py", line 759, in _load_for_state
superset_app | return self._emit_lazyload(
superset_app | File "<string>", line 1, in <lambda>
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/strategies.py", line 847, in _emit_lazyload
superset_app | q(session)
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/ext/baked.py", line 615, in _load_on_pk_identity
superset_app | result = list(bq.for_session(self.session).params(**params))
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/ext/baked.py", line 444, in __iter__
superset_app | return q._execute_and_instances(context)
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
superset_app | result = conn.execute(querycontext.statement, self._params)
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
superset_app | return meth(self, multiparams, params)
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
superset_app | return connection._execute_clauseelement(self, multiparams, params)
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
superset_app | ret = self._execute_context(
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
superset_app | self._handle_dbapi_exception(
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
superset_app | util.raise_(
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
superset_app | raise exception
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
superset_app | self.dialect.do_execute(
superset_app | File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
superset_app | cursor.execute(statement, parameters)
superset_app | sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column dbs.allow_csv_upload does not exist
superset_app | LINE 1: ...thod, dbs.allow_run_async AS dbs_allow_run_async, dbs.allow_...
superset_app | ^
superset_app |
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org