No results from sql query

Hello,
I’m using redash inside docker.
Many time when i try to make a query to the sql db, I’m not getting any results at all, while if i query the db from his client, I get the results in a few seconds.
I found out out that if i restart the docker, it helps , but again after some time the problem start again.
any help?

Thanks

What kind of resources did you dedicate to your Docker container? Sounds like it might be running out of memory. Have you checked Redash’s logs?

I Can see two errors from the redash_server_1 logs:

  1. ResponseError: MISCONF Redis is configured to save RDB snapshots, but it is currently not able to persist on disk. Commands that may modify the data set are disabled, because this instance is configured to report errors during writes if RDB snapshotting fails (stop-writes-on-bgsave-error option). Please check the Redis logs for details about the RDB error.

  2. (“No usable temporary directory found in %s” % dirlist))
    IOError: [Errno 2] No usable temporary directory found in [’/tmp’, ‘/var/tmp’, ‘/usr/tmp’, ‘/app’]