After upgrade from version 8 to 10 I am getting an error in Queries in UI and "Could not enqueue query" in logs #6834
DanielRowe1
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I am getting this error in the UI when clicking on queries:
[2024-03-28 05:34:16,213][PID:6][ERROR][redash.app] Exception on /api/data_sources/2 [GET]
Traceback (most recent call last):
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request
return self.view_functionsrule.endpoint
File "/usr/local/lib/python3.7/site-packages/flask_restful/init.py", line 458, in wrapper
resp = resource(*args, **kwargs)
File "/usr/local/lib/python3.7/site-packages/flask_login/utils.py", line 261, in decorated_view
return func(*args, **kwargs)
File "/usr/local/lib/python3.7/site-packages/flask/views.py", line 89, in view
return self.dispatch_request(*args, **kwargs)
File "/app/redash/handlers/base.py", line 33, in dispatch_request
return super(BaseResource, self).dispatch_request(*args, **kwargs)
File "/usr/local/lib/python3.7/site-packages/flask_restful/init.py", line 573, in dispatch_request
resp = meth(*args, **kwargs)
File "/app/redash/handlers/data_sources.py", line 47, in get
ds = data_source.to_dict(all=self.current_user.has_permission("admin"))
File "/app/redash/models/init.py", line 122, in to_dict
"syntax": self.query_runner.syntax,
AttributeError: 'NoneType' object has no attribute 'syntax'
Seeing this in the logs:
[2024-03-28 05:34:21,900][PID:16][INFO][root] Could not enqueue query 1 due to AttributeError("'NoneType' object has no attribute 'apply_auto_limit'")
[2024-03-28 05:34:21,901][PID:16][INFO][root] Could not enqueue query 2 due to AttributeError("'NoneType' object has no attribute 'apply_auto_limit'")
I did the DB upgrade and this seems to work:
[2024-03-28 05:31:49,787][PID:1][INFO][alembic.runtime.migration] Context impl PostgresqlImpl.
[2024-03-28 05:31:49,788][PID:1][INFO][alembic.runtime.migration] Will assume transactional DDL.
[2024-03-28 05:31:49,806][PID:1][INFO][alembic.runtime.migration] Running upgrade e5c7a4e2df4d -> d7d747033183, encrypt alert destinations
[2024-03-28 05:31:49,814][PID:1][INFO][alembic.runtime.migration] Running upgrade e5c7a4e2df4d -> 0ec979123ba4, empty message
[2024-03-28 05:31:49,816][PID:1][INFO][alembic.runtime.migration] Running upgrade 0ec979123ba4, d7d747033183 -> 89bc7873a3e0, fix_multiple_heads
exit code: 0
I am not sure what the issue is.
Thanks for any help.
Beta Was this translation helpful? Give feedback.
All reactions