1 reply

Are concurrent inserts and updates not possible on Convex?

I have a table called

taskExecutions

taskExecutions

which has a

status

status

and

startAt

startAt

field with an index on them -

index('by_status_startAt', ['status', 'startAt'])

index('by_status_startAt', ['status', 'startAt'])

. During some intervals I'm inserting a lot of new documents and updating a lot of documents which have

status=ready

status=ready

and

startAt<=current_time-500ms

startAt<=current_time-500ms

. These index ranges should never conflict and new inserted documents have

startAt

startAt

more than the current time and the updates are doing updates on documents with olders

startAt

startAt

. But I'm getting OCC errors almost every time. What am I doing wrong?