GitHub user Nimishbansal-16 added a comment to the discussion: Unable to
activate async querying in superset 5.0.0
@dosu
In SQLALCHEMY_DATABASE_URI, I have a mysql uri which is accessible by both.
Here is the full stack trace:
`[2025-06-26 06:24:53,544: INFO/ForkPoolWorker-2] Backing off get_query(...)
for 0.1s (superset.sql_lab.SqlLabException: Failed at getting query)
[2025-06-26 06:24:53,544: ERROR/ForkPoolWorker-2] Query with id `103` could not
be retrieved
Traceback (most recent call last):
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/superset/sql_lab.py",
line 160, in get_query
return db.session.query(Query).filter_by(id=query_id).one()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py",
line 2870, in one
return self._iter().one()
^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py",
line 1522, in one
return self._only_one_row(
^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py",
line 562, in _only_one_row
raise exc.NoResultFound(
sqlalchemy.exc.NoResultFound: No row was found when one was required
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/backoff/_sync.py",
line 105, in retry
ret = target(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/superset/sql_lab.py",
line 162, in get_query
raise SqlLabException("Failed at getting query") from ex
superset.sql_lab.SqlLabException: Failed at getting query
[2025-06-26 06:24:53,545: ERROR/ForkPoolWorker-2] Query 103: Sleeping for a sec
before retrying...
Traceback (most recent call last):
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/superset/sql_lab.py",
line 160, in get_query
return db.session.query(Query).filter_by(id=query_id).one()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py",
line 2870, in one
return self._iter().one()
^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py",
line 1522, in one
return self._only_one_row(
^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py",
line 562, in _only_one_row
raise exc.NoResultFound(
sqlalchemy.exc.NoResultFound: No row was found when one was required
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/backoff/_sync.py",
line 105, in retry
ret = target(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/superset/sql_lab.py",
line 162, in get_query
raise SqlLabException("Failed at getting query") from ex
superset.sql_lab.SqlLabException: Failed at getting query
[2025-06-26 06:24:53,679: INFO/ForkPoolWorker-2] Backing off get_query(...) for
0.3s (superset.sql_lab.SqlLabException: Failed at getting query)
[2025-06-26 06:24:53,679: ERROR/ForkPoolWorker-2] Query with id `103` could not
be retrieved
Traceback (most recent call last):
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/superset/sql_lab.py",
line 160, in get_query
return db.session.query(Query).filter_by(id=query_id).one()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py",
line 2870, in one
return self._iter().one()
^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py",
line 1522, in one
return self._only_one_row(
^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py",
line 562, in _only_one_row
raise exc.NoResultFound(
sqlalchemy.exc.NoResultFound: No row was found when one was required
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/backoff/_sync.py",
line 105, in retry
ret = target(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/superset/sql_lab.py",
line 162, in get_query
raise SqlLabException("Failed at getting query") from ex
superset.sql_lab.SqlLabException: Failed at getting query
[2025-06-26 06:24:53,680: ERROR/ForkPoolWorker-2] Query 103: Sleeping for a sec
before retrying...
Traceback (most recent call last):
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/superset/sql_lab.py",
line 160, in get_query
return db.session.query(Query).filter_by(id=query_id).one()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py",
line 2870, in one
return self._iter().one()
^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py",
line 1522, in one
return self._only_one_row(
^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/sqlalchemy/engine/result.py",
line 562, in _only_one_row
raise exc.NoResultFound(
sqlalchemy.exc.NoResultFound: No row was found when one was required
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/backoff/_sync.py",
line 105, in retry
ret = target(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^
File
"/home/ubuntu/superset_5.0.0_venv/lib/python3.11/site-packages/superset/sql_lab.py",
line 162, in get_query
raise SqlLabException("Failed at getting query") from ex
superset.sql_lab.SqlLabException: Failed at getting query`
GitHub link:
https://github.com/apache/superset/discussions/33920#discussioncomment-13592645
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
