Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

One failed matview refresh causes all matview refreshes to fail #77

Open
kennsippell opened this issue Mar 31, 2021 · 2 comments
Open

Comments

@kennsippell
Copy link
Member

https://github.com/medic/config-muso/issues/228

A single bad matview(ownership or syntax problem) will result in all materialised views not being refreshed. When working collaboratively in a database (eg. data scientists, vendors, medic personelle, partner personelle) this can mean that one mistake from one person results in live-site incident with stale data and stale queries for all.

@Marina-Kenf
Copy link

It will be good if a fix is implemented as soon as possible. This is highly impacting Muso's internal dashboard that is supposed to provide them with details on their worker's weekly activities.

@kennsippell
Copy link
Member Author

@Marina-Kenf This is a longer-term fix and it will take time - we likely shouldn't count on it urgently. In the meantime, please work with the SRE team to mitigate the impacts that are happening with Muso - we gotta be vigiliant to get permissions right and ensure there are no crashing matviews.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants