Skip to content

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:

  1. Redis Watcher #412980 (comment 1404785697)
  2. Restart pods using liveness
  3. 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