[GitHub] [incubator-superset] andrewmusselman commented on issue #1690: SQL Lab exception when executed query is not limited or with a limit > SQL_MAX_ROW

[GitBox <gi...@apache.org>]

andrewmusselman commented on issue #1690: SQL Lab exception when executed query is not limited or with a limit > SQL_MAX_ROW
URL: https://github.com/apache/incubator-superset/issues/1690#issuecomment-605686116
 
 
   I'm seeing this same issue when running certain queries with Postgres 9, installed on an EC2 host using these instructions: https://www.dremio.com/visualize-your-data-lake-with-dremio-and-apache-superset
   
   Cloned and checked out hash:
   `git clone https://github.com/apache/incubator-superset.git && cd incubator-superset && git checkout 0cf354c`
   
   
   ```
   Error message:
   
   Sorry, something went wrong
   500 - Internal Server Error
   Stacktrace
   
    Traceback (most recent call last): File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context cursor, statement, parameters, context File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 581, in do_execute cursor.execute(statement, parameters) sqlite3.IntegrityError: column client_id is not unique The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/ec2-user/incubator-superset/superset/views/core.py", line 2310, in sql_json_exec session.flush() File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2479, in flush self._flush(objects) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2617, in _flush transaction.rollback(_capture_exception=True) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__ compat.reraise(exc_type, exc_value, exc_tb) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 153, in reraise raise value File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 2577, in _flush flush_context.execute() File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute rec.execute(self) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute uow, File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 245, in save_obj insert, File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/orm/persistence.py", line 1137, in _emit_insert_statements statement, params File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 982, in execute return meth(self, multiparams, params) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1101, in _execute_clauseelement distilled_params, File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1250, in _execute_context e, statement, parameters, cursor, context File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1476, in _handle_dbapi_exception util.raise_from_cause(sqlalchemy_exception, exc_info) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise raise value.with_traceback(tb) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1246, in _execute_context cursor, statement, parameters, context File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 581, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) column client_id is not unique [SQL: INSERT INTO "query" (extra_json, client_id, database_id, tmp_table_name, user_id, status, tab_name, sql_editor_id, schema, sql, select_sql, executed_sql, "limit", select_as_cta, select_as_cta_used, progress, rows, error_message, results_key, start_time, start_running_time, end_time, end_result_backend_time, tracking_url, changed_on) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: ('{}', 'bSqgSSCA5b', 2, '', '2', 'running', 'Copy of Total views per asset', 'A721kpy2j', 'public', "select\n mtitle\n , date\n , count(*)\nfrom\n (select\n distinct\n m.title as mtitle\n , v.date as date\n , v.ip as ip\n , v.checks ... (51 characters truncated) ... v.checksum = m.checksum\n and m.title like '%Oklahoma%')\n as dist_user_asset_date\ngroup by mtitle, date\norder by mtitle, date, count desc;", None, None, None, 0, 0, 0, None, None, None, 1585469953416.2778, None, None, None, None, '2020-03-29 08:19:13.417183')] (Background on this error at: http://sqlalche.me/e/gkpj) During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/flask/app.py", line 2446, in wsgi_app response = self.full_dispatch_request() File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/flask/app.py", line 1951, in full_dispatch_request rv = self.handle_user_exception(e) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/flask/app.py", line 1820, in handle_user_exception reraise(exc_type, exc_value, tb) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/flask/_compat.py", line 39, in reraise raise value File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request rv = self.dispatch_request() File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "/home/ec2-user/incubator-superset/venv/lib/python3.7/site-packages/flask_appbuilder/security/decorators.py", line 168, in wraps return f(self, *args, **kwargs) File "/home/ec2-user/incubator-superset/superset/utils/log.py", line 59, in wrapper value = f(*args, **kwargs) File "/home/ec2-user/incubator-superset/superset/views/core.py", line 2249, in sql_json return self.sql_json_exec(request.json, log_params) File "/home/ec2-user/incubator-superset/superset/views/core.py", line 2316, in sql_json_exec raise Exception(_("Query record was not created as expected.")) Exception: Query record was not created as expected. ```
   
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org