-
Notifications
You must be signed in to change notification settings - Fork 2.8k
avoid setting up hdb_views schema on schema sync refreshing cache #2098
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
Conversation
|
Deploy preview for hasura-docs ready! Built with commit e95ab79 |
|
Review app for commit 3a73073 deployed to Heroku: https://hge-ci-pull-2098.herokuapp.com |
|
Review app for commit 7f1a700 deployed to Heroku: https://hge-ci-pull-2098.herokuapp.com |
|
Review app for commit adf32fc deployed to Heroku: https://hge-ci-pull-2098.herokuapp.com |
|
Review app for commit cbce986 deployed to Heroku: https://hge-ci-pull-2098.herokuapp.com |
This becomes useful when a lot of schema change events happen while we are still processing an earlier event.
|
Review app for commit e95ab79 deployed to Heroku: https://hge-ci-pull-2098.herokuapp.com |
|
Review app https://hge-ci-pull-2098.herokuapp.com is deleted |
* build schema cache function without db setup The setup shouldn't happen for sync. The database is already setup by the instance which generated the event. This means that the sync is now faster. * use SQL loop to drop hdb_views schema views and routines with ordering This avoids deadlocks when schema is being changed concurrently * schema sync now only processes the latest event This becomes useful when a lot of schema change events happen while we are still processing an earlier event.
…ror (#2098) <!-- The PR description should answer 2 important questions: --> ### What `Built-in operators require a boolean expression type` shows up as an internal error, when it's really because a boolean expression type hasn't been provided for a type. Change the type to reflect this, and include the object type name in question to make it easier to fix. V3_GIT_ORIGIN_REV_ID: 89fae7521fd9fe1135bfb5c8c9d44c07fc1d93cb
Description
Affected components
Related Issues
Solution and Design
hdb_viewsschema.hdb_viewsschema's views and routines in order in SQLfor loop.Steps to test and verify