You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Implementations of SQL variant StateEntityStore for the nextNotLeased method miss the order by
when looking for the next items to process. This could lead to starvation for some state and it could
prevent some optimization (index creation) when fetching the items to process.
Observed Behavior
For example putting an index like this
CREATEINDEXIF NOT EXISTS transfer_process_state
ON edc_transfer_process (state);
Makes the NextNotLeased.avoidsStarvation on TransferProcessStoreTestBase fails
Possible Implementation
add order by state_time_stamp on QuerySpec in all nextNotLeased SQL implementation
The text was updated successfully, but these errors were encountered:
Bug Report
Describe the Bug
Implementations of SQL variant
StateEntityStore
for thenextNotLeased
method miss the order bywhen looking for the next items to process. This could lead to starvation for some state and it could
prevent some optimization (index creation) when fetching the items to process.
Observed Behavior
For example putting an index like this
Makes the
NextNotLeased.avoidsStarvation
onTransferProcessStoreTestBase
failsPossible Implementation
add order by
state_time_stamp
onQuerySpec
in allnextNotLeased
SQL implementationThe text was updated successfully, but these errors were encountered: