Missing order by on nextNotLeased
in stateful entity store (SQL)
#4308
Labels
bug
Something isn't working
nextNotLeased
in stateful entity store (SQL)
#4308
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: