Transactions always rolling back?

[craigsmitham]

I've used both createOptimisiticAction and createTransaction but it always seems to rollback the optimistic changes. The MutationFn is completing successfully and the transaction says it was completed and the original/after state looks correct for the mutations. Do I need to be returning something in my MutationFn?

[KyleAMathews]

Optimistic changes are always rolled back when the mutationFn returns. So before the mutationFn returns, you need to make sure the server change has been synced back into the collection. E.g. here it calls await collection.utils.refetch() https://tanstack.com/db/latest/docs/overview#explicit-transactions

[craigsmitham]

thanks!

[craigsmitham]

keep up the good work, enjoy working with Tanstack DB far!