A summary of the issue and the browser/OS environment in which it occurs.
- Redash Version: 4.0.1.b4038 / 7.0.0.b18042
- Browser/OS: Firefox/Chrome/Safari Ubuntu 18.04/Mojave
- How did you install Redash: docker-compose, image: redash:7.0.0.b18042
Hi, I have a problem with removing Postgresql data sources in Redash. In our process, we’re constantly adding/removing whole db’s, so there’s a lot of data sources added/removed to/from Redash on a regular basis.
My problem occurs inconsistently, because it can either happen or not, for the sources coming from the same DB. For example:
There’s 2 datasources pointed to the same endpoint, same authentication (same postgres user/pass), just different db names. Both of them had the same queries and dashboards. Then, I can easily delete one, but not the other (it get’s stuck on deleting process, then error “failed to delete data source” shows up). Sometimes, manually removing (unpublishing, then archiving) all related dashboards/queries help, but that is also inconsistent. For example, right now I am stuck with a datasource that no longer exists (db was purged), no dashboard/query uses it, yet still, I’m unable to remove it from data sources on Redash.
Is there any reason said behaviour is happening? It’s possible I’m doing things in the wrong order, so I’d like to know, what is a “proper” way to remove a data source? Is there a single operation that removed a data source and all related queries/dashboards?
At the moment, the process that works most of the time is:
- Downing the DB
- Purging aforementioned DB out of existence
- Removing data source from Redash
- If point 3 fails, then manually remove (unpublish/archive) all related dashboards/queries to said DB and trying point 3 again.
- If point 4 fails, get stuck with a data source that isn’t used anywhere and cannot be removed.