Way to invalidate schema cache quickly
As part of FCL, we should improve time to mitigation when we encounter errors like ERROR: each UNION query must have the same number of columns
One idea is to invalidate schema cache quickly
Ideas:
- Redis Watcher #412980 (comment 1404785697)
- Restart pods using liveness
- rescue from error <==== we pick this one
Proposal
In the event of a error ERROR: each UNION query must have the same number of columns, we reset the Rails column information.
This will then allow subsequent requests to recover
Edited by Thong Kuah