Relation "query_results" does not exist


#1

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


#2

Make sure you’re running the command with the correct configuration/user (if this is our AMI, try prefixing the command with sudo -u redash bin/run ...).


#3

Hi arikfr,
we were running using redash user, the problem is not that one.

Fortunately we don’t need to run the task anymore.