View query results should always be available

Description

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.

Environment

None

Status

Assignee

John Hill

Reporter

John Hill

Labels

None

Validator

Bruce Hoff

Development Area

None

Release Version History

None

Components

Priority

Major
Configure