View queries results become unavailable when changes are made to objects in the view. For example, when a user starts a process to update thousands of files, any query against a view containing the updated files will show a status of:
"Waiting for the table index to become available..."
until all asynchronous processing completes.
In the example described in PLFM-5953, queries against view syn9630847, were unavailable for twelve hours due to this issue.
The proposal is to change view queries such that view query results are always be available. Specifically, users should be able to see the out-of-data view results while changes are being asynchronously processed.