Hi Team,
we have pinot as persistence layer in our analytics application. what i have observed when we upgrade our application that along with application when pinot pods are also restarted. post restarting tables go in BAD state not the case always.
based on my past experience this generally seems to happen as segments go in BAD state as their ideal state and external view state do not match. it seems to me that some segments are in BAD state as during redeployment state transitions got stuck while others segments are in BAD state as sync between states in views is not longer maintained.
what is the recommended approach when upgrading. below is what i can think of kindly confirm if this indeed is recommended or point me to the right process.
1> Disable all tables using API to stop querying and ingestions.
2> Commit all current consuming segments using API.
3> Upgrade.
4> Enable state of all tables so new segments start generating and DB is available for querying again.
Regards