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 2021/02/26 07:11:57 UTC

[GitHub] [superset] iercan removed a comment on issue #12766: Global Async Queries doesn't work

iercan removed a comment on issue #12766:
URL: https://github.com/apache/superset/issues/12766#issuecomment-786458442


   @robdiciuccio I'm still getting errors. 
   
   ```
   worker_1    | [2021-02-26 07:05:27,835: INFO/ForkPoolWorker-7] Cache key: fd68af649f2858ffb1156862272ba704
   worker_1    | Serving from cache
   worker_1    | [2021-02-26 07:05:27,836: INFO/ForkPoolWorker-7] Serving from cache
   worker_1    | Cache key: 926fcd84c4ea3e42956ae51436269022
   worker_1    | Cache key: a98643384e8bc016e02fe68b97211a32
   worker_1    | [2021-02-26 07:05:27,840: INFO/ForkPoolWorker-1] Cache key: a98643384e8bc016e02fe68b97211a32
   worker_1    | [2021-02-26 07:05:27,840: INFO/ForkPoolWorker-8] Cache key: 926fcd84c4ea3e42956ae51436269022
   worker_1    | Serving from cache
   worker_1    | [2021-02-26 07:05:27,842: INFO/ForkPoolWorker-1] Serving from cache
   worker_1    | Serving from cache
   worker_1    | [2021-02-26 07:05:27,842: INFO/ForkPoolWorker-8] Serving from cache
   worker_1    | Cache key: e497d4025ce15e3ac7f4d1304bbfd1e8
   worker_1    | [2021-02-26 07:05:27,846: INFO/ForkPoolWorker-10] Cache key: e497d4025ce15e3ac7f4d1304bbfd1e8
   worker_1    | Serving from cache
   worker_1    | [2021-02-26 07:05:27,848: INFO/ForkPoolWorker-10] Serving from cache
   worker_1    | [2021-02-26 07:05:27,854: INFO/ForkPoolWorker-1] Task load_explore_json_into_cache[530e7fcb-c6e6-448b-be9b-4ff0307dd745] succeeded in 0.019942453131079674s: None
   worker_1    | Cache key: e3f5fbde933b2a77404ac5ba57910469
   worker_1    | [2021-02-26 07:05:27,861: INFO/ForkPoolWorker-10] Cache key: e3f5fbde933b2a77404ac5ba57910469
   worker_1    | Serving from cache
   worker_1    | [2021-02-26 07:05:27,862: INFO/ForkPoolWorker-10] Serving from cache
   worker_1    | [2021-02-26 07:05:27,864: INFO/ForkPoolWorker-7] Task load_explore_json_into_cache[7e47b489-286a-43e4-9bb4-ff5706aa5050] succeeded in 0.0350632518529892s: None
   worker_1    | [2021-02-26 07:05:27,871: ERROR/ForkPoolWorker-8] Task load_explore_json_into_cache[53952638-59ac-481b-b30f-381469c1b4c8] raised unexpected: NoSuchColumnError("Could not locate column in row for column 'table_columns.id'")
   worker_1    | Traceback (most recent call last):
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/celery/app/trace.py", line 412, in trace_task
   worker_1    |     R = retval = fun(*args, **kwargs)
   worker_1    |   File "/app/superset/app.py", line 116, in __call__
   worker_1    |     return task_base.__call__(self, *args, **kwargs)
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/celery/app/trace.py", line 704, in __protected_call__
   worker_1    |     return self.run(*args, **kwargs)
   worker_1    |   File "/app/superset/tasks/async_queries.py", line 108, in load_explore_json_into_cache
   worker_1    |     raise exc
   worker_1    |   File "/app/superset/tasks/async_queries.py", line 84, in load_explore_json_into_cache
   worker_1    |     payload = viz_obj.get_payload()
   worker_1    |   File "/app/superset/viz.py", line 454, in get_payload
   worker_1    |     columns = set(self.datasource.column_names)
   worker_1    |   File "/app/superset/connectors/base/models.py", line 145, in column_names
   worker_1    |     return sorted([c.column_name for c in self.columns], key=lambda x: x or "")
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/attributes.py", line 287, in __get__
   worker_1    |     return self.impl.get(instance_state(instance), dict_)
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/attributes.py", line 723, in get
   worker_1    |     value = self.callable_(state, passive)
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/strategies.py", line 760, in _load_for_state
   worker_1    |     session, state, primary_key_identity, passive
   worker_1    |   File "<string>", line 1, in <lambda>
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/strategies.py", line 902, in _emit_lazyload
   worker_1    |     .with_post_criteria(set_default_params)
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/ext/baked.py", line 544, in all
   worker_1    |     return list(self)
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/loading.py", line 100, in instances
   worker_1    |     cursor.close()
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/langhelpers.py", line 70, in __exit__
   worker_1    |     with_traceback=exc_tb,
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
   worker_1    |     raise exception
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/loading.py", line 80, in instances
   worker_1    |     rows = [proc(row) for row in fetch]
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/loading.py", line 80, in <listcomp>
   worker_1    |     rows = [proc(row) for row in fetch]
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/loading.py", line 524, in _instance
   worker_1    |     tuple([row[column] for column in pk_cols]),
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/loading.py", line 524, in <listcomp>
   worker_1    |     tuple([row[column] for column in pk_cols]),
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/result.py", line 686, in _key_fallback
   worker_1    |     replace_context=err,
   worker_1    |   File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
   worker_1    |     raise exception
   worker_1    | sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for column 'table_columns.id'"
   
   ```


----------------------------------------------------------------
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



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