Azure Cosmos db(Mongodb) transactional(Multi-document transactions cannot be run in a sharded collection)

Question

when I add @Transactional on method, which add or update document
in method i call resp(extends MongoRepository) to add or update document
then error happen
There was an unexpected error (type=Internal Server Error, status=500).
Command failed with error 50841 (50841): 'Multi-document transactions cannot be run in a sharded collection' on server

I found that cosmos db's mongodb is 4.0
Is there has some way to using transactional in spring data connect cosmosdb(mongodb) ?

Answer 1

Hi @Anonymous Thank you for posting your questions .
Which command are you using? Azure Cosmos DB supports automatic, server-side sharding. It manages shard creation, placement, and balancing automatically. Azure Cosmos DB does not support manual sharding commands, which means you don't have to invoke commands such as addShard, balancerStart, moveChunk etc. You only need to specify the shard key while creating the containers or querying the data.

Please see the supported cosmos DB's for MongoDB API Version 4.0
https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/feature-support-40#transactions

Regards,
Oury