Hi all,
Redash Version: redash.4.0.1.b4038/
Ubuntu: Ubuntu 14.04.4
When trying to run redash.tasks.cleanup_query_results
we get the following error:
ProgrammingError: (psycopg2.ProgrammingError) relation "query_results" does not exist
LINE 1: DELETE FROM query_results WHERE query_results.id IN (SELECT ...
^
[SQL: 'DELETE FROM query_results WHERE query_results.id IN (SELECT query_results.id \nFROM query_results LEFT OUTER JOIN queries ON query_results.id = queries.latest_query_data_id \nWHERE queries.id IS NULL AND query_results.retrieved_at < %(retrieved_at_1)s \n LIMIT %(param_1)s)'] [parameters: {'retrieved_at_1': datetime.datetime(2017, 5, 10, 9, 48, 45, 422858), 'param_1': 10}]
Our redash is working correctly and from the re:dash metadata data source we do see the query_results table.
Any idea on how to solve this?
Thank you