Hi, I upgraded redash from v8 to v10 .
But after I upgraded and after a while, I have encountered two bugs.
First, I visit https://[domain]/groups/2/data_sources, I get Internal 500 error.
Second, schema refresh always fails.
I checked the docker-compose logs and, I found error messages.
Here is the error messages. (Those two bugs generate the same error messages)
redash_server_1 | Traceback (most recent call last):
redash_server_1 | File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1949, in full_dispatch_request
redash_server_1 | rv = self.dispatch_request()
redash_server_1 | File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1935, in dispatch_request
redash_server_1 | return self.view_functions[rule.endpoint](**req.view_args)
redash_server_1 | File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 458, in wrapper
redash_server_1 | resp = resource(*args, **kwargs)
redash_server_1 | File "/usr/local/lib/python3.7/site-packages/flask_login/utils.py", line 261, in decorated_view
redash_server_1 | return func(*args, **kwargs)
redash_server_1 | File "/usr/local/lib/python3.7/site-packages/flask/views.py", line 89, in view
redash_server_1 | return self.dispatch_request(*args, **kwargs)
redash_server_1 | File "/app/redash/handlers/base.py", line 33, in dispatch_request
redash_server_1 | return super(BaseResource, self).dispatch_request(*args, **kwargs)
redash_server_1 | File "/usr/local/lib/python3.7/site-packages/flask_restful/__init__.py", line 573, in dispatch_request
redash_server_1 | resp = meth(*args, **kwargs)
redash_server_1 | File "/app/redash/permissions.py", line 71, in decorated
redash_server_1 | return fn(*args, **kwargs)
redash_server_1 | File "/app/redash/handlers/groups.py", line 177, in get
redash_server_1 | return [ds.to_dict(with_permissions_for=group) for ds in data_sources]
redash_server_1 | File "/app/redash/handlers/groups.py", line 177, in <listcomp>
redash_server_1 | return [ds.to_dict(with_permissions_for=group) for ds in data_sources]
redash_server_1 | File "/app/redash/models/__init__.py", line 122, in to_dict
redash_server_1 | "syntax": self.query_runner.syntax,
redash_server_1 | AttributeError: 'NoneType' object has no attribute 'syntax'
redash_server_1 | [2022-08-17 13:58:19,468][PID:31][INFO][metrics] method=GET path=/api/groups/2/data_sources endpoint=group_data_sources status=500 content_type=application/json content_length=36 duration=34.64 query_count=7 query_duration=11.88
And, here is my docker-compose.yml
version: "3.3"
services:
x-redash-service: &redash-service
image: redash/redash:10.1.0.b50633
env_file: /opt/redash/redash_env
restart: always
redash_server:
<<: *redash-service
command: server
ports:
- 5000:5000
environment:
REDASH_WEB_WORKERS: 4
scheduler:
<<: *redash-service
command: scheduler
scheduled_worker:
<<: *redash-service
command: worker
environment:
QUEUES: "scheduled_queries schemas"
WORKERS_COUNT: 1
adhoc_worker:
<<: *redash-service
command: worker
environment:
QUEUES: "queries"
WORKERS_COUNT: 2
worker:
<<: *redash-service
command: worker
environment:
QUEUES: "periodic emails default"
WORKERS_COUNT: 1
redis:
image: redis:5.0-alpine
restart: always
postgres:
image: postgres:9.6-alpine
env_file: /opt/redash/redash_env
volumes:
- /opt/redash/postgres-data:/var/lib/postgresql/data
restart: always
nginx:
image: redash/nginx:latest
ports:
- 80:80
- 443:443
volumes:
- /opt/redash/nginx/nginx.conf:/etc/nginx/conf.d/default.conf
- /opt/redash/nginx/certs:/etc/letsencrypt
- /opt/redash/nginx/certs-data:/data/letsencrypt
restart: always
Thanks,
