fzhan commented on issue #29611: URL: https://github.com/apache/superset/issues/29611#issuecomment-2362522412
Just tried running the example in docker compose: https://superset.apache.org/docs/installation/docker-compose/ and the error persists: ``` 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.10/site-packages/flask/app.py", line 1484, in full_dispatch_request superset_app | rv = self.dispatch_request() superset_app | File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request superset_app | return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) superset_app | File "/usr/local/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 177, in wraps superset_app | return f(self, *args, **kwargs) superset_app | File "/app/superset/views/sql_lab/views.py", line 239, in post superset_app | db.session.query(TableSchema).filter( superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 3222, in delete superset_app | result = self.session.execute( superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1717, in execute superset_app | result = conn._execute_20(statement, params or {}, execution_options) superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1710, in _execute_20 superset_app | return meth(self, args_10style, kwargs_10style, execution_options) superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection superset_app | return connection._execute_clauseelement( superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1577, in _execute_clauseelement superset_app | ret = self._execute_context( superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context superset_app | self._handle_dbapi_exception( superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2134, in _handle_dbapi_exception superset_app | util.raise_( superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ superset_app | raise exception superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context superset_app | self.dialect.do_execute( superset_app | File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute superset_app | cursor.execute(statement, parameters) superset_app | sqlalchemy.exc.DataError: (psycopg2.errors.InvalidTextRepresentation) invalid input syntax for type integer: "tWZzbZWySAW" superset_app | LINE 1: ...OM table_schema WHERE table_schema.tab_state_id = 'tWZzbZWyS... superset_app | ^ superset_app | superset_app | [SQL: DELETE FROM table_schema WHERE table_schema.tab_state_id = %(tab_state_id_1)s AND table_schema.database_id = %(database_id_1)s AND table_schema.catalog IS NULL AND table_schema.schema = %(schema_1)s AND table_schema."table" = %(table_1)s] superset_app | [parameters: {'tab_state_id_1': 'tWZzbZWySAW', 'database_id_1': 1, 'schema_1': 'public', 'table_1': 'bart_lines'}] superset_app | (Background on this error at: https://sqlalche.me/e/14/9h9h) ``` -- 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]
