lilotter45 opened a new issue, #33251: URL: https://github.com/apache/superset/issues/33251
### Bug description When attempting to add a new chart to a dashboard it fails with the error `Sorry, there was an error saving this dashboard: Fatal error` The logs (below) indicate that the table referenced in the query is unknown: `5502, "Getting analyzing error. Detail message: Unknown table 'stg.dim_cow_site_presence_extended'."` This error is true; no such table exists. However, the dataset is defined as using the `dmh` schema, not the `stg` schema.  This issue only arises when attempting to save the dashboard; there is no such error encountered when creating/viewing the chart directly or when running the query in SQL Lab. **Relevant logs**: ``` (pymysql.err.OperationalError) (5502, "Getting analyzing error. Detail message: Unknown table 'stg.dim_cow_site_presence_extended'.") [query removed for brevity] (Background on this error at: https://sqlalche.me/e/14/e3q8) Traceback (most recent call last): File "/mnt/data/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context self.dialect.do_execute( File "/mnt/data/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 153, in execute result = self._query(query) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 322, in _query conn.query(q) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 563, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 825, in _read_query_result result.read() File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 1199, in read first_packet = self.connection._read_packet() File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_packet packet.raise_for_error() File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/err.py", line 150, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (5502, "Getting analyzing error. Detail message: Unknown table 'stg.dim_cow_site_presence_extended'.") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/mnt/data/superset/venv/lib/python3.10/site-packages/flask_appbuilder/api/__init__.py", line 111, in wraps return f(self, *args, **kwargs) File "/mnt/data/superset/venv/lib/python3.10/site-packages/superset/views/base_api.py", line 119, in wraps duration, response = time_function(f, self, *args, **kwargs) File "/mnt/data/superset/venv/lib/python3.10/site-packages/superset/utils/core.py", line 1364, in time_function response = func(*args, **kwargs) File "/mnt/data/superset/venv/lib/python3.10/site-packages/superset/utils/log.py", line 303, in wrapper value = f(*args, **kwargs) File "/mnt/data/superset/venv/lib/python3.10/site-packages/superset/datasource/api.py", line 120, in get_column_values payload = datasource.values_for_column( File "/mnt/data/superset/venv/lib/python3.10/site-packages/superset/models/helpers.py", line 1372, in values_for_column df = pd.read_sql_query(sql=sql, con=engine) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pandas/io/sql.py", line 469, in read_sql_query return pandas_sql.read_query( File "/mnt/data/superset/venv/lib/python3.10/site-packages/pandas/io/sql.py", line 1738, in read_query result = self.execute(sql, params) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pandas/io/sql.py", line 1562, in execute return self.con.exec_driver_sql(sql, *args) File "/mnt/data/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1770, in exec_driver_sql return self._exec_driver_sql( File "/mnt/data/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1674, in _exec_driver_sql ret = self._execute_context( File "/mnt/data/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context self._handle_dbapi_exception( File "/mnt/data/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception util.raise_( File "/mnt/data/superset/venv/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/mnt/data/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context self.dialect.do_execute( File "/mnt/data/superset/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 153, in execute result = self._query(query) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/cursors.py", line 322, in _query conn.query(q) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 563, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 825, in _read_query_result result.read() File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 1199, in read first_packet = self.connection._read_packet() File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/connections.py", line 775, in _read_packet packet.raise_for_error() File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) File "/mnt/data/superset/venv/lib/python3.10/site-packages/pymysql/err.py", line 150, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (5502, "Getting analyzing error. Detail message: Unknown table 'stg.dim_cow_site_presence_extended'.") ``` ### Screenshots/recordings _No response_ ### Superset version 4.1.2 ### Python version 3.10 ### Node version Not applicable ### Browser Chrome ### Additional context - The query/virtual dataset uses jinja templating, with the feature flag `ENABLE_TEMPLATE_PROCESSING` enabled. - The database is StarRocks - Possibly relevant packages: - starrocks, v. 1.2.1 - mysqlclient, v. 2.2.7 - pymysql, v. 2.2.11 - PyMySQL, v. 1.1.1 - SQLAlchemy, v. 1.4.51 ### Checklist - [x] I have searched Superset docs and Slack and didn't find a solution to my problem. - [x] I have searched the GitHub issue tracker and didn't find a similar bug report. - [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- 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]
