Rash1d
1
@jesse
Redash V10 - Not able to use SQL server datasource to create new queries, not loading schema as well as not saving the query even if you write everything manually.
V8 is working fine with similar setup.
jesse
3
Sorry to hear about this. What errors do you see in your server logs?
sudo docker-compose logs
I’m not aware of any issues with MSSQL on V10.
Rash1d
4
@jesse - we were able to resolve the schema loading issue. However we are facing a new issue now, where scheduled query refresh is not working and even the manual refresh doesn’t work until you make some dummy edit to the query and save it and then it executes.
we have below containers running
jesse
5
For posterity, what was the issue here?
Weird. Does this query use parameters? How do you know that it doesn’t execute unless you make a change?
jesse
7
Sorry you haven’t answered my questions.
Rash1d
8
we are not using query param.
it says query in queue, we need to cancel manually. It works fine in our V8 setup, reschedule as well as manual refresh.
jesse
9
Thank you that’s helpful. This indicates that a query execution job was created but no worker picked it up from the queue. What queues are your workers monitoring? Can you shared your docker-compose.yml file?
Rash1d
10
command:
- /bin/sh
env:
- name: QUEUES
value: queries,celery,schemas
- name: WORKERS_COUNT
value: "4"
Note: that’s not a docker_compose.yml file. Do you happen to be using k8s?
It’s clear what is your problem: that configuration won’t work for V10. It looks like you copied something from an V8 deployment, not V10. Maybe you started from the getredash/setup repository? It hasn’t been updated since V8.
Either way, you need to configure your queues differently for V10. Without knowing how you set up Redash it’s hard to know the best set of instructions to send you. But the release notes from V10.1 (the latest release) should point you in the right direction:
jesse
12
Speaking more broadly, it would be helpful to know what instructions you followed to end in this state? We want to make the developer onboarding experience for Redash as painless as possible. If you can link to the instructions you followed I can take a stab at updating them.
Rash1d
13
we followed below but did some customization to make it work with our Kubernetes deployment pipeline. I can share the deployment.yaml if that wd help
jesse
14
k8s is not formally supported for Redash so you’re somewhat flying blind here. I’m happy to take a look but I can’t guarantee a result.
jesse
15
I can see how you ended up with the environment variables you did, though. Because the instructions you linked point to our setup repository which hasn’t been updated in a few years. Please go ahead and post your deployment.yaml and I will advise on which env vars need to be corrected.
