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?1 Reply
Thanks for posting in <#1088161997662724167>.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.
- Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
- Use search.convex.dev to search Docs, Stack, and Discord all at once.
- Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI.
- Avoid tagging staff unless specifically instructed.
Thank you!