Are concurrent inserts and updates not possible on Convex?
I have a table called
taskExecutions which has a status and startAt field with an index on them - 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 and startAt<=current_time-500ms. These index ranges should never conflict and new inserted documents have startAt more than the current time and the updates are doing updates on documents with olders startAt. But I'm getting OCC errors almost every time. What am I doing wrong?
